Reece Wall
Data Engineer · Azure · Databricks · SQL
Nottingham, UK · rcdwall@gmail.com · LinkedIn · reecewall.dev
Profile
Data Engineer with 5+ years in analytics and data engineering across the Boots UK supply chain, including 3+ years building and optimising ETL/ELT pipelines in Azure and Databricks. Hands-on with Databricks (PySpark / Spark SQL), Azure Data Factory and performant T-SQL, feeding a Synapse data warehouse that serves planning, forecasting and replenishment. A Mathematics graduate with a strong record of pipeline optimisation, data modelling at scale and reliable delivery on business-critical systems.
Experience
Systems Lead · Supply Chain Planning, Boots UK
Mar 2026 – Present- Led the data modelling behind major stock-policy and availability decisions, modelling ~20M item/store/site planogram records in performant SQL and Power BI to quantify the working-capital impact of 7 investment scenarios (£5–50m range) and inform a board-level capital-allocation decision.
- Own the stability and optimisation of core forecasting and replenishment data systems operating across the national store estate (18M item/store combinations).
- Lead triage and delivery of change requests, advising on system-related decisions and bridging business users and IT to turn system behaviour into actionable fixes.
Data Engineer · Supply Chain, Boots UK
Nov 2022 – Feb 2026- Built and remediated ETL/ELT pipelines in Azure Data Factory (simplifying logic, cutting load times and consolidating distinct pipelines) that loaded a Synapse data warehouse used across planning and replenishment.
- Engineered data transformations in Databricks using Python notebooks with PySpark and Spark SQL, refining raw ingested data into clean, warehouse-ready tables.
- Built automated monitoring and alerting that verifies expected files land in Azure Blob Storage on time, catching ingestion failures before they reached downstream reporting.
- Developed PowerShell tooling to map end-to-end data lineage from blob storage to warehouse target tables, accelerating root-cause analysis.
Data Analyst · Supply Chain Planning, Boots UK
Sep 2020 – Nov 2022- Built an outbound optimisation model that delivered c. 400,000 fewer warehouse pick operations per week during Peak 2021.
- Engineered a supplier-booking system (MS Access / VBA / Excel) used by the Seasonal and Online operations to manage inbound bookings into the Burton warehouse.
- Ran statistical analysis across 1B+ records in Azure Synapse using T-SQL window and partition functions, work that would otherwise have been computationally infeasible.
MI Administrator · Outbound, Boots UK
Dec 2018 – Sep 2020- Automated the majority of daily MI reporting, freeing c. 3 hours/day for project and improvement work.
- Built a reusable custom JSON parser in VBA and tooling to flag inefficient stock deliveries to site.
Earlier: Began in Outbound operations (2017–18), building a ground-level understanding of product flow and the end-to-end supply chain before moving into MI and analytics.
Skills
Cloud & Data Engineering
Languages
BI & Reporting
Tools & Practice
Education
BCS Level 5 Diploma, Data Engineering
The Chartered Institute for IT
2025
BCS Level 4 Diploma, Data Analytics
The Chartered Institute for IT
2022
BSc (Hons) Mathematics
University of Nottingham
2013–2016
Strengths
- Builds reliable, performant pipelines with optimisation and observability built in.
- Detail-driven, with a habit of challenging data that doesn't behave as expected.
- Translates complex system behaviour into clear decisions for technical and non-technical audiences.