Senior Data Engineer - Data Architecture Discovery & Documentation

Impellam Group

Warrington, UK

about 1 month ago

Apply on www.apply4u.co.uk

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.apply4u.co.uk

Tech stack

Amazon Web Services Confluence Code Review Data Architecture Extract Transform Load (ETL) Data Systems Data Warehousing Microsoft SQL Server Markdown Reverse Engineering SQL Databases Data Streaming

+2 more

Technical Data Management Systems Data Pipelines

Job description

Role: Technical Data Consultant - Data Architecture Discovery & DocumentationContract Type: £400 - 500/day Outside IR35

3 months (initial)Location: Hybrid - Manchester & Birchwood, Warrington (2 days/week onsite)Overview:A retail and gaming client needs an experienced consultant to reverse-engineer their Retail data landscape - spanning an on-premise SQL Server data warehouse and AWS estate - and convert undocumented, tribal knowledge into a sustainable, well-documented operating model.Core Responsibilities:Conduct independent deep-dive discovery and code reviews to map data flow from Retail systems into the data warehouseProduce high-level and granular architecture diagrams (cloud resources, ETL/ELT pipelines, third-party integrations)Author operational runbooks for troubleshooting, restart and maintenance of critical pipelinesAudit and document the SQL logic behind key retail metrics for reporting consistencyDesign a lightweight, maintainable documentation framework

Requirements

(Confluence/Markdown-based) for the teamWhat We’re Looking For:Proven experience reverse-engineering data systems with little or no existing documentationStrong hands-on experience with SQL Server and AWS Lakehouse architectureExpert-level ability to produce clear, structured architecture diagramsComfortable working independently, and skilled at engaging senior engineers who may be protective of their systems - positioning the work as empowering rather than replacing them