Staff Data Engineer - Real-Time Cache & CDC Lead

CVS Health Corporation; Rhode Island; Hybrid; USD 107,000 - 261,000; Full time

Job summary

CVS Health Corporation is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform powering APIs, digital experiences, and downstream services. You will lead CDC pipelines from UniVerse to PostgreSQL and transform data for MongoDB storage, enabling scalable, low-latency data access.

The role requires deep expertise in operational data platforms, data replication, and cloud-native data engineering, with responsibilities for architecture,

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

Python

SQL

CDC

Distributed systems

Unix/Linux

Education

Bachelor's degree

Tools

UniVerse/UniData

PICK BASIC

wIntegrate

PostgreSQL

MongoDB

Job description

CVS Health Corporation is seeking a Staff Data Engineer to design, build, and support a near real-time transactional cache platform powering APIs, digital experiences, and downstream services. You will lead CDC pipelines from UniVerse to PostgreSQL and transform data for MongoDB storage, enabling scalable, low-latency data access.

The role requires deep expertise in operational data platforms, data replication, and cloud-native data engineering, with responsibilities for architecture,