Staff Data Engineer: Real-Time Cache & CDC Platform

CVS Health Corporation; United States; On-site; USD 107,000 - 261,000; Full time

Benefits offered by this job

Comprehensive benefits

Bonus and equity

Job summary

CVS Health is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform powering APIs and digital experiences.

You will lead CDC pipelines from UniVerse to PostgreSQL, transform data into MongoDB documents, optimize query patterns, and ensure reliability, observability, and performance across production cache environments. Collaboration with multiple teams and mentoring engineers are core parts of the role.

Qualifications

• 7+ years of data engineering, software engineering, or data platform development experience.
• 5+ years designing and implementing enterprise-scale data platforms and distributed systems.
• Experience with UniVerse or UniData operational databases.
• Proficiency in PICK BASIC, wIntegrate, Unix/Linux, and SDLC methodologies
• Strong experience with Change Data Capture (CDC), replication technologies, and near real-time data movement patterns.
• Experience designing operational data stores, transactional caches, or API-serving data platforms.
• Strong Python and SQL development skills.
• Experience developing and supporting production ETL/ELT pipelines.
• Experience with Linux/Unix environments.
• Ability to troubleshoot distributed data processing and data synchronization issues.
• Strong architecture, communication, and technical leadership skills.

Responsibilities

• Lead the design and implementation of a near real-time transactional cache platform supporting APIs, applications, and digital experiences.
• Design and support Change Data Capture (CDC) pipelines that replicate data from UniVerse into PostgreSQL using vendor-supported replication technologies.
• Develop and maintain transformation pipelines that convert operational relational data into optimized MongoDB document structures.
• Design and evolve MongoDB document models, indexing strategies, partitioning approaches, and query patterns to support high-throughput, low-latency API consumption.
• Partner with API and application development teams to define and deliver cache-ready domain models that meet performance and scalability requirements.
• Establish data freshness, latency, monitoring, and availability standards for transactional cache workloads.
• Optimize PostgreSQL and MongoDB performance through schema design, indexing, query tuning, and capacity planning.
• Own platform reliability, observability, troubleshooting, incident response, and operational support for production transactional cache environments.
• Develop operational runbooks, monitoring dashboards, alerting strategies, and support procedures for production cache environments.
• Provides technical leadership across multiple engineering teams, influences architecture decisions, establishes engineering standards, and drives strategic modernization initiatives.
• Mentor engineers and establish engineering standards for CDC, operational data pipelines, and cloud-native data platforms.

Skills

Data engineering

SQL development

Python development

CDC/real-time data movement

Unix/Linux

ETL/ELT pipelines

Enterprise-scale architectures

Distributed systems

Education

Bachelor's degree or equivalent

Tools

GCP

PostgreSQL

MongoDB Atlas

Kafka

Kubernetes (GKE)

Terraform

Job description

CVS Health is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform powering APIs and digital experiences.

You will lead CDC pipelines from UniVerse to PostgreSQL, transform data into MongoDB documents, optimize query patterns, and ensure reliability, observability, and performance across production cache environments. Collaboration with multiple teams and mentoring engineers are core parts of the role.