Staff Data Engineer

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

📋 Description

• Oversee the design and execution of a near real-time transactional cache platform that supports APIs, applications, and digital experiences.

• Create and maintain Change Data Capture (CDC) pipelines to replicate data from UniVerse into PostgreSQL using vendor-supported replication technologies.

• Construct and uphold transformation pipelines that convert operational relational data into optimized MongoDB document structures.

• Design and enhance MongoDB document models, indexing strategies, partitioning methods, 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.

• Set standards for data freshness, latency, monitoring, and availability.

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

• Take ownership of platform reliability, observability, troubleshooting, incident response, and operational support for production environments.

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

• Provide technical guidance across engineering teams and spearhead architecture and modernization initiatives.

• Mentor engineers and establish engineering standards for CDC, operational data pipelines, and cloud-native data platforms.

⛳️ Requirements

• 7+ years of experience in data engineering, software engineering, or data platform development.

• 5+ years of experience in designing and implementing enterprise-scale data platforms and distributed systems.

• Familiarity with UniVerse or UniData operational databases.

• Proficiency in PICK BASIC, wIntegrate, Unix/Linux, and software development life cycle (SDLC) methodologies.

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

• Background in designing operational data stores, transactional caches, or data platforms that serve APIs.

• Strong skills in Python and SQL development.

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

• Competency in Linux/Unix environments.

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

• Excellent architecture, communication, and technical leadership abilities.

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

• Expertise in PostgreSQL, including schema design, query optimization, indexing, performance tuning, and high availability concepts.

• Proficiency in MongoDB Atlas, covering data modeling, aggregation frameworks, index design, and performance optimization.

• 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 ability to design highly available and low-latency data platforms.

• Agile/SAFe experience in large enterprises.

• Background in healthcare is a plus.

• Cloud certifications (AWS/GCP) are preferred.

🏝️ Benefits

• CVS Health bonus, commission, or short-term incentive program.

• Equity award program.

• Medical coverage.

• Dental coverage.

• Vision coverage.

• Paid time off.

• Retirement savings options.

• Wellness programs.

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