Data Engineer

Capgemini; Manchester; On-site; GBP 55,000 - 75,000; Full time

Job summary

A leading global consultancy in Manchester seeks a Data Engineer to design data transformation pipelines and ensure data quality. The ideal candidate has 5 years of experience in data engineering, with strong skills in DBT, Snowflake, and PL/SQL. Join a collaborative team dedicated to leveraging technology for sustainable impact.

Qualifications

• 5 years of experience in data engineering or a related field.
• Strong hands-on experience with DBT and modular SQL development.
• Advanced knowledge of PL/SQL with experience in stored procedures.

Responsibilities

• Design and implement scalable data models and transformation pipelines.
• Write efficient and maintainable PL/SQL code for complex data tasks.
• Optimize Snowflake performance through query tuning and management.

Skills

Data modeling

DBT

Snowflake

PL/SQL

Data quality and governance

Version control (Git)

CICD practices

Airflow

Tools

Git

Data Build Tool (DBT)

CICD pipelines

Job description

GET THE FUTURE YOU WANT!

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

YOUR ROLE

Data Engineer with deep expertise in DBT Data Build Tool Snowflake and PLSQL to join our growing data team. Person will be responsible for designing developing and maintaining robust data transformation pipelines that support business intelligence analytics and data science initiatives

YOUR PROFILE

• Design and implement scalable data models and transformation pipelines using DBT on Snowflake
• Write efficient and maintainable PLSQL code for complex data processing and transformation tasks
• Collaborate with data analysts data scientists and business stakeholders to understand data requirements and deliver highquality solutions Optimize Snowflake performance through query tuning clustering and resource management
• Ensure data quality integrity and governance through testing documentation and monitoring
• Participate in code reviews architecture discussions and continuous improvement initiatives
• Maintain and enhance CICD pipelines for DBT projects
• 5 years of experience in data engineering or a related field Strong hands on experience with DBT modular SQL development testing documentation
• Proficiency in Snowflake data warehousing performance tuning security Advanced knowledge of PLSQL and experience with stored procedures functions and packages
• Solid understanding of data modeling concepts starsnowflake schemas normalization
• Experience with version control systems eg Git and CICD practices Familiarity with orchestration tools eg Airflow dbt Cloud Prefect is a plus

ABOUT CAPGEMINI

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 350,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