Rodeo
ResourcesPartnersSign in

hedgehog lab

Data Architect (Contract)

City of Edinburgh
Posted about 18 hours ago
Sign up to applySee more jobs like this

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

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.

Reasons to use Rodeo

I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?

Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.

Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.

Start with a chat, not a search bar

Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.

See breakdown
Save jobNot relevant
View details

It searches the market for you

Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.

Why you're a good match

You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.

See breakdown
Strong

Experience fit

Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.

See breakdown
Strong

Only hits

No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.

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.

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

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.

Trusted by 25,000+ job seekers

“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”

Jessica, London

Get help applying for this job

Skills

Data Architecture
Snowflake
Oracle
Lakehouse Design
Data Warehouse Design
Dimensional Modelling
Data Migration
Data Governance
Data Lineage
dbt
AWS
AI-assisted Engineering
Data Modelling Standards

Location

City of Edinburgh, Scotland, United Kingdom

Sign up to applySee more jobs like this