Data Engineer

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.

Working within discovery teams, you’ll analyse Legacy data feeds, applications, and ETL processes, helping to document and transform existing logic into structured specifications that support large-scale migration and modernisation activities. You’ll also leverage AI-enabled tooling and prompt engineering techniques to accelerate analysis and documentation across a substantial portfolio of data services., * 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.

• 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.

If you’re an SC-cleared Data Engineer with strong SQL, ETL, and data migration experience, we’d love to hear from you.