Haystack
← Back to Jobs
Technology

Senior Data Engineer — Data Architecture Discovery & Documentation

Impellam Groupmanchester area, united kingdom🇬🇧United KingdomPosted 2 Aug 2026

Why This Role Stands Out

This role offers a unique opportunity to build foundational data architecture documentation for a major client, significantly impacting their operational efficiency and future growth. You'll thrive here if you're an experienced data professional with a knack for reverse-engineering complex systems and translating tribal knowledge into clear, actionable documentation, leveraging your SQL Server and AWS expertise. Take advantage of this engaging contract role with competitive daily rates and the flexibility of a hybrid work model.

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

Role: Technical Data Consultant — Data Architecture Discovery & Documentation

Contract 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 warehouse
  • Produce high-level and granular architecture diagrams (cloud resources, ETL/ELT pipelines, third-party integrations)
  • Author operational runbooks for troubleshooting, restart and maintenance of critical pipelines
  • Audit and document the SQL logic behind key retail metrics for reporting consistency
  • Design a lightweight, maintainable documentation framework (Confluence/Markdown-based) for the team

What We're Looking For:

  • Proven experience reverse-engineering data systems with little or no existing documentation
  • Strong hands-on experience with SQL Server and AWS Lakehouse architecture
  • Expert-level ability to produce clear, structured architecture diagrams
  • Comfortable working independently, and skilled at engaging senior engineers who may be protective of their systems — positioning the work as empowering rather than replacing them

Skills

SQL
SQL Server
AWS
ETL
Confluence

Similar jobs