Sr Data Engineer

Job description

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 DescriptionRole 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
• Experience building scalable data pipelines, automation scripts, and data processing workflows
• Snowflake
• Hands-on experience designing and maintaining cloud data warehouse structures, tables, and performant data models
• dbt
• 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
• 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 initiativesJob Description - Grade SpecificHas 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.