Senior Data Engineer – MongoDB, PostgreSQL

This is a fully remote position, open to applicants in New York.

📋 Description

• Design, develop, and maintain a near real-time transactional cache platform that supports APIs, applications, and digital experiences.

• Build and oversee CDC pipelines that replicate data from UniVerse into PostgreSQL, utilizing vendor-supported replication technologies.

• Develop and manage transformation pipelines that convert operational relational data into optimized MongoDB document formats.

• Implement and support MongoDB document models, indexing strategies, partitioning techniques, and query patterns for high-throughput, low-latency API consumption.

• Collaborate with API and application development teams to define and deliver cache-ready domain models.

• Monitor and enhance 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 engage in operational support, incident response, and root cause analysis.

• Develop and sustain operational runbooks, monitoring dashboards, alerting strategies, and support procedures.

• Work alongside architects, senior engineers, and cross-functional teams to create scalable data platform solutions.

• Contribute to engineering best practices, conduct code reviews, and promote documentation and continuous improvement.

• Mentor junior engineers and share knowledge related to CDC, data pipelines, and cloud-native data engineering.

⛳️ Requirements

• Over 5 years of experience in data engineering, software engineering, or data platform development.

• More than 3 years of experience in designing, developing, and supporting enterprise-scale data platforms and distributed systems.

• Strong expertise in MongoDB Atlas/PostgreSQL, including data modeling, aggregation frameworks, index design, and performance optimization.

• Familiarity with Change Data Capture (CDC), replication technologies, and near real-time data movement patterns.

• Experience in designing and supporting operational data stores, transactional caches, or API-serving data platforms.

• Proficient in Python and SQL development.

• Experience with GCP services such as Cloud SQL, Dataproc Serverless, Cloud Composer (Airflow), Monitoring, IAM, and cloud networking fundamentals.

• Familiarity with developing and supporting production ETL/ELT pipelines.

• Experience in Linux/Unix environments.

• Ability to diagnose issues in distributed data processing and data synchronization.

• Strong problem-solving, communication, and collaboration abilities.

• Experience in implementing transactional cache or operational data platform architectures.

• Knowledge of Kafka, Pub/Sub, or event-driven architecture.

• Experience in building data platforms that support APIs and microservices.

• Familiarity with Terraform or Infrastructure as Code.

• Experience with GKE/Kubernetes.

• Proven experience in designing highly available and low-latency data platforms.

• Agile/SAFe experience in large enterprises.

• Experience in the healthcare industry.

• Familiarity with AWS.

• Preferred cloud certifications (AWS and/or GCP).

• Preference for candidates available during EST hours.

• Bachelor’s degree or equivalent experience (High School diploma + 4 years of relevant experience).

🏝️ Benefits

• Medical coverage.

• Dental coverage.

• Vision coverage.

• Paid time off.

• Retirement savings options.

• Wellness programs.

• Additional resources supporting physical, emotional, and financial well-being.

• CVS Health bonus, commission, or short-term incentive program in addition to base pay.