4 days ago
Base Salary
$89k - $120k/yr
Responsibilities
- Define end-to-end data architecture, data modeling, partitioning, indexing, and retention strategies for high-volume PostgreSQL and Aurora workloads.
- Lead and mentor Senior and Mid-level Data Engineers while establishing standards for SQL performance tuning, database migrations, CI/CD pipelines, and test coverage.
- Build Amazon ElastiCache for Redis read/write logic, including key design, TTLs, invalidation, and source-data consistency.
- Optimize high-throughput queries, lock contention, index overhead, and database performance.
- Architect event-driven and batch pipelines using event streams to support near-real-time cache invalidation and refreshes.
- Design automated reconciliation frameworks and audit jobs to detect cache drift against source ODS views.
- Drive adoption of AI-assisted engineering tools for code generation, SQL optimization, and test automation.
- Collaborate with service modernization leads, API engineers, enterprise architects, and platform/cloud operations.
Requirements
- At least 8 years of data engineering experience, including at least 2 years in a lead or principal role.
- Experience with Amazon Aurora PostgreSQL, Amazon RDS, and DynamoDB.
- Experience with data modeling, operational data stores, transactional cache patterns, partitioning, indexing, and data retention or archival policies.
- Hands-on Amazon ElastiCache for Redis experience, including cache design, key and TTL strategies, invalidation patterns, and source-data consistency.
- Proficiency in Java or Python.
- Experience consuming events from Apache Kafka or AWS MSK and managing offsets.
- Experience integrating AI-assisted development and testing practices into engineering workflows.
- Expert PostgreSQL and advanced SQL skills, including query optimization, execution plan analysis, vacuuming, and connection pooling.
- Experience with database schema version control using Liquibase or Flyway.
- A proven track record with large-scale ETL/ELT pipelines and CDC or stream-based data synchronization.
- Financial services, core banking, or payment platforms experience is preferred, with ODS familiarity a strong plus.
Benefits
- Paid time off based on employee grade, including 12–25 vacation days, company-paid holidays, personal days, and sick leave.
- Medical, dental, and vision coverage, or provincial healthcare coordination in Canada.
- Retirement savings plans such as 401(k) in the U.S. or RRSP in Canada.
- Life and disability insurance.
- Employee assistance programs and other benefits based on local policy and eligibility.
- Regular full-time employees receive a comprehensive, non-negotiable benefits package; compensation may also include variable incentives, bonuses, or commissions depending on the position and applicable laws.
Tech Stack
Categories
Data Engineering
About Capgemini
Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.