Staff Data Engineer: Real-Time Cache & CDC Architect

CVS Health Corporation; South Carolina; Hybrid; USD 107,000 - 261,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Paid time off

Retirement savings options

Wellness programs

Equity awards

Job summary

CVS Health Corporation is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform enabling APIs and digital experiences. You will lead architecture, implement CDC pipelines from UniVerse to PostgreSQL, and develop MongoDB data models for high-throughput access.

The role requires strong Python/SQL, enterprise data platform experience, and leadership in cloud-native data engineering.

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 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

Python

SQL

Distributed systems

CDC

Data platforms

Data modeling

Education

Bachelor's degree

Tools

UniVerse/UniData

PostgreSQL

MongoDB

GKE/Kubernetes

Job description

CVS Health Corporation is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform enabling APIs and digital experiences. You will lead architecture, implement CDC pipelines from UniVerse to PostgreSQL, and develop MongoDB data models for high-throughput access.

The role requires strong Python/SQL, enterprise data platform experience, and leadership in cloud-native data engineering.