Overview
Hybrid
$65
Contract - Independent
Contract - W2
Job Details
Position Summary
We are seeking a highly skilled Data Engineer (ETL Developer) to join our data engineering team to modernize and optimize our data pipelines. The Data Engineer (ETL Developer) will be responsible for designing, building, and maintaining scalable ETL pipelines to support our analytics and reporting needs. This individual will leverage Azure Data Factory (ADF), SQL Server Integration Services (SSIS), SQL Server, and modern BI platforms (Domo and Power BI) to ensure accurate, timely, and secure data delivery. The ideal candidate will have experience with healthcare data including: payer raw data, NCQA HEDIS quality data, and Medicare Risk Adjustment datasets.
Key Responsibilities
Required Qualifications
Preferred Skills
Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan.
We are seeking a highly skilled Data Engineer (ETL Developer) to join our data engineering team to modernize and optimize our data pipelines. The Data Engineer (ETL Developer) will be responsible for designing, building, and maintaining scalable ETL pipelines to support our analytics and reporting needs. This individual will leverage Azure Data Factory (ADF), SQL Server Integration Services (SSIS), SQL Server, and modern BI platforms (Domo and Power BI) to ensure accurate, timely, and secure data delivery. The ideal candidate will have experience with healthcare data including: payer raw data, NCQA HEDIS quality data, and Medicare Risk Adjustment datasets.
- 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.
- Collaborate with analysts, data scientists, and business stakeholders to deliver clean, reliable, and well-structured data.
- 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.
- Partner with business teams to enable HEDIS measure calculation, quality reporting, and risk adjustment analytics.
- Collaborate with the BI team to deliver data models and datasets for dashboards in Power BI and Domo.
- 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.
- Bachelor’s degree in Computer Science, Information Systems, or a related field; or equivalent experience.
- 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.
- Strong problem-solving skills and ability to communicate technical concepts to non-technical stakeholders.
- Familiarity with HIPAA compliance, data privacy, and PHI/PII handling.
- Experience with Azure Data Factory or Fabric (or similar), other Azure services (Azure SQL Database, Data Lake, Synapse).
- Working knowledge of NCQA HEDIS quality measures and related data sets.
- Experience with Medicare Risk Adjustment (HCC coding, RAF scores) data structures and reporting.
- Background in healthcare analytics, value-based care, or health plan operations.
- Familiarity with APIs, scripting (Python/PowerShell), and automation for data pipeline orchestration.
Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.