Data Engineer (DBT/Snowflake/PL/SQL)

Location: Manchester

3 months contract

We are working with a large consulting organisation that is seeking an experienced Data Engineer with strong expertise in DBT (Data Build Tool), Snowflake, and PL/SQL to join their data team based in Manchester.

Key Responsibilities

• Design and implement scalable data models and transformation pipelines using DBT on Snowflake

• Develop efficient and maintainable PL/SQL code for complex data processing and transformation

• Collaborate with data analysts, data scientists, and business stakeholders to gather requirements and deliver high-quality data solutions

• Optimise Snowflake performance through query tuning, clustering, and resource management

• Ensure data quality, integrity, and governance through testing, documentation, and monitoring

• Participate in code reviews, architectural discussions, and continuous improvement initiatives

• Maintain and enhance CI/CD pipelines for DBT projects

Required Skills & Experience

• Proven experience as a Data Engineer or in a similar role

• Strong hands-on experience with DBT (modular SQL development, testing, documentation)

• Solid expertise in Snowflake (data warehousing, performance tuning, security)

• Advanced PL/SQL skills, including stored procedures, functions, and packages

• Strong understanding of data modelling concepts (star/snowflake schemas, normalisation)

• Experience with version control (eg Git) and CI/CD practices