Sr Data Engineer

At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same.

Job Description

Role Overview

Team builds and runs the core Marketplace analytics data products and platform (Snowflake/dbt/Dagster, pipelines, models, observability) that other teams rely on for hiring, performance, and marketplace insights.

Must-Have Skills

• • SQL
• o Strong ability to query, transform, validate, and optimize data for analytics, reporting, and pipeline workflows
• • Python
• o Experience building scalable data pipelines, automation scripts, and data processing workflows
• • Snowflake
• o Hands-on experience designing and maintaining cloud data warehouse structures, tables, and performant data models
• • dbt
• o Experience developing modular data transformations, testing, and documentation within modern ELT workflows
• • AWS
• o Familiarity with AWS cloud services supporting scalable data storage, processing, and pipeline orchestration
• • ETL / ELT
• o Experience building reliable workflows for extracting, transforming, loading, and validating data from multiple sources
• • Data Observability
• o Ability to monitor pipeline health, troubleshoot workflow issues, and proactively improve reliability and data quality

• Key Responsibilities
• Technical Execution & Leadership
• • Resource will provide technical execution and analytics leadership in support of the ADP Engineering team’s (part of the Central Analytics Organization) workstreams within the Marketplace domain and related initiatives
• Data Pipeline Development
• • Develop and optimize data pipelines
• • Build scalable pipelines using Python and dbt to support efficient data transformation and integration
• Data Management & Modeling
• • Design and maintain database tables, Snowflake structures, and data models to support reporting and analytics needs
• ETL / ELT Processes
• • Develop robust ETL/ELT workflows for extracting, transforming, and loading data while maintaining data quality and consistency
• Data Monitoring & Observability
• • Improve pipeline reliability through monitoring, observability, and proactive issue resolution
• Reporting & Dashboards
• • Build dashboards and provide updates that support actionable insights and business decision-making
• Collaboration & Communication
• • Partner cross-functionally to align on requirements
• • Communicate progress and ensure transparency across initiatives

Job Description - Grade Specific

Has more than a year of relevant work experience. Solid understanding of programming concepts, software design and software development principles. Consistently works to direction with minimal supervision, producing accurate and reliable results. Individuals are expected to be able to work on a range of tasks and problems, demonstrating their ability to apply their skills and knowledge. Organises own time to deliver against tasks set by others with a mid term horizon. Works co-operatively with others to achieve team goals and has a direct and positive impact on project performance and make decisions based on their understanding of the situation, not just the rules.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.