MaxHealth is seeking a Data Engineer (ETL Developer) to modernize and optimize their data pipelines to support analytics and reporting needs, ensuring accurate, timely, and secure data delivery, with a focus on healthcare data.
Requirements
- 5+ years of professional experience in ETL development and SQL-based data warehouse engineering.
- Strong expertise with SQL Server Integration Services (SSIS), and T-SQL.
- Proven experience integrating and transforming healthcare payer data (claims, eligibility, encounters).
- Proficiency with Git or other version control systems for code management.
- Experience supporting data visualization/reporting in Power BI and Domo.
- Strong understanding of data modeling, normalization, indexing, and query optimization.
- Experience with Azure Data Factory or Fabric (or similar), other Azure services (Azure SQL Database, Data Lake, Synapse).
Responsibilities
- Design, develop, and maintain modernized ETL pipelines using Azure Data Factory, Fabric, Databricks and/or SSIS to integrate multiple data sources into the enterprise data warehouse.
- Optimize and refine existing ETL processes to improve performance, scalability, and maintainability.
- Develop and maintain and/or convert SQL stored procedures, views, functions, and scripts for analytics and reporting.
- Implement data quality checks, error handling, and monitoring to ensure accurate and consistent data flows.
- Utilize a code repository (Git or similar) to manage, version, and document ETL code.
- Support integration of healthcare data sources, including claims, eligibility, provider rosters, and quality/risk adjustment data.
- Collaborate with the BI team to deliver data models and datasets for dashboards in Power BI and Domo.
Other
- Collaborate with analysts, data scientists, and business stakeholders to deliver clean, reliable, and well-structured data.
- Partner with business teams to enable HEDIS measure calculation, quality reporting, and risk adjustment analytics.
- Ensure adherence to data governance, compliance, and security best practices (HIPAA, PHI/PII handling).
- Troubleshoot data issues, perform root cause analysis, and implement preventive measures.
- Strong problem-solving skills and ability to communicate technical concepts to non-technical stakeholders.
