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. Position Summary This data engineer position is 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. The data engineer should be an expert in T-SQL and SSIS, with a proficiency in C# a bonus. Responsibilities: • Assisting as part of the team who will work with Business Analysts to gather and approve technical requirements with the impact of other related SP kept in high regard. • Apply problem solving skills to analyze data/process problems as raised by external or internal partners, determining whether potential process fixes are necessary. • Identify areas of need in terms of non-adherence to best practice industry standards. • Actively monitor process performance. • Deliver performance-focused development projects resulting from performance monitoring. • Share knowledge of Wellpartner data processes and procedures through creation and maintenance of technical documentation. • Act as a guide who may assist others via a direct interface to production systems for other internal users: executing scripts, applying data fixes where user tools don't exist, etc. • Identify and delegate tasks to collogues on areas where user tools can be enhanced to create additional operational functional. • Designing, building, and instructing others on processes to ingest raw data in disparate EDI (Electronic Data Interchange) formats from more than 1400 external partners: including flat file, Excel, X12, XML, HL7, and JSON. • Ensure data quality through error checking and data validation using T-SQL and SSIS among other tools.

CVS Health is a leading health solutions company that aims to reimagine health care and make it more connected, convenient and compassionate for all. With more than 300,000 dedicated colleagues, we serve millions of consumers through our local presence, digital channels and advanced technologies. We are building a world of health around every consumer and surrounding ourselves with talented colleagues who are passionate about transforming health care.