Senior Data Engineer - MongoDB and PostgreSQL

CVS Health; New York (NY); Hybrid; USD 83.000 - 204.000; Vollzeit

Benefits dieser Stelle

Medical coverage

Dental coverage

Vision coverage

Paid time off

Retirement savings options

Wellness programs

Zusammenfassung

CVS Health is seeking a Senior Data Engineer to design, build, 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 cloud-native data models.

The role emphasizes production-grade data platforms, performance tuning, and collaboration with cross-functional teams to deliver scalable, reliable data services.

Qualifikationen

• 5+ years in data engineering or data platform development.
• 3+ years designing enterprise-scale data platforms and distributed systems.
• Strong MongoDB Atlas / PostgreSQL data modeling and performance optimization.

Aufgaben

• Design, develop, and support a near real-time transactional cache platform supporting APIs, applications, and digital experiences.
• Build and maintain 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.
• 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.

Kenntnisse

Python

SQL

PostgreSQL

MongoDB

GCP

CDC

Data pipelines

Ausbildung

Bachelor's degree

Tools

MongoDB Atlas

PostgreSQL

Cloud SQL

Kubernetes

Airflow

Jobbeschreibung

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary

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 of the legacy UniVerse environment. This role is responsible for developing and supporting data flows from UniVerse through CDC replication into PostgreSQL, transformation and enrichment processes on GCP, and delivery of optimized data models within MongoDB Atlas. The ideal candidate will possess strong expertise in operational data platforms, CDC technologies, data replication, PostgreSQL, MongoDB, and cloud-native data engineering. This individual will contribute to the design, implementation, performance optimization, reliability, and operational support of the transactional cache ecosystem. The platform is intended to reduce transactional workloads on UniVerse while providing scalable, near real-time access for APIs and services.

What You Will Do

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

Required 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.
• Experience with Change Data Capture (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.

Preferred Qualifications

• 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.
• Cloud certifications (AWS and/or GCP) preferred.
• EST coast hours preferred.

Education

Bachelor’s degree, or equivalent experience (HS diploma + 4 years relevant experience).

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is: $83,430.00 - $203,940.00. This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.

Benefits

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families. This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include:

• Medical coverage
• Dental coverage
• Vision coverage
• Paid time off
• Retirement savings options
• Wellness programs
• Other resources, based on eligibility

Additional details about available benefits are provided during the application process and on Benefits Moments.

Equal Opportunity Statement

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

Application Deadline

We anticipate the application window for this opening will close on: 11/20/2026

Company Culture

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong. Great benefits for great people We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families. This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families.

Our employees are self-disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.