The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

Data Management Summit: Keynote Questions the Use of Sticks or Carrots in Data Architecture

Putting data architecture before data management, Colin Gibson, head of data architecture in the markets division of Royal Bank of Scotland, presented the opening keynote at this week’s A-Team Group Data Management Summit in London. As well as a deep dive into data architecture, the summit considered the role of the chief data officer, drivers of data management, the problems it presents and some cultural and technology solutions.

Gibson titled his keynote ‘Data Architecture – Sticks or Carrots?’, and set out to describe how to build a successful and sustainable data architecture that will be used and updated consistently across an organisation. He noted a blueprint and vision of the end creation as a starting point, with the blueprint taking into account issues such as what the business needs and how it will be delivered in terms of data sources, storage, access, movement and management. Added to the blueprint are disciplines, such as data policies, rules and standards, governance, best practice, modelling and tools. Put together, the blueprint and disciplines allow maintenance of underlying data in an organisation.

Gibson explained: “For data management to be successful, it must follow the disciplines, but also keep updating the blueprint. This will maximise the effectiveness, efficiency, control and agility of the business.”

By using the blueprint to maintain underlying conceptual order in data, Gibson said it is possible to eliminate data inconsistencies, errors and confusion; improve the ability to combine data produced by different business departments; respond faster to change; rely less on subject matter experts; improve knowledge sharing; and improve the quality of business analysis for activities such as investment.

Demonstrating the economic benefits of a blueprint and disciplines, Gibson said: “Every £1 spent on documenting data architecture saves £5 on subsequent projects in similar areas; every £1 spent getting things right first time avoids £3 of remediation; every £1 spent creating a centralised source of reference data saves £20 on future investment and proves an 80% saving in running costs; and every £1 spent avoiding data replication saves £1 in data reconciliation.”

The bottom line impact of this approach is data quality, business agility, timely project management and better risk management. Gibson acknowledged that if this is the theory, live projects have deadlines and problems, but he advocated against a short-term project focus, saying that not doing things properly first time around stores up trouble for the future.

Detailing how to achieve sustainable benefits from data architecture, Gibson said: “The challenge for data architects is to plant seeds that will lead to success. The person planting the seeds will not reap the benefits, but both work for the same farmer, who says they must get things right.” Rather than a traditional approach to data architecture that uses a proverbial stick when people do not get things right, Gibson proposes a more positive approach that uses a carrot to encourage people to do the right thing.

Noting reference data as the livelihood of Royal Bank of Scotland, he described GoldRush, the bank’s central source of reference data. “The bank understands its sources of reference data, but there is a problem when other organisations in the group do their own thing. We heard it was too difficult to take data from our golden sources, so we suggested and built a library of elements such as feed handlers, messaging tools and default database schemas that can be used in any project. This has been very successful with 80 projects having used the library.”

Gibson cited Project Samurai, a project driven by regulation in Japan, as a great example of a small development team that tapped into the bank’s knowledge, saw that similar work had been done before, used a schema from the library and fed information back into the blueprint to deliver a perfectly documented project. He commented: “With the foundations already built, the team could focus on solving business requirements.”

Looking forward, Gibson said he is considering how business analysts could use the blueprint, how the bank could automate transformations and whether metadata could be used to automate reconciliations.

Related content

WEBINAR

Recorded Webinar: Best practice solutions for client lifecycle management

This webinar has passed, but you can view the recording by registering here. The challenges of client lifecycle management continue to increase, driven by regulation and requiring financial institutions to review processes around client onboarding, Know Your Customer (KYC) and client data maintenance. The webinar will outline the challenges faced by financial institutions, discuss best...

BLOG

Alveo Integrates ULTUMUS Index and ETF Managed Data Service with Prime

Alveo and ULTUMUS, an exchange-traded fund (ETF) specialist, have partnered to bring together Alveo’s data mastering solution, Prime, and ULTUMUS’s global ETF and index managed data service. The partnership aims to enable Alveo customers to integrate index and ETF information more quickly, and allow ULTUMUS’s clients to enhance their data mastering and data integration capabilities....

EVENT

Data Management Summit Europe Virtual (Redirected)

The Data Management Summit Europe Virtual brings together the European data management community to explore the latest challenges, opportunities and data innovations facing sell side and buy side financial institutions.

GUIDE

Trading Regulations Handbook 2021

In these unprecedented times, a carefully crafted trading infrastructure is crucial for capital markets participants. Yet, the impact of trading regulations on infrastructure can be difficult to manage. The Trading Regulations Handbook 2021 can help. It provides all the essentials you need to know about regulations impacting trading operations, data and technology. A-Team Group’s Trading...