DBT Cloud 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
1. Initial Duration: 6 months (likely extension given scope)
2. Location: Hybrid - minimum of 2 days per week in London
3. Day Rate: £450 p/day via 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
4. Deep DBT Cloud expertise, including models, macros, tests, documentation, and CI/CD integration.
5. Hands-on experience developing and optimising in Snowflake Cloud Data Warehouse (schemas, warehouses, security, time travel, performance tuning).
6. Familiarity with Snowflake cost monitoring, governance, replication, and environment management.
7. Strong understanding of data modelling (star/snowflake schemas, SCDs, lineage).
8. Proven Azure experience (Data Factory, Synapse, Databricks) for orchestration and integration.
9. Proficient in SQL for complex analytical transformations and optimisations.
10. Comfortable working in agile teams and using Azure DevOps for CI/CD workflows.
11. 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.
Robert Half Ltd acts as an employment business for temporary positions and an employment agency for permanent positions. Robert Half is committed to diversity, equity and inclusion. Suitable candidates with equivalent qualifications and more or less experience can apply. Rates of pay and salary ranges are dependent upon your experience, qualifications and training.