A client’s finance and operations leaders had stopped fully trusting their own reports. The numbers were assembled by hand each month, pulled from systems that did not quite agree, reconciled in spreadsheets that only one or two people understood. Decisions were being made a week later than they should have been because nobody wanted to act on a figure they were not sure of. The team wanted a proper analytics and reporting layer, but had no one in-house with the time or the specific experience to build it.
This was not a job for a tool bought off a shelf and left to the business to figure out. It needed someone who could get to data that could be relied on, then build reporting on top of it that the team could maintain without him.
The challenges we had to solve
- The underlying data was spread across systems that recorded the same things differently.
- The existing reporting depended on a couple of people and the steps in their heads.
- The team needed reports it believed, not just reports that looked finished.
- Whatever was built had to outlast the engagement and be run by the in-house team.
How we approached it
We embedded one data engineer who had built reporting layers that survive contact with a real finance close. The first work was the unglamorous part — getting the source data clean and connected enough to rely on — because reports are only believed once the figures behind them add up. They sat with the finance team, learned how the numbers were actually used, and were accountable to the team lead for getting it right rather than for delivering a dashboard nobody had asked for.
Throughout, the engineer worked so that the team could take it over: documenting the pipelines, explaining the logic, and building on tooling the client could support. The same data groundwork now feeds more than one report, so the effort was not narrow. When the engagement wound down, the capability stayed where it was needed.
Where it stands
The monthly numbers now come together without the manual assembly that used to delay them, and the people who depend on them have stopped second-guessing the figures. The reporting no longer rests on a single person’s memory. The in-house team runs and extends what was built, which is the outcome the engagement was there to produce.