The delay was a data problem, not a design problem
A five-person specialist team carried the entire restructure workload for the agency. Their tools were Excel and Visio, and every restructure began with the same sequence:
- Pull the data. A report was extracted manually from SAP SuccessFactors through the Admin Centre in Employee Central.
- Clean it up. Find-and-replace passes stripped the data, and a custom formula worked out who was acting versus who substantively owned a role, alongside manual changes to several other fields.
- Build the chart. The spreadsheet was imported into Visio, producing dozens of unlinked pages that had to be dragged together and restyled by hand.
- Mark up the changes. Every change was colour-coded manually, page by page. There was no way to apply formatting across the whole chart.
- Deliver the pack. By the time it reached consultation, the data was already out of date.
The consequences went beyond a slow turnaround.
In the words of the agency’s Head of Remuneration and Organisation Design: “A team of just five was carrying the entire restructure workload for a 15,000-person organisation, split across two disconnected tools, with all the reconciliation risk that creates.”
Their expertise went into data handling instead of the job they were hired to do: designing and delivering optimized, sustainable structures. Slow delivery was the visible symptom. The deeper cost was what the team could not do while they were busy reconciling spreadsheets.