Senior Snowflake Data Engineer
Hunter Bond
Charing Cross, United Kingdom
2 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
£ 221KJob location
Charing Cross, United Kingdom
Tech stack
Java
Airflow
Amazon Web Services (AWS)
Amazon Web Services (AWS)
ETL
Data Systems
Data Vault Modeling
Dimensional Modeling
Identity and Access Management
Python
OAuth
OpenID
SQL Databases
Snowflake
Kafka
Terraform
Job description
I'm working with a global trading firm looking for a Senior Snowflake Data Engineer to help build and optimise their enterprise data platform.
This role sits just below Architecture level and focuses on hands-on implementation, optimisation, and operation of Snowflake-based data solutions.
Key focus:
- Design and maintain Snowflake data models, schemas, and pipelines
- Build and orchestrate ETL/ELT workflows using Dagster or Airflow
- Develop and manage dbt data models (dimensional and Data Vault)
- Implement Terraform-based infrastructure automation for Snowflake resources
- Integrate secure access using OAuth/OIDC authentication
- Optimise Snowflake performance and cost efficiency
- Ingest and transform data from multiple internal and external systems
Requirements
- Strong hands-on Snowflake experience (development, optimisation, fundamentals of administration)
- Experience with dbt for modelling, testing, and deployment
- Knowledge of Data Vault 2.0 and dimensional modelling
- Experience with Terraform for infrastructure automation
- Familiarity with Dagster or Airflow orchestration
- Strong SQL and Python (or Java) skills
- Experience working with AWS (S3, IAM)
Must haves: experience with Kafka, Denodo, or financial markets/trading.