Lead Data Engineer

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

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.

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

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.

Lead Data Engineer | Azure PostgreSQL, Data Migration, ETL | Public Sector Programme Moving a Critical Service onto Azure | ***Active SC Clearance***