DBT Data Engineer (DBT & Snowflake)

DBT Data Engineer (Snowflake, Azure) | Insurance | London (Hybrid) Robert Half International (an S&P 500 global staffing provider) is supporting a global consulting firm in sourcing an experienced DBT Data Engineer to join a major insurance client engagement. The role focuses on scaling a Snowflake Data Warehouse and expanding its DBT Cloud modelling capabilities to support new analytics and regulatory data use cases across the business. Assignment Details • Initial Duration: 6–12 months (until March 2026, likely extension given scope) • Location: Hybrid – minimum of 2 days per week in London • Day Rate: £450 PAYE (plus 12.07% holiday pay – PAYE with employer’s NI & Tax deducted at source, unlike umbrella companies and no umbrella company admin fees) You’ll be part of a growing data engineering function focused on DBT model development, Snowflake optimisation, and data governance across multiple data domains. This role suits a technically strong engineer with proven DBT Cloud experience who can take ownership of data pipelines and drive best practices in transformation, testing, and automation. Key Skills & Experience • Deep DBT Cloud expertise, including models, macros, tests, documentation, and CI/CD integration. • Hands-on experience developing and optimising in Snowflake Cloud Data Warehouse (schemas, warehouses, security, time travel, performance tuning). • Familiarity with Snowflake cost monitoring, governance, replication, and environment management. • Strong understanding of data modelling (star/snowflake schemas, SCDs, lineage). • Proven Azure experience (Data Factory, Synapse, Databricks) for orchestration and integration. • Proficient in SQL for complex analytical transformations and optimisations. • Comfortable working in agile teams and using Azure DevOps for CI/CD workflows. • Prior experience in financial services or insurance environments would be desirable All candidates must complete standard screening (Right to Work, DBS, credit/sanctions, employment verification). This is an exciting opportunity for a DBT-focused Data Engineer to join a high-performing consulting team and help build, scale, and optimise modern Snowflake data solutions within a leading insurance organisation.