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.
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.
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.
If you're an SC-cleared Data Engineer with strong SQL, ETL, and data migration experience, we'd love to hear from you.