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.
Position Summary
This Data Engineer will be involved in all facets of data ingest and export for Wellpartner. They are responsible for ensuring that data received from external parties (such as our Covered Entity and Contract Pharmacy partners and drug wholesalers) are successfully ingested and available for processing in our transactional system, while also ensuring that file extracts for external business partners are produced and delivered on the agreed upon schedule.
Responsibilities include but no limited to:
- Develop SSIS packages to extract, transform, and load (ETL) data from CVS Health pharmacy claims systems, 340B third-party administrator (TPA) platforms, Covered entity eligibility files, Drug inventory and pricing systems.
- Implement data validation rules within SSIS packages to ensure compliance with 340B program requirements (e.g., patient eligibility, drug utilization).
- Support incremental and full data loads to accommodate daily, weekly, and monthly data warehouse refresh cycles.
- Integrate data from disparate formats (e.g., CSV, XML, flat files, and relational databases) into a centralized SQL Server data warehouse.
- Ensure data quality through error checking and data validation using T-SQL and SSIS among other tools.
Required Qualifications
- High proficiency with SQL/T-SQL, SSIS, and SSRS.
- Deep understanding of stored procedures, as well as T-SQL queries.
- Knowledge of data relationships, querying / processing data, and designing well-structured data flows.
- Experience with C# is nice to have
Preferred Qualifications
- Healthcare industry experience.
- 340B experience
- Performance tuning processes and T-SQL
Education
- Bachelor’s degree in Computer Science, Data Analytics or Information Technology or equivalent work experience.
Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:
$79,310.00 - $173,040.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 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 https://jobs.cvshealth.com/us/en/benefits
We anticipate the application window for this opening will close on: 05/23/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.
Top Skills
Similar Jobs
What you need to know about the Los Angeles Tech Scene
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
