The problem
Each country firm kept its financial performance data in its own files, in its own format. If anyone wanted to see how Europe was doing as a whole, someone had to pull it all together by hand, every single reporting cycle. It was slow, it was easy to get wrong, and there was no single place leaders could go for the full picture.
What I did
I owned the delivery end to end. In practice that meant three things running side by side:
- Agreeing what to measure. I worked with engagement leads and senior stakeholders to agree the metrics, the budget and the delivery plan before anything was built.
- Building the pipeline. I built automated workflows that pull in each country's data, reshape it into one consistent format and check it before it reaches anyone. That last step matters: if people can't trust the numbers, they won't use them.
- Running the team. We worked in sprints. I supervised junior analysts, ran technical reviews and kept stakeholders updated as each piece landed.
The result
One analytics product that gave the first continent-level view of operational performance across the member firms. The automation saved 4 days every reporting cycle, and the insights now feed into decisions about resourcing and where to expand services.
What I learned
The code was the easy part. The real work was getting people in different countries to agree on what the numbers mean. Once that was settled, building the product was straightforward.
Some details are kept general because the work is confidential.