Data Engineer

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.