Data Engineer at Bright Purple, Edinburgh, £500-£550 per day

Snowflake Data Engineer (Contract - Outside IR35)

Hybrid (2 days onsite) – Edinburgh | £500 – £550 per day | 6 months | ASAP

Role Overview

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.

Essential Skills

• 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

• AWS (Lambda, Glue, Step Functions)
• Workato or similar iPaaS tools
• Python / Snowpark
• Data governance / cataloguing

This is an Outside IR35 contract role and hybrid to Edinburgh. Very strong chances of extension and for a leading product company.

If you are keen APPLY NOW.