Lead Data Engineer (SC Cleared)

About Scrumconnect Consulting

Scrumconnect Consulting is a multi-award-winning UK public sector digital consultancy, positively influencing the lives of over forty million UK citizens. We bring deep expertise in agile delivery, digital transformation, and platform engineering across central government. With a team of over one hundred and twenty-five professionals - more than forty percent of whom are women - we are committed to building inclusive, diverse teams that reflect the communities we serve.

Role Overview

We are looking for Lead Data Engineer to join a dedicated Data Migration Squad supporting the migration of CRS data and reporting capabilities to a new platform.

The role requires strong specialist expertise in data migration, data modelling, ETL, database design, and Azure PostgreSQL . You will take technical ownership of designing and delivering the end-to-end data migration capability, ensuring data is migrated accurately, securely, and within critical programme timelines.

This is a senior data engineering and database-focused role and does not require Java or application development expertise.

Key Responsibilities

Design and deliver the end-to-end data migration strategy for CRS.

Develop and implement ETL processes to Azure PostgreSQL to support data migration and future operational requirements.

Design and maintain logical and physical data models for the target platform.

Establish the data migration capability as the new platform becomes available.

Define and implement approaches for moving CRS data into staging and production database environments .

Develop robust processes for data extraction, transformation and loading.

Ensure data quality, validation, reconciliation and governance throughout the migration life cycle.

Support the migration and transformation of data required for 140+ operational reports .

Work closely with business and technical stakeholders to understand reporting requirements.

Ensure target data structures support both current and future reporting requirements.

Provide technical leadership and oversight across data mig...