PBM Data Engineer

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
40Time Type
Full timePay Range

The typical pay range for this role is:$72,100.00 - $158,620.00This 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 peopleWe 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 https://jobs.cvshealth.com/us/en/benefitsWe anticipate the application window for this opening will close on: 05/28/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.