Data Engineer

The Opportunity

We're looking for experienced SC Cleared Data Engineers to join a major data transformation programme focused on migrating a large-scale legacy data warehouse estate to a modern AWS Lakehouse platform.

Key Responsibilities

• Analyse legacy code, ETL processes, and technical documentation to understand data feed behaviour and business logic.
• Document complex data flows, transformations, mappings, and lineage.
• Convert legacy logic into structured, machine-readable specifications.
• Utilise AI tooling and prompt engineering techniques to support discovery and analysis activities.
• Support the identification, validation, and cataloguing of migration artefacts.
• Maintain documentation repositories and ensure traceability across deliverables.
• Collaborate with Technical Leads, Architects, Analysts, and Engineering teams to resolve technical queries and knowledge gaps.
• Support knowledge transfer sessions and walkthroughs with stakeholders and downstream delivery teams.

Essential Skills & Experience

• Strong Data Engineering experience.
• Experience working with complex data integration and data warehousing environments.
• Strong SQL skills and understanding of ETL processes.
• Experience analysing legacy systems, codebases, and technical documentation.
• Knowledge of data lineage, data mapping, and transformation processes.
• Experience working within Agile delivery environments.
• Strong analytical and problem-solving skills.
• Active SC Clearance.

Highly Desirable Skills

• Experience with one or more of the following:
• AWS Data Platforms
• Data Warehouse Migration Programmes
• Oracle SQL / PL/SQL
• Informatica PowerCenter
• Pentaho Data Integration
• SAP Data Services
• Unix / Bash Scripting
• COBOL
• Prompt Engineering
• AI-enabled analysis and documentation tools

What We're Looking For

We're seeking Data Engineers with strong technical analysis skills who can quickly understand complex legacy environments and help accelerate large-scale cloud migration programmes.

Experience working with data warehousing, ETL technologies, and modern AWS data platforms will be highly beneficial.