Lead Data Migration Architect

• Lead the design, assurance, and delivery of secure, cloud-based data migration solutions for UK Central Government departments
• Combine architectural strategy with hands-on migration delivery oversight and testing governance
• Shape target-state data platforms while ensuring data is migrated accurately, securely, and efficiently within regulated, security-conscious environments
• Strong emphasis on data migration validation, ETL testing, and pipeline assurance, particularly within AWS-based Data Lakehouse architectures
• Define and govern end-to-end migration testing strategies, ensuring successful transition of data from legacy data warehouses to modern cloud platforms

• Recent experience as a Lead Data Migration Architect, Lead Data Architect, or Data Solutions Architect in migration-focused programmes
• Demonstrated ownership of end-to-end data migration strategy, execution, and testing assurance
• Experience operating in consulting, systems integration, or delivery partner roles
• Proven leadership of cross-functional migration teams, including engineers, testers, and architects
• Experience working within UK Central Government or ALBs strongly preferred
• Strong experience designing and delivering large-scale data migration solutions
• Experience designing end-to-end data migration architectures from legacy systems to cloud platforms
• Experience defining migration strategies including bulk data loads followed by incremental/delta processing
• Re-platforming and repointing of data pipelines
• Experience leading migration programmes from legacy data warehouses to AWS Data Lakehouse architectures
• Experience designing migration frameworks covering data extraction, transformation, and loading (ETL/ELT)
• Data staging, reconciliation, and validation
• Migration orchestration and monitoring
• Strong practical experience defining and overseeing data engineering testing within migration programmes
• Testing end-to-end ETL/ELT data pipelines on AWS, including AWS Glue-based solutions
• Validating data feed pipeline migrations, including repointing pipelines to new AWS Data Lakehouse architectures
• Overseeing testing of pipelines underpinned by AI ETL accelerators, Python / PySpark, SQL transformations, YAML-driven configuration frameworks
• Validating bulk migration loads followed by incremental/delta data processing from legacy data warehouses
• Defining and implementing data reconciliation frameworks, data completeness and accuracy checks, transformation validation rules, regression testing across migration cycles
• Establishing automated testing frameworks for large-scale data migration assurance
• Strong experience with AWS cloud-native data platforms, including AWS Glue, S3-based data lakes, Lakehouse architectures using Apache Iceberg
• Familiarity with data lake and lakehouse patterns, event-driven and streaming architectures
• Understanding of where modern migration approaches add value vs traditional ETL patterns
• Candidates must be eligible for SC clearance (existing SC clearance desirable
• BPSS minimum required)

Existing SC clearance

• Range of tailored benefits supporting physical, emotional, and financial wellbeing
• Learning and Development opportunities for continuous growth and development
• Opportunity for flexible work options
• Inclusive work environment
• Disability Confident Committed Employer