DBT Data Engineer DBT & Snowflake

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.

• 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.

• 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.

• Python or PySpark for automation and data quality testing.
• Knowledge of data governance and security frameworks (RBAC, masking, encryption).
• Prior experience in financial services or insurance environments.

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. If you wish to apply, please read our Privacy Notice describing how we may process, disclose and store your personal data: gb/en/privacy-notice.