IT

Data Engineer (DBT/Snowflake/PL/SQL)

Lancashire United KingdomOn-siteAgency contract (e.g. ANÜ)
Posted by
Synergize Consulting Ltd
Contact person
Generic Network
Project ID
2965192
Business Process ImprovementCluster AnalysisCode ReviewConsultingContinuous IntegrationData ModelingData QualityData SystemData WarehousingGovernancePerformance TuningQuery OptimizationRequirements AnalysisResource ManagementStored ProcedurePL-SQLSQL DatabasesData ProcessingTestingSnowflakeData Build Tool (dbt)GitSafety PrinciplesSoftware Version Control

Description

Data Engineer (DBT/Snowflake/PL/SQL)

Location: Manchester

3 months contract

£340p/d inside IR35

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

Application form