Senior Data Engineer
CVS Health6 days ago
Base Salary
$83k - $222k/yr
Responsibilities
- Design, develop, and maintain batch and streaming data pipelines using BigQuery, Cloud Spanner, and Dataflow.
- Build and support ETL/ELT workflows across Oracle, Spanner, SQL Server, PostgreSQL, and other relational databases.
- Develop and optimize BigQuery datasets, tables, partitioning, clustering, and complex queries.
- Implement and tune Dataflow pipelines for transformation, enrichment, and data movement.
- Monitor and performance-tune Compute Engine VMs and other GCP workloads.
- Support Cloud Storage, Cloud Composer, Pub/Sub, IAM, and related end-to-end data workflows.
- Apply dimensional modeling, star and snowflake schemas, slowly changing dimensions, and data mart design.
- Develop and support Informatica-based ETL integrations with GCP and on-premise systems.
- Work in Unix/Linux environments, including shell scripting, permissions, and log and file handling.
- Schedule, monitor, and troubleshoot batch jobs using Control-M.
- Troubleshoot pipeline failures, performance bottlenecks, and data quality issues.
- Collaborate with engineers and architects on database design, query optimization, and performance tuning.
- Document technical designs, runbooks, and platform support procedures.
- Apply AI, ML, and GenAI tools to improve productivity and automate repetitive engineering work.
- Participate in Agile and JIRA-based planning, tracking, status reporting, and defect management.
Requirements
- At least 5 years of experience in data engineering, software engineering, or database development.
- At least 3 years of hands-on experience with GCP, especially BigQuery, Cloud Spanner, and Dataflow.
- Strong experience with Oracle, Spanner, SQL, PostgreSQL, and multiple database platforms.
- Working knowledge of Compute Engine, VMs, Cloud Storage, Cloud Composer, Pub/Sub, and other GCP services.
- Experience with GCP compute performance tuning, CPU utilization analysis, and resource optimization.
- Solid understanding of data warehousing, dimensional modeling, fact and dimension tables, and ETL design patterns.
- Experience with Informatica or comparable ETL tools.
- Strong Unix/Linux experience, including shell scripting and file system handling.
- Experience with Control-M or similar job scheduling tools.
- Strong SQL development skills, including writing and optimizing complex queries.
- Bachelor’s degree or equivalent experience; a high school diploma with 4 years of relevant experience is also accepted.
- Preferred qualifications include experience with MongoDB, MySQL, Cassandra, Kafka, Terraform, Kubernetes/GKE, CDC and replication technologies, Agile/SAFe environments, healthcare or retail, and GCP certification.
- Preferred familiarity with Cloud Composer/Airflow, event-driven data architectures, AI/GenAI tools, and JIRA.
Benefits
- Full-time position with 40 anticipated weekly hours.
- Comprehensive benefits may include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other eligible resources.
- Eligible for a CVS Health bonus, commission, or short-term incentive program in addition to base pay.
- Application window is anticipated to close on November 16, 2026.
Tech Stack
Apache AirflowApache CassandraApache KafkaGoogle BigQueryGoogle Cloud PlatformInformaticaKubernetesLinuxMicrosoft SQL ServerMongoDBMySQLPostgreSQLSQLTerraform
Categories
Data Engineering
About CVS Health
CVS Health is a U.S. health care company that operates thousands of retail pharmacies, runs the CVS Caremark pharmacy benefits manager, and owns the Aetna health insurance business. It sells prescriptions, retail health goods, and insurance plans, and provides primary and urgent care through MinuteClinic and other services for consumers, employers, and government programs. Founded in 1963 and headquartered in Woonsocket, Rhode Island, it is a public company traded on the NYSE.