Job Description :

Role: Data Analyst
Only Local - MD, VA, DC

Location: Chevy Chase MD
Duration: Long Term
Only GC, Citizen

Job Description:

  • Map data from source system to destination system
  • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments
  • Designs dimensional models with conformed dimensions, following the business' processes
  • Review and consolidate data definition and dictionary documentation
  • Create data flow diagrams
  • Establish and maintain mapping documents and data dictionaries
  • Identify and resolve data integrity issues
  • Document data transformation and validation rules
  • Provide input into proposed solutions and work with team to implement solutions
  • Work independently to ensure work in completed on time and meets expectations
  • Ability to develop mutually beneficial relationships with both technical and business teams
  • Identify risks and issues
  • Develops and automates ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS)
  • Creates processes for maintaining or/and capturing metadata
  • Studies and understands the company's business processes and applications, including their effect on data and reporting, and applies the knowledge gained in designing data warehouses and reports
  • Identifies and documents all requirements for both fresh and current data warehouse components and reports by working with end users
  • Assembles performance statistics, analyzes them, and makes recommendations for improvements
  • Establishes system documentation and ensures it is continually sustained.

Technical Skills:

  • Understanding of Data Validation rules
  • Understanding of Data Structures
  • Elicitation and analysis of technical requirements
  • SQL Server, SQL Queries, Oracle
  • SAS also would be a plus
  • Prior experience as a technical BA

Similar Jobs you may be interested in ..