Senior Data Engineer - CDC, PostgreSQL & MongoDB on GCP

CVS Health; City of Albany (NY); On-site; USD 83,000 - 204,000; Full time

Benefits offered by this job

Comprehensive benefits

Bonus eligibility

Paid time off

Job summary

CVS Health is seeking a Senior Data Engineer to design and support a near real-time transactional cache platform enabling APIs and digital experiences. You will drive CDC pipelines from UniVerse to PostgreSQL, transform data for MongoDB, and optimize performance across PostgreSQL and MongoDB in a cloud-native environment.

The role emphasizes operational reliability, scalable data models, and collaboration with cross-functional teams to deliver robust data platforms.

Qualifications

• 5+ years of data engineering, software engineering, or data platform development experience.
• 3+ years designing, developing, and supporting enterprise-scale data platforms and distributed systems.
• Strong MongoDB Atlas /PostgreSQL experience including data modeling, aggregation frameworks, index design, and performance optimization.

Responsibilities

• Design, develop, and support a near real-time transactional cache platform supporting APIs, applications, and digital experiences.
• Build and maintain Change Data Capture (CDC) pipelines that replicate data from UniVerse into PostgreSQL using vendor-supported replication technologies.
• Develop and support transformation pipelines that convert operational relational data into optimized MongoDB document structures.
• Implement and support MongoDB document models, indexing strategies, partitioning approaches, and query patterns to support high-throughput, low-latency API consumption.
• Monitor and improve data freshness, latency, availability, and reliability of transactional cache workloads.
• Optimize PostgreSQL and MongoDB performance through schema design, indexing, query tuning, and capacity planning.
• Troubleshoot production issues and participate in operational support, incident response, and root cause analysis activities.
• Develop and maintain operational runbooks, monitoring dashboards, alerting strategies, and support procedures.
• Collaborate with architects, senior engineers, and cross-functional teams to implement scalable and maintainable data platform solutions.
• Contribute to engineering best practices, code reviews, documentation, and continuous improvement initiatives.
• Mentor junior engineers and share knowledge related to CDC, data pipelines, and cloud-native data engineering practices.

Skills

Data engineering

Python

SQL

GCP

CDC

Education

Bachelor's degree

Tools

MongoDB Atlas

PostgreSQL

Job description

CVS Health is seeking a Senior Data Engineer to design and support a near real-time transactional cache platform enabling APIs and digital experiences. You will drive CDC pipelines from UniVerse to PostgreSQL, transform data for MongoDB, and optimize performance across PostgreSQL and MongoDB in a cloud-native environment.

The role emphasizes operational reliability, scalable data models, and collaboration with cross-functional teams to deliver robust data platforms.