Data Engineer - DBT Experience
Posted 6 days ago by Lorien
£347 Per day
Inside
Onsite
Manchester, UK
Summary: The role of Data Engineer focuses on utilizing DBT, Snowflake, and PL/SQL to design, develop, and maintain data transformation pipelines that support business intelligence and analytics. The position requires collaboration with various stakeholders to ensure high-quality data solutions and optimization of performance. The role is based in Manchester and requires on-site presence 2 to 3 days a week. The contract is set to last until December 31, 2025.
Key Responsibilities:
- Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
- Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality 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 CI/CD pipelines for DBT projects.
Key Skills:
- 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 PL/SQL and experience with stored procedures, functions, and packages.
- Solid understanding of data modelling concepts (star/snowflake schemas, normalization).
- Experience with version control systems (eg, Git) and CI/CD practices.
- Familiarity with orchestration tools (eg, Airflow, dbt Cloud, Prefect) is a plus.
Salary (Rate): £346.50 per day
City: Manchester
Country: UK
Working Arrangements: on-site
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Role Title: Data Engineer with DBT (Data Build Tool), Snowflake, and PL/SQL
Location: Manchester - onsite 2/3 days a week
Duration: 31/12/2025
Pay Rate: £346.50 (Inside of IR35)
Data Engineer with deep expertise in DBT (Data Build Tool), Snowflake, and PL/SQL 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.
Key Responsibilities:
. Design and implement scalable data models and transformation pipelines using DBT on Snowflake.
. Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks.
. Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality 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 CI/CD pipelines for DBT projects.
Required Qualifications:
. 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 PL/SQL and experience with stored procedures, functions, and packages.
. Solid understanding of data modelling concepts (star/snowflake schemas, normalization).
. Experience with version control systems (eg, Git) and CI/CD practices.
. Familiarity with orchestration tools (eg, Airflow, dbt Cloud, Prefect) is a plus.
Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.
