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.