PBM Data Engineer

Data Engineer

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

CVS Health has an exciting opportunity to join our PBM Reporting group as a Data Engineer within our Reporting Solutions team. CVS Health strives to continuously innovate around how we report and analyze data, improve operational efficiency, and deliver outstanding customer service.

You will work with a collaborative, close-knit team on pharmacy and member specific claims data including, but not limited to, financial and operational information supporting state and federal compliance reporting. You will be responsible for design, build, and maintenance of data pipelines and architecture for reporting and data analytic needs in a highly collaborative team. You will report to the Sr. Manager within the Reporting Solutions team. To be successful in this role, you need to have solid SQL skills, be comfortable with working in a fast-paced environment, have attention to detail, and be a team player with a strong drive for fostering collaboration, knowledge sharing, and continuous improvement.

Key Responsibilities

• Design, build, and maintain data pipelines and architecture for reporting and data analytic needs.
• Establishes ETL processes and data integration steps to load data into a reporting platform.
• Design and Implements data quality checks and validation processes to ensure the accuracy, completeness, and consistency of the data.
• Work with cross-functional teams to identify report requirements, gather data, and ensure timely delivery of data and report solutions.
• Design and optimize data sources and processes for efficient data storage and retrieval.
• Designs data warehousing and data lake solutions that facilitate data storage, retrieval, and analysis.
• Documents data engineering processes, workflows, and systems for reference and knowledge-sharing purposes.
• Identifies opportunities to streamline data engineering processes, improve efficiency, and enhance the quality of deliverables.

Required Qualifications

2+ years of experience supporting reporting, analytics, or automation projects

2+ years of experience and proficiency in writing scripts in SQL, SAS, Python and/or BigQuery

Build end-to-end data solutions from ETL to analytical presentation

Proven experience in building data processes and solutions

Constantly work to understand data structures and their business context

Negotiate and document requirements, agreements and changes with business users

Preferred Qualifications

Experience with any of these a plus: Python, R, Alteryx, Trifacta, Linux OS, GCP/ AWS/ Azure

Experience working with medical and/or pharmacy claims data

Experience in healthcare industry, including health insurance, PBM or pharmacy services

Education

Bachelor's degree in computer science, data engineering, data analytics, or other data related degrees

Master's degree preferred

Anticipated Weekly Hours 40

Time Type Full time

Pay Range The typical pay range for this role is: $72,100.00 - $158,620.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.

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in our comprehensive and competitive mix of pay and benefits investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• 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.

We anticipate the application window for this opening will close on: 05/28/2025

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.