Senior Data Engineer

CVS Health; United States; Remote; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Paid time off

Retirement savings

Wellness resources

Job summary

CVS Health is seeking an experienced data engineer to design, build, and support data pipelines and platform services for analytics and reporting. You will work with Google Cloud data services and integrate across cloud and enterprise databases to ensure reliability and performance.

Responsibilities include developing batch and streaming pipelines, ETL/ELT workflows, tuning BigQuery, and collaborating with engineers to improve the platform. A strong Unix/Linux and Agile background is valued.

Qualifications

• Five or more years of experience in data engineering, software engineering, or database development.
• At least three years of hands-on Google Cloud experience, especially BigQuery, Cloud Spanner and Dataflow.
• Experience with multiple databases (Oracle, Spanner, SQL, PostgreSQL) and ETL tools such as Informatica; cloud services like Compute Engine, Cloud Storage, Composer, Pub/Sub.

Responsibilities

• Develop batch and streaming pipelines using BigQuery, Cloud Spanner, and Dataflow.
• Build and maintain ETL/ELT workflows across cloud and relational databases (Oracle, PostgreSQL, SQL Server).
• Optimize BigQuery storage and query performance via partitioning and clustering design.
• Monitor and troubleshoot cloud workloads, pipeline failures, data quality issues.
• Support cloud services used in end-to-end workflows (Compute Engine, Cloud Storage, Composer, Pub/Sub, IAM, Informatica, Control-M).
• Apply data warehousing practices and document designs and operational procedures.

Skills

Unix/Linux

Shell scripting

Batch scheduling

Agile delivery

Dimensional modeling

Tools

BigQuery

Dataflow

Cloud Spanner

Informatica

Compute Engine

Cloud Storage

Composer

Pub/Sub

Job description

Role overview

Design, build, and support data pipelines and platform services that make information available for analytics, reporting, and downstream applications. The work centers on Google Cloud data services, integration across cloud and enterprise databases, operational reliability, and performance tuning.

Responsibilities

• Develop batch and streaming pipelines using BigQuery, Cloud Spanner, and Dataflow.
• Build and maintain ETL/ELT workflows across cloud and relational databases, including Oracle, PostgreSQL, and SQL Server.
• Optimize BigQuery storage and query performance through dataset, table, partitioning, and clustering design.
• Monitor and troubleshoot cloud workloads, pipeline failures, batch jobs, and data quality issues.
• Support cloud services and tools used in end-to-end workflows, including Compute Engine, Cloud Storage, Composer, Pub/Sub, IAM, Informatica, and Control-M.
• Apply data warehousing practices, document designs and operational procedures, and collaborate with engineers and architects on platform improvements.

Requirements

• At least five years of experience in data engineering, software engineering, or database development.
• At least three years of hands-on Google Cloud experience, especially BigQuery, Cloud Spanner, and Dataflow.
• Experience with multiple database platforms, including Oracle, Spanner, SQL, and PostgreSQL.
• Knowledge of ETL tools such as Informatica and cloud services such as Compute Engine, Cloud Storage, Composer, or Pub/Sub.
• Experience tuning performance and resources, plus a solid grasp of dimensional modeling, data marts, and ETL design patterns.
• Strong Unix/Linux skills, including shell scripting and file handling; experience with batch scheduling and Agile delivery is also relevant.

Nice to have

• Interest or experience using AI and generative AI tools to automate repetitive development tasks and improve engineering workflows.

Benefits and work setup

• Full-time role with a 40-hour work week; annual pay range is $83,430-$222,480, with actual pay depending on experience, education, and location.
• Eligible for an incentive program and benefits including medical, dental, and vision coverage, paid time off, retirement savings, and wellness resources.