Senior Snowflake Data Engineer (Data Vault & dbt)
Inside IR35 Contract - Hybrid Working in Central London - Up to £800 per day
Finance/Capital Markets experience is a must!
A leading global energy and commodities organisation with operations across major international markets. Its Enterprise Data Platform, built on Snowflake and modern data engineering practices, supports data-driven decision making across trading, risk, finance and operations.
We are looking for an experienced Senior Snowflake Data Engineer to design, build and maintain high-quality enterprise data products.
This is a hands-on engineering role focused on Data Vault modelling, dbt, ELT pipelines and data integration. You'll work closely with architects, application teams and business stakeholders to deliver trusted, scalable data solutions.
You'll join an established data platform, with your primary focus on data engineering rather than platform ownership.
Key Responsibilities
- Design and implement Data Vault 2.0 models.
- Build and maintain dbt projects for transformation, testing and documentation.
- Develop scalable ELT pipelines using Snowflake, SQL and Python.
- Integrate data from APIs, databases and cloud storage.
- Build reusable business models and curated data products.
- Implement automated data quality checks and testing.
- Optimise Snowflake performance and costs.
- Work with architects to apply enterprise data modelling standards.
- Collaborate with technical and business stakeholders.
- Support production workloads and troubleshoot data issues.
- Contribute to code reviews and engineering best practices.
Essential Skills & Experience
- Strong commercial experience with Snowflake and dbt.
- Hands-on experience with Data Vault 2.0.
- Strong SQL and Python skills.
- Experience building scalable ELT/data pipelines.
- Experience with Git and modern development practices.
- Understanding of dimensional modelling.
- Experience with automated testing and data quality.
- Knowledge of Snowflake performance optimisation.
- Familiarity with Airflow, Dagster or similar orchestration tools.
- Experience integrating data from multiple source systems.
Desirable
- AutomateDV with dbt.
- dbt Mesh.
- Terraform/Infrastructure-as-Code.
- Snowflake RBAC, OAuth and OIDC.
- AWS, particularly S3 and IAM.
- Kafka or streaming ingestion.
- Denodo or data virtualisation.
- Experience in commodities or capital markets.