Support 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)
Combine functional testing, stakeholder support, application monitoring, and hands-on software modification to deliver stable and high-quality data products
Collaborate closely with data engineers, product teams, and business stakeholders to validate data changes, offer end-to-end (E2E) support for use cases, and implement code modifications
Monitor application security findings using Snyk, identify potential vulnerabilities, and coordinate with responsible teams for remediation
Perform functional testing and data validation for CRDW projects involving Snowflake and GCP/BigQuery
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 data changes meet project expectations
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
Tech Stack
AWS
BigQuery
Cloud
ETL
Google Cloud Platform
Python
SQL
Tableau
Benefits
Affordable medical plan options
401(k) plan (including matching company contributions)
Employee stock purchase plan
No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs