Case study

BT AdviceWind-Down

Run the data stream of BT's advice wind-down, with 400k+ client records, more than a dozen source systems and a board-mandated deadline.

BT Financial Group · Data Product Owner · Data · Wealth · 2019

The problem.

BT's advice business was the product of decades of acquisitions. It was spread across several platforms, with client data all over the place. The wind-down needed one accurate record per client, pulled together from all of it. No client could be missed, and the sale depended on those records being right.

The board set the deadline and it wasn't moving, so scope and approach were the only things we could change.

The approach.

I ran it as a product rather than a data project. The customers were the downstream teams who would use the data, so we started with them, then wrote the spec, then built it.

  1. 1Mapped every source system that held part of a client's record, and the gaps between them.
  2. 2Designed reconciliation rules with the ops and compliance teams that would eventually rely on them.
  3. 3Delivered in small steps. We got one system mapping working all the way through, then added the rest, instead of waiting for a perfect schema.
  4. 4Fortnightly releases, with adviser feedback folded into the next sprint.
  5. 5Reported client data in SharePoint so the teams using it could review it.

“A data product has no screen to look at. You find out it's wrong when someone uses the numbers.”

The outcome.

We delivered a single source of truth by the board's deadline.

More than 400,000 clients ended up with reconciled records, which were used to transfer them to the acquirers so every client had somewhere to go.

What I learned.

Unglamorous products with a board deadline can be some of the highest-stakes work you'll do, and they deserve the same care as anything customer-facing.

The people who will use the data are the best people to review the spec, so get them in the room early.

Getting the data right early pays off. What we built would have been useful to the business for the previous ten years, instead of being thrown away at the end.

By the numbers

  • Scale

    400k+

    clients reconciled

  • Sources

    12+

    data systems integrated

  • Deadline

    Met

    Board-mandated date

  • Sector

    Advice

    ASIC-regulated

Next case study

Tribe Bikes All work

Open to a chat.

Based in Newcastle and Sydney, Australia. The fastest way to reach me is a LinkedIn message.

Ventures: tribebikes.com.au and sirenfooty.com.au