Data Warehouse Architect / Developer

Job Title Location Duration
Data Warehouse Architect / Developer Greater Hartford Area, CT Extended
Job Description
The scope of services required for the Data Warehouse Architect/Developer includes:

  • Develop and support end to end enterprise data warehouse and BI solutions for business and management teams.
  • Create and maintain complex SSIS ETL packages and SSRS reports.
  • Create and maintain complex MDX queries against SSAS cubes.
  • Create complex queries, data transformation, aggregation, stored procedures and triggers.
  • Develop ad-hoc SQL to research data questions.
  • Performance-tune ETL, stored procedures, and reports to keep databases optimized.
  • Troubleshoot ETL failures and devise corrective actions.
  • Perform code reviews, data validation, and system testing for data warehouse changes.
  • Interact closely with members of both IT and business staff members.
Job Skills
The minimum skills and experience levels required for a candidate to be considered for this position include:

  • Minimum of 5 years of experience using Microsoft SQL Server and T-SQL.
  • Minimum of 3 years of experience using SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).
  • Experience developing complex MDX queries to access SSAS cubes.
  • Ability to design and implement changes to existing data warehouse and cubes.
  • Ability to provide time estimates for assignments and meet scheduled deadlines.
  • Ability to interpret and translate high-level Business Requirements into a detailed Design Specification.
  • Ability to perform Quality Assurance Testing of Applications, Reports, etc…from Requirements\Design Specifications and document software discrepancies.
  • Ability to learn\query the various data source systems in order to verify the accuracy of code when compared to the written Specifications.
  • Ability to create\write Test Plan(s) from Requirements\Design Specifications when requested.
  • Ability to resolve software discrepancies and re-test until all known Issues have been resolved.
  • Excellent written and verbal skills required.
  • Must be a Team player.
  • The ability to do ad-hoc SQL to research data questions, identify root causes and interact closely with peers and business users is essential.