Prism Digital
Lead Data Engineer
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Lead Data Engineer | Azure PostgreSQL, Data Migration, ETL | Public Sector Programme Moving a Critical Service onto Azure | Active SC Clearance
Location
Remote, with one day a month (the last Tuesday) in the office in Staines or Newcastle
Security Clearance
Active SC required
Role Overview
I'm working with a UK public sector programme that's hiring two Lead Data Engineers to move a legacy platform off Actian and onto Azure PostgreSQL. You'll design the migration end to end, from the target data model through to the ETL that moves live data into staging and production.
You'll be one of the two leads in a brand-new Data Migration Squad, working remotely with one day a month in Staines or Newcastle. This is database work, with no Java or application development in it.
There's a hard deadline behind the programme because the current licence runs out, so it suits someone who has delivered large migrations to a fixed date before.
Reasons to use Rodeo
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.
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.
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 They're Looking For (Non-Negotiables)
- Active SC clearance
- Extract, Transform, Load (ETL): designing and building pipelines at scale
- Data migration: planning and delivering large legacy migrations
- Data modelling: logical and physical
- Data quality, validation, and reconciliation
- Reporting data structures and optimisation
- Technical leadership across migration and modelling work
- Travel to Newcastle or Staines last Tuesday of every month
What You'll Work With
- Azure Database for PostgreSQL
- Azure data platform services
- Staging and production database environments
- The data behind more than 140 operational reports
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Nice to Haves
- Actian or Ingres
- Data governance frameworks
- Previous public sector programme delivery
Why Join / Projects
You'll build the data migration capability from scratch. The team doesn't have data engineering skills in-house yet, so you'll set the approach, the standards, and the way data moves into the new platform as it comes online.
The work matters to people who rely on the service. Reporting and service continuity both depend on the migration landing on time, and you'll work directly with business and technical stakeholders to shape how reporting works on the new platform.
Employee Benefits
- Pension
- Private healthcare
- Rewards gateway
- 25 days holiday
If you've taken a big legacy estate across to PostgreSQL before, apply and I'll give you a call.
“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
Location