Job Description
Company: CVS Health
Location: Albany, NY
Workplace Type: Remote
Employment Type: Full-time
Pay / Compensation: $83,430.00 – $203,940.00
About the Role
CVS Health is building a world of health around every individual. This Senior Data Engineer role will design, build, and support a near real-time transactional cache platform, enabling APIs and digital experiences to consume operational data outside of the legacy UniVerse environment.
What You’ll Do / Key Responsibilities
- Design, develop, and support a near real-time transactional cache platform supporting APIs and applications.
- Build and maintain Change Data Capture (CDC) pipelines replicating data from UniVerse into PostgreSQL.
- Develop transformation pipelines converting relational data into optimized MongoDB document structures.
- Implement and support MongoDB document models, indexing strategies, and query patterns for high-throughput consumption.
- 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, and alerting strategies.
Requirements & 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.
- Strong Python and SQL development skills.
- Experience with GCP services including Cloud SQL, Dataproc Serverless, Cloud Composer (Airflow), Monitoring, IAM.
- Ability to troubleshoot distributed data processing and data synchronization issues.
Preferred / Bonus Qualifications (if applicable)
- Experience implementing transactional cache or operational data platform architectures.
- Kafka, Pub/Sub, or event-driven architecture experience.
- Terraform or Infrastructure as Code experience.
- Healthcare industry experience.
Benefits & Perks (if applicable)
- Comprehensive benefits package including medical, dental, and vision coverage.
- Paid time off and retirement savings options.
- Wellness programs and other resources.
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.