Quick overview
Job description
Role Title: Data Engineer
Duration: 6 month contract
Location: Telford or Hove - typically required once or twice a month
Rate: up to £500.48 p/d Umbrella inside IR35
Clearance required: Active SC Clearance held by a governing body is required
Role purpose / summary
An experienced Data Engineer is required to support the CDW SA team in delivering DWIT Informatica Advanced Scans across legacy data warehouses. This role is a key enabler for the strategic migration from legacy data warehouses to the new Data Lakehouse architecture.
The successful candidate will work closely with DWIT and CDW stakeholders to establish a comprehensive and accurate as-is view of each legacy warehouse, leveraging Informatica Advanced Scanning capabilities wherever possible.
Key Responsibilities:
- Perform detailed analysis of legacy data warehouses using Informatica Advanced Scanning techniques.
- Produce a complete and accurate as-is representation of each data warehouse.
- Identify and document all inbound data feeds consumed by CDW, including:
- Source/origin systems
- Data formats
- Full feed-by-feed data content
- Capture and document the actual metadata held within the data warehouse, including:
- Table structures
- Field names and definitions
- Identify and document all outbound data feeds from the data warehouse, including:
- Consuming systems or platforms
- Full feed-by-feed data content
- Outbound metadata (tables, fields, and structures)
- Where possible, generate bespoke outputs from Informatica Advanced Scanning for each legacy warehouse to support analysis and migration planning.
- Collaborate with architecture, data, and migration teams to ensure outputs are aligned to Data Lakehouse migration objectives.
- Ensure documentation is clear, accurate, and suitable for use in downstream migration and governance activities.
Required Skills and Experience:
- Strong experience with Unix shell scripting
- PL/SQL and Oracle SQL
- Maestro / TWS scheduling tools
- ETL concepts and implementations
- Command line tools (PuTTY / CLI)
- File transfer tools (e.g. WinSCP)
- Use of text and documentation tools (e.g. Notepad++, Word or equivalent)
Desirable Knowledge and Experience:
- SA Profiles extracts
- SA MARTs
- SA Warehouse structures and concepts
- Caseflow and KBS
- Authorete
- Eureka
- Business Objects tooling:
- BO Infoview
- BO Developer
- BO CMC
- BO Import Wizard
Additional Information:
This role is hands-on and delivery-focused, supporting a critical phase of legacy-to-Lakehouse migration.
Strong attention to detail, documentation quality, and stakeholder collaboration are essential.
This is a hybrid role, with office attendance at either Telford or Hove typically required once or twice a month, depending on team collaboration and client requirements.
All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!
If you receive suspicious outreach claiming to be from us, please contact us via the ManpowerGroup website.
Will your CV get past this employer's screening? Check your CV against this job, free
Similar jobs
- H-

Data EngineerRecently posted
Harnham - Data & Analytics Recruitment · London · Hybrid · Posted 19 Nov 2026 🇬🇧
GCPSQLETL+3Technology£100k - £120k/yr - OC

Lead Data EngineerRecently posted
Ocho · Belfast, Northern Ireland · Hybrid · Posted 18 Nov 2026 🇬🇧
GCPSQLScala+6TechnologySalary not listed - LR
Data Engineer - SC ClearedRecently posted
Lorien Resourcing Limited · South East London, London · On-site · Posted 20 Nov 2026 🇬🇧
SQLShellGit+13TechnologySalary not listed - NO

Apprentice Data EngineerRecently posted
NowSkills · Birkenhead, Merseyside · Hybrid · Posted 20 Nov 2026 🇬🇧
PL/SQLSQLAWS+4Technology£20k - PE

Lead Data EngineerRecently posted
PeoplePlus · City, Bristol · Hybrid · Posted 20 Nov 2026 🇬🇧
Technology£55k - £65k/yr - 83

Data Engineer - Azure DatabricksRecently posted
83zero Limited · City, London · Hybrid · Posted 20 Nov 2026 🇬🇧
DatabricksAzureTechnology£90k - £100k/yr - PE

Data Engineer IIIRecently posted Auto Apply
Pearson · United Kingdom · Hybrid · Posted 20 Nov 2026 🇬🇧
MySQLSQLGit+7TechnologySalary not listed - MG
Python Data EngineerRecently posted Auto Apply
Man Group · London · On-site · Posted 20 Nov 2026 🇬🇧
OracleSQLGit+12TechnologySalary not listed - ZO
Data Engineering ManagerRecently posted Auto Apply
Zoopla · London · Hybrid · Posted 20 Nov 2026 🇬🇧
AWSETLDatabricks+3Salary not listed - OC

Senior Data EngineerRecently posted
Ocho · Belfast, Northern Ireland · Hybrid · Posted 21 Nov 2026 🇬🇧
DockerSQLAWS+10Technology£80k - £90k/yr - NO

Apprentice Data EngineerRecently posted
NowSkills · Birkenhead, Merseyside · Hybrid · Posted 19 Nov 2026 🇬🇧
Technology£20k/yr - LR
Data Engineer - SC ClearedRecently posted
Lorien Resourcing Limited · South East · On-site · Posted 19 Nov 2026 🇬🇧
TechnologySalary not listed
