The world’s largest collection of jobs backed by Venture Capital & Private Equity firms


Lead Data Engineer, MCR Stars



Data Science
Moon, PA, USA
Posted on Monday, June 10, 2024

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.

Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.

Position Summary:

This is a hybrid role, requiring working 3 days a week from the office.

Aetna, a CVS Health company, is the nation's premier health innovation company helping people on their path to better health. We are building a new health care model that is easier to use, less expensive, and puts the consumer at the center of their care.

Aetna's Medicare Stars Team is growing and expanding! This is exciting opportunity to join a high performing, collaborative team as a Lead Data Engineer. This individual will focus on evolving the Stars Data Engine to a new Ecosystem that allows for expanding our data ingestion footprint while increasing data security, reducing data replication and becoming a more real-time solution related to the data outputs. This position will manage and be responsible for the successful delivery of large-scale data structures and Pipelines and efficient Extract/Load/Transform (ETL) workflows. Acts as the data engineering team lead for large and complex projects involving multiple resources and tasks, providing individual mentoring in support of company objectives. This individual will need to apply Rapid Application Development and Lean techniques in order to direct work assignments and provide mentoring to junior staff to successfully direct the improvements to the Data Engine Framework to support the constituent needs of the various Medicare Business units. The individual will help manage the evolution to a self-organizing, cross functional team structure that leverages iterative Delivery Processes with a focus on continuous delivery of valuable software. This is a telework arrangement and we will consider any individuals eligible for work in the US.

This position will be focused primarily on supporting our on-going collaboration with the Stars Member Experience team and supporting the expansion of collection of Member Survey Data, transforming that data, and loading into the Stars Datamart. Another component of this position is assisting with the development of a strategy for migration from our On-Prem infrastructure to a cloud-based model.

Fundamental Components:

– Analyze science, engineering, business and other data processing problems to implement and improve computer systems.

– Perform advanced SQL Programming in data warehouse environment including use of different analysis techniques or business intelligence application development.

– Manage, build, enhance, architect and maintain the Medicare Stars Data Engine.

– Process large data sets through complex ETL to our Medicare Star Data Engine.

– Explore, examine, and interpret large volumes of data in various forms.

– Perform analysis of structured and unstructured data to solve moderately complex business problems.

– End to end testing of the Medicare Stars data warehouse data and implement appropriate validation controls to control data quality.

– Develop automated data quality scripts to ensure the data integrity and completeness of the data.

– Design and conduct analysis and outcome studies using healthcare claims, pharmacy, and lab data, employing appropriate research designs and statistical methods.

– Develop, validate, and execute algorithms, data models and reporting tools that answer applied research and business questions for internal and external clients.

– Define and deliver analytical solutions in support of healthcare business initiatives that drive short and long-term objectives.

– Applies understanding of key business drivers to accomplish own work.

– Uses expertise, judgment, and precedents to contribute to the resolution of moderately complex problems.

– Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.

– Collaborates with client team to transform data and integrate algorithms and models into automated processes.

– Uses knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries to build data pipelines.

– Uses programming skills in Python, Visual Studio, C#, SSIS or any of the major languages to build robust data pipelines and dynamic systems.

– Prior experience leading Cloud technologies including: GCP, Azure and Azure Data Factory

– Builds data marts and data models to support clients and other internal customers.

– Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.

Required Qualifications:

-Strong collaboration and communication skills within and across teams.

-Ability to communicate technical ideas and results to non-technical clients in written and verbal form.

-Proven ability to create innovative solutions to highly complex technical problems.

-Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources.

-Ability to understand and build complex systems and solve challenging analytical problems.

-Advanced knowledge in SQL Server and/or DB2, SSIS, Microsoft .Net Framework, ASP, C#, Visual Studio, SAS, & SQL or similar.

-knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.

-Experience building and implementing data transformation and processing solutions.

-Has in-depth knowledge of large-scale search applications and building high volume data pipelines.

-Multiple years of progressively complex related experience.

Preferred Qualifications:

You should:

• Have a passion to help transform health care

• Have strong Interest in Health Care

• Be able to work in a fast-paced environment and meet tight deadlines

• Possess strong analytical and problem resolution skills

• Be able to communicate effectively with a diverse audience

• Encourage teamwork and a positive environment to improve team effectiveness

• Be resourceful and can quickly and successfully adapt to change

• Have an interest in obtaining full-time position within CVS Health

• Prior Database modeling experience preferred


Bachelor's degree or equivalent work experience in Computer Science, HealthCare Informatics, Computer Engineering, Information Systems, Machine Learning, or related discipline.

Pay Range

The typical pay range for this role is:

$118,450.00 – $247,200.00

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. This position also includes an award target in the company’s equity award program.

In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies.

For more detailed information on available benefits, please visit jobs.CVSHealth.com/benefits

We anticipate the application window for this opening will close on: 06/30/2024