Data Engineer - DBT Azure Snowflake
Posted 1 week ago by Robert Half
£60 Per hour
Inside
Hybrid
London Area, United Kingdom
Summary: The role of Data Engineer focuses on designing and building a cloud data warehouse solution using Snowflake, dbt, and Azure DevOps for a global consulting firm. This interim position involves delivering scalable ELT pipelines and optimized data models to enhance business-wide analytics and reporting. The contract is initially for six months with the possibility of extensions, requiring a hybrid working arrangement in the City of London. Candidates should have a strong background in financial services, particularly in insurance, and relevant technical expertise.
Key Responsibilities:
- Design and build a cloud data warehouse solution using Snowflake, dbt, and Azure DevOps.
- Deliver scalable ELT pipelines and optimized data models for analytics and reporting.
- Manage Snowflake Cloud Data Warehouses, including performance tuning and cost optimization.
- Develop and maintain CI/CD pipelines using Azure DevOps.
- Engage with stakeholders across technical and business teams to ensure clear communication.
- Implement data quality and automation in data pipeline development.
Key Skills:
- Proven experience with Snowflake Cloud Data Warehouses.
- Strong hands-on experience with dbt for data modeling and testing.
- Solid understanding of Azure DevOps for CI/CD pipelines.
- Excellent SQL engineering and data modeling skills.
- Experience in data pipeline development and automation.
- Clear communication skills for stakeholder engagement.
- Exposure to Azure Data Factory or Databricks is a plus.
- Python scripting for ELT automation and testing is desirable.
Salary (Rate): £60.00/hr
City: London
Country: United Kingdom
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 Snowflake Data Engineer . This role will help design and build a new cloud data warehouse solution using Snowflake , dbt , and Azure DevOps , delivering scalable ELT pipelines and optimised 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 plus 12.07% holiday pay via PAYE with employer’s NI & Tax deducted at source, unlike umbrella companies and no umbrella company admin fees)
- Start Date: c. 1-2 weeks turnaround with anticipated start on w/c 6th April
Key Skills & Experience
- Financial Services will be essential for this opportunity. Ideally Insurance.
- Proven experience building and managing Snowflake Cloud Data Warehouses (warehouses, roles, RBAC, performance tuning, cost optimisation).
- Strong hands-on experience with dbt (modelling, incremental loads, macros, testing, documentation).
- Solid understanding of Azure DevOps for CI/CD pipelines (YAML, environments, approvals, Git branching).
- Excellent SQL engineering and data modelling (star/snowflake schemas, best practices).
- Experience in data pipeline development , data quality , and automation .
- Clear communicator with strong stakeholder engagement across technical and business teams.
- Nice to have: Exposure to Azure Data Factory , Databricks , or other orchestration tools.
- Python scripting for ELT automation and testing.
- All candidates must complete standard screening (Right to Work, DBS, credit/sanctions, employment verification).