Data Engineer with HEDIS (Healthcare)

Job Description: Data Engineer (HEDIS Data Mart)

Location: United States (Remote)

Job Type: Full-time/ Contract

Duration: 6 months OR FTE

Job Summary:

We are looking for skilled Data Engineers to develop and optimize the HEDIS Data Mart. This role requires expertise in ETL/ELT, big data processing, and cloud-based data platforms to support healthcare analytics. The Data Engineers will work closely with Data Analysts to ensure high-quality, efficient, and scalable data pipelines.

Key Responsibilities:

1. Data Pipeline Development & Automation:
   • Develop and maintain ETL/ELT pipelines to load healthcare data into the HEDIS Data Mart.
   • Automate data ingestion and transformation workflows using Azure Data Factory (ADF), PySpark, and Databricks.
   • Optimize SQL queries and data processing logic for performance and scalability.

2. Data Modeling & Storage:
   • Design and implement data models to support HEDIS analytics and reporting.
   • Ensure efficient storage and retrieval of Claims, Clinical, Labs, Immunization, and Encounter data.
   • Implement data partitioning, indexing, and caching strategies for performance tuning.

3. Data Quality & Governance:
   • Implement data validation, anomaly detection, and reconciliation processes.
   • Work with the Lead Data Analyst to ensure compliance with HEDIS data quality standards.
   • Develop and maintain data lineage and metadata management frameworks.

4. Collaboration & Support:
   • Work closely with Data Analysts to understand reporting and analytics needs.
   • Provide support for troubleshooting data issues and optimizing query performance.
   • Document ETL workflows, data models, and system configurations.

Required Qualifications & Skills:

Technical Expertise:
• Databases: SQL Server, Databricks
• ETL & Workflow Automation: SSIS, ADF (Azure Data Factory)
• Programming: Python, SQL, PySpark
• Cloud & Storage: Azure, AWS (preferred Azure)

Healthcare Data Knowledge:
• Exposure to Claims, Clinical, Lab, Immunization, and Encounter data.
• Understanding of HEDIS quality measures and data submission processes.

Soft Skills:
• Strong problem-solving and troubleshooting skills.
• Ability to collaborate with cross-functional teams and work independently.
• Excellent written and verbal communication skills.

Preferred Qualifications:
• Experience Datawarehouse, ETL/ELT, Data Modeling
• Exposure to FHIR, HL7, and healthcare interoperability standards.