Senior Data Engineer – PostgreSQL, MongoDB

This is a fully remote position, open to applicants in New York, +5 more states.

📋 Description

• Design, develop, and provide support for a near real-time transactional cache platform that serves APIs, applications, and digital experiences.

• Construct and maintain Change Data Capture (CDC) pipelines to replicate data from UniVerse into PostgreSQL.

• Create and support transformation pipelines that convert operational relational data into optimized MongoDB document structures.

• Implement document models, indexing strategies, partitioning methods, and query patterns for MongoDB.

• Collaborate with API and application development teams to deliver domain models that are ready for caching.

• Monitor and enhance data freshness, latency, availability, and reliability.

• Improve PostgreSQL and MongoDB performance through effective schema design, indexing, query optimization, and capacity planning.

• Resolve production issues and engage in incident response and root cause analysis.

• Maintain runbooks, monitoring dashboards, alerting strategies, and support procedures.

• Work together with architects, senior engineers, and cross-functional teams.

• Contribute to engineering best practices, participate in code reviews, documentation efforts, and continuous improvement initiatives.

• Mentor junior engineers and share insights on CDC, data pipelines, and cloud-native data engineering.

⛳️ Requirements

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

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

• Proficient in MongoDB Atlas and PostgreSQL, including expertise in data modeling, aggregation frameworks, index design, and performance tuning.

• 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 data platforms serving APIs.

• Strong skills in Python and SQL development.

• Knowledge of Google Cloud Platform services, including Cloud SQL, Dataproc Serverless, Cloud Composer (Airflow), Monitoring, IAM, and cloud networking fundamentals.

• Experience in developing and supporting production ETL/ELT pipelines.

• Background in Linux/Unix environments.

• Capability to troubleshoot issues related to distributed data processing and data synchronization.

• A Bachelor’s degree or equivalent experience (such as a high school diploma plus 4 years of relevant experience).

• Preferred qualifications include experience with Kafka, Pub/Sub, event-driven architecture, APIs and microservices, Terraform or Infrastructure as Code, GKE/Kubernetes, highly available and low-latency data platforms, familiarity with Agile/SAFe methodologies, and experience in the healthcare industry, as well as AWS and AWS/GCP cloud certifications.

• Preference for candidates available during EST coast hours.

🏝️ Benefits

• Medical coverage.

• Dental coverage.

• Vision coverage.

• Paid time off.

• Retirement savings options.

• Wellness programs.

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

• Eligibility for CVS Health bonus, commission, or short-term incentive programs.