Snowflake Data Engineer

Bright Purple Resourcing Ltd

Edinburgh, 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

£ 143K

Job location

Edinburgh, United Kingdom

Tech stack

Airflow

Amazon Web Services (AWS)

Data Governance

Python

Role-Based Access Control

Workflow Management Systems

Macros

Sql Optimization

Snowflake

Zapier

Amazon Web Services (AWS)

Job description

We are looking for a senior Snowflake Data Engineer to lead the migration from a bespoke AWS data platform to a modern Snowflake Lakehouse. This is hands-on and leadership combined. you will modernise an existing estate (not greenfield), deliver BAU improvements, and upskill the internal team to own the platform long-term.

You will be working across Lambda, Glue, and Step Functions pipelines, moving transformations into dbt Core, and shaping the future architecture across orchestration, security, and cost control.

Requirements

Strong Snowflake experience (Lakehouse design, RBAC, security, cost optimisation)
Deep dbt Core expertise (modelling, testing, macros, SCDs, incremental models)
Solid dimensional modelling (Kimball - star schemas, facts/dimensions)
Advanced SQL
Orchestration tools (Airflow, Dagster or similar)

Bonus Points