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
