Data Engineer

CVS Health•Woonsocket, RI

4d•$130,832 - $144,200•Hybrid

About The Position

Caremark LLC, a CVS Health company, is hiring for the following role in Woonsocket, RI: Data Engineer to be responsible for contractual data reporting requirements and providing post-production support of business’s contractual data & reports. Duties include: review business and technical documents and contract language pertaining to data reporting requests by manufacturers, in order to demonstrate understanding of data commitments and implications for the business; review and redline data reporting contracts to ensure reporting requirements - including data quality and data specifications - are adequately captured within the contract; determine feasibility of delivering data according to contractual needs by performing necessary research within CVS systems and through partnering with the company’s data systems partner; partner with CVS Trade team to understand upcoming data project needs and product pipeline while providing relevant updates on project implementations and support activities; collaborate with internal partners to analyze and collect meaningful metrics and insights; review, problem solve and conduct root cause analysis of incoming data concerns not complying with contracts; analyze data & reporting information from data feeds and warehouses to determine feasibility of data reporting requests from pharmaceutical manufacturers; complete user provisioning requests for external contractual products, and submit user access requests for internal reporting team members; execute proper maintenance and centralized storage of key project documentation including business requirements, technical specifications, design documents, test plans; and write and execute simple SQL queries to combine, parse, extract and manipulate data to aide in data reporting. Telecommuting available. Multiple positions.

Requirements

Master’s degree (or foreign equivalent) in Computer Science, Data Science, Management Information Systems, Business Analytics Mathematics, Statistics, Engineering or a related field
Two (2) years of experience in the job offered or a related occupation
Two (2) years of experience with SQL programming languages
Two (2) years of experience creating and executing user acceptance test plans
Two (2) years of experience with traditional relational data warehouse technologies: Oracle, Teradata, and Snowflake
Two (2) years of experience with Google cloud Data engineering technology such as Big Query
Two (2) years of experience with data reconciliation, reporting, and analysis
Two (2) years of experience retrieving relevant data from the database using SQL queries
Two (2) years of experience creating and maintaining business requirements documentation
Two (2) years of experience performing data reviews, and collaborating with peers on complex data requests/issues
Two (2) years of experience with Extract/Transform/Load (ETL) processes
Two (2) years of experience designing data models and solutions for analytical and reporting use cases

Responsibilities

Review business and technical documents and contract language pertaining to data reporting requests by manufacturers.
Review and redline data reporting contracts to ensure reporting requirements are adequately captured.
Determine feasibility of delivering data according to contractual needs by performing research within CVS systems and partnering with the data systems partner.
Partner with CVS Trade team to understand upcoming data project needs and product pipeline.
Collaborate with internal partners to analyze and collect meaningful metrics and insights.
Review, problem solve and conduct root cause analysis of incoming data concerns not complying with contracts.
Analyze data & reporting information from data feeds and warehouses to determine feasibility of data reporting requests from pharmaceutical manufacturers.
Complete user provisioning requests for external contractual products, and submit user access requests for internal reporting team members.
Execute proper maintenance and centralized storage of key project documentation.
Write and execute simple SQL queries to combine, parse, extract and manipulate data to aide in data reporting.