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

Upcoming Webinar: Strategies, technologies and services for successful corporate actions automation

Date: 15 September 2021 Time: 10:00am ET / 3:00pm London / 4:00pm CET Duration: 50 minutes Rising volumes and increasing complexity of corporate actions are challenging market participants’ efforts to reconcile data, automate corporate actions processing, and contain costs. The culprits causing these challenges include legacy systems, missing skills, manual processes, data quality issues, and...

BLOG

Reformis Adds Matrix IDM and NeoXam to Vendor Partner Programme

Reformis, a buy-side business transformation consultancy, continues to build out its vendor partnership programme with the addition of Matrix IDM’s cloud native data management software, and NeoXam’s Impress reporting solution. These join the company’s list of existing partners and products including IHS Markit’s EDM software, Snowflake’s cloud data platform, and Compliance Solution Strategies’ Accudelta product....

EVENT

TradingTech Summit Virtual

TradingTech Summit (TTS) Virtual will look at how trading technology operations can capitalise on recent disruption and leverage technology to find efficiencies in the new normal environment. The crisis has highlighted that the future is digital and cloud based, and the ability to innovate faster and at scale has become critical. As we move into recovery and ‘business as usual’, what changes and technology innovations should the industry adopt to simplify operations and to support speed, agility and flexibility in trading operations.

GUIDE

BCBS 239 Data Management Handbook

Our 2015/2016 edition of the BCBS 239 Data Management Handbook has arrived! Printed copies went like hotcakes at our Data Management Summit in New York but you can download your own copy here and get access to detailed information on the  principles and implications of BCBS 239 on Data Management. This Handbook provides an at-a-glance...