Data Architect (Contract) at hedgehog lab, Edinburgh EH1 1BB, £Contract Rate

We're hiring a Data Architect to shape the data platform for a large, established UK organisation going through a major transformation. It's a regulated, high-scale environment, and you'll own the target architecture for a move off Oracle onto Snowflake.

You'll set the direction other engineers build against.

What you'll do:

• Design the target data architecture: lakehouse and warehouse patterns, modelling standards, and how data flows across the platform.

• Own the migration strategy from Oracle to Snowflake, including sequencing, risk, and how legacy and new run side by side.

• Set modelling conventions and governance the wider data team works to.

• Work closely with engineering leads and stakeholders to keep the design grounded in what actually ships.

What we're looking for:

• Strong track record architecting data platforms at scale, with Snowflake front and centre.

• Deep experience with lakehouse and warehouse design and dimensional modelling.

• Hands-on experience planning and running Oracle to Snowflake migrations.

• Comfortable in a regulated environment where lineage and governance matter.

• You design for teams that build with AI-assisted engineering, and you're comfortable using AI tooling in your own work.

Bonus points for dbt, AWS, and experience in financial services or asset finance.

About hedgehog lab:

We're hedgehog lab, a digital product and engineering consultancy. For nearly 20 years we've embedded engineers inside the teams of well-known organisations in regulated, high-trust sectors, from financial services to the public sector.

We're a certified B Corp.

We're also serious about AI-assisted engineering. We've built our own agentic tooling and cut time-to-merge by around 60% on recent work, and our people get to use that on real projects.

The details:

• Contract, outside IR35.

• 3 to 6 months, with strong potential to extend.

• Hybrid. You'll work from the client's London, Bristol or Edinburgh office a couple of times a week.

Apply below and I'll come back to you quickly.