Associate Data Engineer - PCW

CVS Health • Island, KY

5d • $67,980 - $135,960

About The Position

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Position Summary The Associate Data Engineer supports enterprise data initiatives for bigdata projects at CVS Health by ensuring the quality, reliability, security, and maintainability of cloud‑based data solutions built on Snowflake and Google Cloud Platform (BigQuery). This role combines functional testing, stakeholder support, application monitoring, and hands‑on software modification to deliver stable and high‑quality data products. The Associate Data Engineer collaborates closely with data engineers, product teams, and business stakeholders to validate data changes, support end‑to‑end (E2E) use cases, and implement code modifications aligned with project requirements and engineering best practices. Monitor application security findings using Snyk, identify potential vulnerabilities, and coordinate with responsible teams to drive remediation and resolution. Perform functional testing and data validation for CRDW projects involving Snowflake and GCP/BigQuery, ensuring data accuracy, completeness, and adherence to project specifications. Coordinate with cross‑functional teams to obtain and review requirements for newly created or modified tables and datasets. Develop and execute test plans to confirm that data changes meet project expectations and that data is received, processed, and stored correctly across pipelines. Provide end‑to‑end (E2E) support to internal stakeholders by assisting with SQL queries, data loads, and troubleshooting data‑related issues. Validate data flows and transformations across cloud environments to ensure reliable ingestion and downstream availability.

Requirements

• Experience in data engineering, including ETL pipeline development, data cleansing, and database migration within cloud-based environments
• Hands-on experience with cloud data platforms, including Snowflake, AWS, and Google Cloud Platform (BigQuery)
• Proficiency in SQL with experience working with enterprise data warehouses such as Snowflake, BigQuery, and Teradata
• Experience with ETL and orchestration tools, including Control‑M, and related cloud services
• Strong background in software and data testing, including test planning, validation, defect tracking, and troubleshooting using tools such as JIRA, and Confluence - 3 years
• Experience with data quality validation and application security monitoring, including familiarity with tools such as Snyk
• Programming experience using Python and/or R for data analysis, validation, automation, or scripting
• Experience supporting analytics and business intelligence use cases using tools such as Power BI, Tableau, and Excel
• Knowledge of Retail Pharmacy systems and pharmacy‑related data domains, including patient, prescriber, prescriptions, and downstream analytics
• Prior experience working with CVS Pharmacy Retail Big Data Warehouses, including CRDW and RxDW

Nice To Haves

• Demonstrated ability to collaborate effectively with cross‑functional technical and business stakeholders to support end-to-end data workflows.
• Proven ability to operate successfully in a fast‑paced, dynamic environment while managing multiple priorities.
• Ability to work independently with minimal supervision, exercising sound judgment and accountability in day‑to‑day responsibilities.

Responsibilities

• Monitor application security findings using Snyk, identify potential vulnerabilities, and coordinate with responsible teams to drive remediation and resolution.
• Perform functional testing and data validation for CRDW projects involving Snowflake and GCP/BigQuery, ensuring data accuracy, completeness, and adherence to project specifications.
• Coordinate with cross‑functional teams to obtain and review requirements for newly created or modified tables and datasets.
• Develop and execute test plans to confirm that data changes meet project expectations and that data is received, processed, and stored correctly across pipelines.
• Provide end‑to‑end (E2E) support to internal stakeholders by assisting with SQL queries, data loads, and troubleshooting data‑related issues.
• Validate data flows and transformations across cloud environments to ensure reliable ingestion and downstream availability.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level