Senior Data Engineer

CVS Health is a healthcare company focused on creating a more connected, convenient, and compassionate health experience. The Senior Data Engineer will design and implement data pipelines and data models that support analytics, reporting, and data science workloads, while optimizing performance, governance, security, and data quality. The role also collaborates with data scientists and analysts and mentors junior data engineers.

Responsibilities:

• Data Modeling & Architecture: Develop and optimize data models and schemas to support analytics, reporting, and machine learning requirements
• Data Pipeline Development: Design and build ETL/ELT data pipelines to ingest, process, and transform large datasets from multiple sources
• Performance Optimization: Implement best practices for performance tuning, partitioning, and clustering to optimize data queries and reduce costs
• Data Quality & Governance: Establish and enforce data quality standards, data governance frameworks, and security policies for data storage and access
• Data Integration & Transformation: Collaborate with data scientists and analysts to design data solutions that integrate with BI tools and machine learning models
• Documentation & Knowledge Sharing: Create comprehensive documentation for data pipelines, workflows, and processes. Share best practices and mentor junior data engineers
• Design and architect data infrastructure analytical workloads
• Understanding of data warehousing concepts, dimensional modeling, and building data marts

Requirements:

• Strong proficiency in SQL and experience in developing complex queries
• Experience in Python, specifically with ETL pipelines
• Experience deploying data pipelines in a cloud environment (Azure, AWS, GCP)
• Knowledge of data governance best practices in a cloud environment
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with data scientists, analysts, and product owners
• Bachelor's degree preferred/specialized training/relevant professional qualification
• Experience with machine learning flows on GCP
• Experience working with healthcare data (Tuva or OMOP Models a plus)