Data Engineer (DBT/Snowflake/PL/SQL)

Summary: The role of Data Engineer focuses on leveraging expertise in DBT, Snowflake, and PL/SQL to design and implement scalable data solutions within a large consulting organization. The position requires collaboration with various stakeholders to ensure high-quality data processing and transformation. The contract is for a duration of three months, based in Manchester. The ideal candidate will possess strong technical skills and experience in data engineering practices.

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

Key Skills:

• 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

Salary (Rate): undetermined

City: Manchester

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

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