Senior Data Engineer – HEDIS Quality, Validation & Automation

CVS Health • Hartford, CT

1d

About The Position

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Senior Data Engineer – HEDIS Quality, Validation & Automation Position Overview CVS Health is seeking a highly experienced Senior Data Engineer specializing in data testing, automation, and healthcare quality reporting to support HEDIS and Quality Measures Domain within the Aetna Data Services and Operations organization. This role is responsible for engineering automated data quality, validation, and observability solutions that ensure the accuracy, reliability, and regulatory compliance of healthcare data used for HEDIS, STARS, NCQA, and IDSS reporting. The position plays a critical role in strengthening audit readiness, improving reporting accuracy, and enabling data‑driven performance improvement across Medicare, Medicaid, and Commercial lines of business. The ideal candidate combines deep healthcare domain expertise with strong data engineering, SQL, and automation skills, and brings a prevention‑first mindset—building scalable frameworks that proactively detect and eliminate data issues before they impact business, regulatory, or member outcomes. This role partners closely with ETL engineers, analytics teams, business stakeholders, and compliance partners in an agile, cross‑functional environment.

Requirements

• 10+ years of experience in data engineering, data quality, and test automation, supporting large‑scale enterprise data platforms.
• Deep expertise in healthcare quality programs (HEDIS, STARS, NCQA, IDSS), with hands‑on experience improving reporting accuracy, strengthening compliance, and supporting data‑driven performance improvement.
• Strong experience designing and implementing enterprise data testing strategies for ETL pipelines, data warehouses, and analytics platforms.
• Advanced proficiency in SQL, including complex queries for profiling, reconciliation, healthcare measure validation, and root‑cause analysis.
• Experience supporting cloud‑based data platforms, preferably Google Cloud Platform.
• Hands‑on experience with Ab Initio, including validation of complex transformations and dependencies.
• Experience working with relational and analytical databases such as DB2, SQL Server, and BigQuery.
• Proven expertise building automated data validation and regression testing frameworks using Python and SQL‑driven utilities.
• Strong experience implementing monitoring, alerting, and data observability solutions for production data environments.
• Knowledge of HIPAA, data governance, and test data management, including de‑identification and compliance requirements.
• Experience working in Unix/Linux environments supporting large‑scale batch and scheduled data workloads.

Nice To Haves

• Experience leading or mentoring data testing / QA engineers within agile POD‑based delivery models.
• Hands‑on experience integrating automated data tests into CI/CD pipelines.
• Prior experience modernizing or migrating data platforms from on‑prem to cloud environments.
• Strong communication skills with the ability to collaborate effectively with engineering, analytics, and business stakeholders in regulated environments.

Responsibilities

• Data Testing & Automation Engineering Design, build, and maintain enterprise‑grade automated data testing frameworks to validate data completeness, accuracy, consistency, and timeliness across ETL pipelines and reporting layers.
• Develop reusable data quality rules, reconciliation logic, and control checks aligned to healthcare quality program requirements.
• Implement automated regression testing for ETL jobs, SQL transformations, and downstream analytics to ensure release confidence and production stability.
• Engineer Python‑ and SQL‑based automation utilities to validate counts, duplicates, mismatches, missing data, and measure outputs across heterogeneous data sources.
• Healthcare Quality & Regulatory Reporting Apply deep domain knowledge of HEDIS, STARS, NCQA, and IDSS to ensure data pipelines and outputs meet regulatory, audit, and submission standards.
• Support annual HEDIS / STARS cycles, including measure updates, validation, reconciliation, and submission readiness activities.
• Build and maintain automated validation solutions for measure outputs, XML files, PLD files, and reporting artifacts, improving accuracy and reducing manual effort.
• Partner with business and compliance stakeholders to translate regulatory requirements into repeatable, automated data quality controls.
• Observability, Monitoring & Operational Excellence Implement data observability, monitoring, and alerting solutions to proactively identify anomalies, pipeline failures, and SLA risks.
• Perform root‑cause analysis of data issues and production incidents, and implement preventive automation to eliminate recurring defects.
• Improve operational readiness through automated health checks, dashboards, runbooks, and post‑production validation frameworks.
• Promote engineering excellence by simplifying, optimizing, and standardizing data quality and testing practices.
• Collaboration & Delivery Partner with ETL engineers and platform teams to embed testability and quality controls by design into data pipelines.
• Work within an Agile/Scrum delivery model, contributing to sprint planning, backlog refinement, demos, UAT, and release validation.
• Provide technical guidance and mentorship to data testing and automation engineers, fostering a culture of quality and continuous improvement.

Benefits

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level