Data Engineer - SQL, Dbt

Location - London (3 days a week) Outside IR35 6 Month Contract Start - March A leading consultancy is seeking a Senior Data Engineer for a high-impact data transformation project within the Retail Banking sector. This is a 6-month contract, classified as outside IR35, starting at the beginning of March 2026. The role is based in Central London (near Liverpool Street Station) with a hybrid requirement of three days per week on-site. The Role You will focus exclusively on the transform side of the data pipeline. The core objective is migrating dbt models from one data modelling strategy to another. You will work iteratively to deliver resilient, high-quality data projections within a Google Cloud Platform (GCP) environment. Key Responsibilities: • Data Modelling: Decomposing complex data projections and implementing robust dimensional models. • dbt Development: Crafting and optimising views and queries using SQL and dbt to answer analytical questions. • CI/CD & Quality: Applying software engineering best practices, including automated testing and reproducible CI/CD pipelines, to ensure production-grade quality. • Stakeholder Collaboration: Working closely with model owners and source system teams to ensure seamless migration and data governance. Required Skills & Experience: • Expert SQL & dbt - deep experience with SQL dialects and the ability to optimise queries through indexing and partitioning. • Strong background in data modelling fundamentals and "what good looks like" for scalable data structures. • Experience with BigQuery/GCP is preferred, though dbt experience in any cloud environment (AWS/Azure) is acceptable. • Familiarity with Git, TDD, and infrastructure as code (Terraform/Ansible). • Consulting Approach – a collaborator who seeks peer reviews and can influence stakeholders in a highly regulated environment. • Prior experience in Retail Banking or financial services is highly desirable.