Data Engineer (ETL Developer) POST NUMBER: 457445
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.
Vaco by Highspring values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com .
Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.
By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco by Highspring and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco by Highspring”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.