Snowflake Data Engineer

Urgent

Job Description

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.

Bright Purple is an equal opportunities employer: we are proud to work with clients who share our values of diversity and inclusion in our industry.

Location