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.
Rate:
£800/day
Location:
London
IR35 Status:
Inside
Remote Status:
Hybrid
Industry:
Data & Analytics
Seniority Level:
Senior