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.