SC-Cleared Data Engineer for AWS Lakehouse Migration

Experis IT; Telford; Hybrid; GBP 83,000 - 92,000; Full time

Job summary

Experis IT in the United Kingdom seeks an SC-cleared Data Engineer to join a major data transformation programme migrating a large Legacy data warehouse estate to an AWS Lakehouse on AWS. The role focuses on analysing data feeds, ETL processes, and transformations to produce structured specifications for migration and modernisation.

The successful candidate will work in discovery teams, document data lineage, mappings, and support knowledge transfer with engineering and analytics teams, while

Qualifications

• Strong Data Engineering experience in complex data integration and warehousing.
• Sharp SQL skills and ETL knowledge.
• Experience analysing legacy systems, codebases, and technical documentation.
• Knowledge of data lineage, data mapping, and transformation processes.
• Active SC Clearance and experience in Agile delivery.

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.

Skills

Data engineering

SQL

ETL processes

Legacy systems analysis

Data lineage & mapping

Agile delivery

Analytical thinking

SC Clearance

Tools

AWS

Oracle SQL/PL/SQL

Informatica PowerCenter

Pentaho Data Integration

Unix/Bash scripting

Cobol

Prompt Engineering

Job description

Experis IT in the United Kingdom seeks an SC-cleared Data Engineer to join a major data transformation programme migrating a large Legacy data warehouse estate to an AWS Lakehouse on AWS. The role focuses on analysing data feeds, ETL processes, and transformations to produce structured specifications for migration and modernisation.

The successful candidate will work in discovery teams, document data lineage, mappings, and support knowledge transfer with engineering and analytics teams, while