Senior Data Engineer - PostgreSQL and MongoDB

CVS Health • New York, SC

5d • $92,700 - $203,940

About The Position

The Senior Data Engineer will design, build, and support a near-real-time transactional cache platform that enables APIs, digital experiences, and downstream services to consume operational data outside the legacy UniVerse environment. The role develops and supports data flows from UniVerse through change data capture (CDC) replication into PostgreSQL, transformation and enrichment processes on GCP, and delivery of optimized data models within MongoDB Atlas. The platform is intended to reduce transactional workloads on UniVerse while providing scalable, near-real-time access for APIs and services.

The position contributes to the design, implementation, performance optimization, reliability, and operational support of the transactional cache ecosystem. It also collaborates with API and application teams, architects, senior engineers, and other cross-functional partners to deliver scalable, maintainable data platform solutions.

Requirements

• At least 5 years of data engineering, software engineering, or data platform development experience.
• At least 3 years designing, developing, and supporting enterprise-scale data platforms and distributed systems.
• Strong MongoDB Atlas and PostgreSQL experience, including data modeling, aggregation frameworks, index design, and performance optimization.
• Experience with CDC, replication technologies, and near-real-time data movement patterns.
• Experience designing and supporting operational data stores, transactional caches, or API-serving data platforms.
• Strong Python and SQL development skills.
• Experience with GCP services including Cloud SQL, Dataproc Serverless, Cloud Composer (Airflow), Monitoring, IAM, and cloud networking fundamentals.
• Experience developing and supporting production ETL/ELT pipelines.
• Experience working in Linux/Unix environments.
• Ability to troubleshoot distributed data processing and data synchronization issues.
• Strong problem-solving, communication, and collaboration skills.
• Bachelor’s degree or equivalent experience (high school diploma plus 4 years of relevant experience).

Nice To Haves

• Experience implementing transactional cache or operational data platform architectures.
• Kafka, Pub/Sub, or event-driven architecture experience.
• Experience building data platforms that support APIs and microservices.
• Terraform or Infrastructure as Code experience.
• Experience with GKE/Kubernetes.
• Experience designing highly available and low-latency data platforms.
• Agile/SAFe experience in large enterprises.
• Healthcare industry experience.
• AWS experience.
• AWS and/or GCP cloud certifications.
• East Coast hours preferred.

Responsibilities

• Design, develop, and support a near-real-time transactional cache platform for APIs, applications, and digital experiences.
• Build and maintain CDC pipelines replicating 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 for 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.
• 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.
• 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 about CDC, data pipelines, and cloud-native data engineering practices.

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• Paid time off
• Retirement savings options
• Wellness programs
• Other resources, based on eligibility
• Eligible for a CVS Health bonus, commission, or short-term incentive program

What This Job Offers

• Job Type: Full-time
• Career Level: Senior