DBT Data Engineer
Posted 1 day ago by Robert Half
Negotiable
Inside
Hybrid
London, UK
Summary: The role of DBT Data Engineer involves designing, delivering, and supporting a modern cloud data warehouse using Snowflake and dbt for a global consulting firm. The position focuses on building scalable ELT pipelines and high-quality data models to enhance business-wide analytics and reporting. This is an interim contract expected to last for six months with potential extensions. The role requires a hybrid working arrangement with two days on-site in London.
Key Responsibilities:
- Design, deliver, and support a modern cloud data warehouse using Snowflake and dbt.
- Build scalable ELT pipelines and high-quality data models for analytics and reporting.
- Collaborate with technical and business stakeholders to ensure effective data solutions.
- Support end-to-end data pipelines including ingestion, transformation, and validation.
- Optimize performance and troubleshoot dbt model failures and production support workflows.
Key Skills:
- Experience in Insurance/Reinsurance or broader Financial Services.
- Hands-on experience with Snowflake and building data solutions.
- Proven experience with dbt including models, incremental loads, and documentation.
- Excellent SQL engineering and data modelling skills.
- Familiarity with cloud-based data environments (Azure preferred, AWS considered).
- Strong communication skills for collaboration across stakeholders.
Salary (Rate): £450 p/day
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
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).
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: