PBM 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 Customer 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 reporting 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 continuously improve quality control and accuracy of reported data, increase reporting efficiency, and look for ways to further automate reporting activities. You will mentor teammates on technical and business aspects of the reporting.

You will report to the Sr. Manager within the Reporting Solutions team. To be successful in this role, you need to have solid SQL and SAS 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.

To be successful in this role, you need to be a self-starter, who enjoys working on difficult problems in a fast-paced environment, who has proven technical skills, solid relationship building and communication skills, and strong drive for fostering collaboration, knowledge sharing, and continuous improvement.

Key Responsibilities :

Proactively lead reporting & automation activities, tracking completion of action items, resolving issues, and mitigating risk

Design and implement data quality checks and validation processes to ensure the accuracy, completeness, and consistency of data, while applying high standards for quality control to all reporting and analytic work, and ensuring consistent, clear documentation for production-ready reporting solutions.

Work with cross-functional teams to identify report requirements, gather data, and ensure timely delivery of data and report solutions.

Design, build, and maintain data pipelines and architecture for reporting and data analytic needs.

Document data engineering processes, workflows, and systems for reference and knowledge-sharing purposes.

Identify opportunities to streamline reporting processes, improve efficiency, and enhance the quality of deliverables.

Review MCO / Client Requests with internal and external partners to translate them into clear business requirements.

Coach the junior members of the team to understand business processes and how data are stored in EDW and support the translation of end user needs into clear business requirements and technical specifications. Rapidly deliver solutions, using agile methods.

Handle, communicate, and escalate issues (as needed) in a timely manner so as not to impact delivery

Continuously evaluate / evolve processes, best practices, and tools around data, reporting, and automation.

Lead by example to inspire a positive attitude, engagement, and professional growth.

Champion a culture of continuous improvement, curiosity, collaboration, and innovation.

Required Qualifications :

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

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

Build reporting solutions from requirement gathering to report delivery

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 : 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

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.

For more information, visit

We anticipate the application window for this opening will close on : 10 / 07 / 2025

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

We are an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex / gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.