DBT Data Engineer (Snowflake)

Robert Half International (an S&P 500 global staffing provider) is supporting a global consulting firm in sourcing an interim DBT Data Engineer. This role will focus on designing, delivering and supporting a modern cloud data warehouse using Snowflake and dbt, building scalable ELT pipelines and high-quality data models to support business-wide analytics and reporting. Assignment Details • Initial 6-month contract (extensions expected) • Hybrid – 2 days per week on-site in the City of London • £400–450 p/day + 12.07% hol pay (PAYE with employer’s NI & Tax deducted at source, unlike umbrella companies and no umbrella admin fees) • Start Date: c. 1–2 weeks turnaround Key Skills & Experience • Insurance / Reinsurance experience strongly preferred but broader Financial Services experience will also be considered • Strong hands-on experience building and supporting data solutions in Snowflake (ELT pipelines, performance optimisation, data modelling) • Proven experience with dbt including models, incremental loads, hooks, testing, snapshots and documentation • Good operational understanding of dbt model failures, notifications, troubleshooting and production support workflows • Excellent SQL engineering and data modelling experience (star/snowflake schemas, best practices) • Experience designing and supporting end-to-end data pipelines (ingestion, transformation, validation) • Familiarity with Snowflake features including Time Travel, cloning and RBAC • Experience working in cloud-based data environments (Azure preferred, AWS also considered) • Familiarity with CI/CD pipelines and deployment processes (Azure DevOps or similar) • Strong communication skills and ability to work across technical and business stakeholders Nice to have • Experience with orchestration tools (Airflow, Azure Data Factory or similar) • Python for automation, testing or data engineering support • Exposure to Databricks or modern Lakehouse environments All candidates must complete standard screening (Right to Work, DBS, credit/sanctions, employment verification).