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
£ 221K

Job 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.

Apply for this position