Staff Data Engineer: Real-Time Cache & CDC Platform

CVS Health Corporation; Town of Texas (WI); 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 enabling APIs, digital experiences, and downstream services to access operational data outside the legacy UniVerse environment.

The ideal candidate will lead architecture, implement performance optimizations, and ensure reliability and observability of the transactional cache ecosystem.

Qualifications

• 7+ years of data engineering, software engineering, or data platform development.
• 5+ years designing and implementing enterprise-scale data platforms and distributed systems.
• Experience with UniVerse or UniData.
• Proficiency in PICK BASIC, wIntegrate, Unix/Linux, and SDLC methodologies.
• Strong experience with CDC, replication technologies, and near real-time data movement.
• 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 and digital experiences.
• Design and support CDC pipelines that replicate data from UniVerse into PostgreSQL.
• Develop and maintain transformation pipelines to MongoDB document structures.
• Design and evolve MongoDB models, indexing, partitioning, and query patterns for high throughput APIs.
• Partner with API teams to deliver cache-ready domain models meeting performance targets.
• Establish data freshness, latency, and availability standards for transactional cache workloads.
• Optimize PostgreSQL and MongoDB performance through schema design and tuning.
• Own platform reliability and operations for production cache environments.
• Develop runbooks, dashboards, and alerting for production cache operations.
• Provide technical leadership across teams and drive modernization initiatives.
• Mentor engineers and establish engineering standards for CDC and data pipelines.

Skills

CDC technologies

PostgreSQL

MongoDB

Python

SQL

Unix/Linux

Data replication

Architect leadership

Education

Bachelor's degree or equivalent experience

Tools

PICK BASIC

wIntegrate

Unix/Linux

GKE/Kubernetes

Terraform

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, digital experiences, and downstream services to access operational data outside the legacy UniVerse environment.

The ideal candidate will lead architecture, implement performance optimizations, and ensure reliability and observability of the transactional cache ecosystem.