Data Warehouse Engineer

ExpertsHub.ai; Chicago (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology consultancy is seeking a Data Warehouse Developer responsible for designing and maintaining data warehousing solutions using Microsoft technologies. This role involves optimizing ETL processes, creating reports and dashboards, and ensuring data flow accuracy while adhering to healthcare regulations. Candidates must have strong SQL skills and experience with SSIS and SSRS. This contract position is aimed at mid-senior level professionals with an emphasis on communication and teamwork.

Qualifications

• 6+ years of experience as an ETL Developer in data integration.
• Strong proficiency in optimization of SQL queries.
• Experience with Microsoft technologies including SSIS and SSRS.

Responsibilities

• Develop and optimize complex SQL queries for data extraction, transformation, and loading.
• Implement and maintain ETL processes and maintain technical documentation.
• Create and maintain SSRS reports and dashboards.

Skills

ETL Development

SQL development and optimization

SSIS

SSRS

Visual Studio

Defect tracking tools (Jira, Azure DevOps)

Job description

Job Summary

The Data Warehouse Developer is responsible for designing, developing, and maintaining data warehousing solutions using Microsoft technologies. This role involves building and optimizing ETL processes, creating reports and dashboards, and ensuring accurate data flow across multiple systems while adhering to regulatory standards.

Mandatory

Please make sure relevant experience with Microsoft Databases technical stack is strongly demonstrated.

Domain Experience

Good to have healthcare experience.

Key Responsibilities

• Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.
• Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow.
• Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions.
• Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs.
• Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives.
• Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning.
• Create and maintain SSRS reports and dashboards, delivering actionable insights to business users.
• Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems.
• Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation.
• Log, track, and manage defects using tools such as Jira or Azure DevOps, collaborating closely with testers and other data engineers to resolve issues and provide fixes.
• Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements.

Required Qualifications

• Strong proficiency in SQL development and optimization.
• Hands‑on experience with SSIS, SSRS, and Visual Studio for ETL and reporting.
• Knowledge of data warehousing architecture, modeling, and performance tuning.
• Familiarity with defect tracking tools such as Jira or Azure DevOps.
• Excellent communication skills and ability to work independently or in a team environment.
• Understanding of healthcare regulatory standards (e.g., HIPAA) and compliance requirements.

Skills

• Skill 1 – years of Exp – 6+-ETL Developer / Data Integration – Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.
• Skill 2 – years of Exp – 6+ – maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs.
• Skill 3 – years of Exp – 6+ – Create and maintain SSRS reports and dashboards, delivering actionable insights to business users.
• Skill 4 – years of Exp – 6+ – Log, track, and manage defects using tools such as Jira or Azure DevOps.

Additional Information

• Seniority level: Mid‑Senior level
• Employment type: Contract
• Job function: Information Technology
• Industry: Software Development