Euroclear reduces duplicate data spending

A key part of maximizing the value and utility of their data would be to minimize or eliminate data duplication.

The team recognized that not all duplication is necessarily bad. “Duplication is often necessary for business continuity and business resilience. It can be necessary for regulatory compliance,” said Pierre, “But if its necessity cannot be confirmed, it should be eliminated. Unnecessary duplication results in expensive and avoidable reconciliation efforts down the line.”

First, Euroclear teams tried to quantify (and in some cases estimate) the cost of data, “Direct vs. indirect, variable vs. fixed, OpEx vs. CapEx. Covering the cost of infrastructure, data centers, storage, compute network, the cost of platforms, databases, middleware, mainframe. The cost of data vendors, facilities, business processes.” It was a huge and complex task, as for a lot of these costs no solid reporting or hard figures were readily available, short cuts and estimates had to complement available information.

Beneath all that, Euroclear teams identified inefficient business processes as the big cost multiplier. “Wasted time to find, understand, extract, reconcile, clean data. The cost of wasted time handling data is the largest single item in the cost of our data in our company. And that cost is driven notably by duplicate data and duplicate data usage.”

To begin the process of duplicate data elimination, they turned first to the two million rows of data in their securities database.

“We clarified master sources, starting with key data. We made that information transparently available to all employees,” said Pierre, “That made it possible for current and future data consumers to know in a faster and easier way what exists, what it means, where it is.”

It creates the conditions for a reduction in duplication which can lead to a decrease in the time wasted in reconciliation efforts. It also simplified the understanding of subject matter experts regarding the securities database contents. This streamlining of data definitions increased the value of the data as a business asset.

Pierre and his team continue to identify the key data relevant to Euroclear’s core processes. Using Collibra to catalog this data, they expand the scope to include support functions (such as HR, Finance and Compliance) and very importantly sales and product development teams. They are currently implementing the data sharing agreements that make the elimination of duplicate data possible.

This exercise is providing the insight into Euroclear’s data environment that will allow them to streamline their data, eliminate duplicate data and reduce the duplication of reports and other data output.

A great deal of hard work goes into such a large-scale data transformation. The effort requires strong policies and processes, training, coaching, monitoring and support. “For instance, the standard rules to name and define business terms or using one single central tool, like Collibra to document and share data traceabilities.”

But data modernization also needs to focus on the people, not just the technology. “A good data transformation must take into account the change of values and culture, the new mindsets, the new behaviors, the new communities,” said Pierre, “As we started to roll out Collibra in production one year ago, we have kept an eye on user adoption and employee awareness. And today, one year later, between 5 to 10% of the staff are already active users. This is only a start, of course.”

Pierre and his team at Euroclear regard the benefits from their data transformation as the new “business as usual” way of working and are embedding that mindset throughout their whole company.

“It is something that will quietly revolutionize the way the company operates across divisions and entities.”