How Delta Capita assisted a Global Investment Bank in improving their Data Lineage process

Data lineage (DL) refers to process of tracking data from its source to its destination, including all transformations and database merges along the way. A lack of effective and efficient DL processes invokes issues for our banking clients such as:

·  Lack of transparency of end-to-end data flows

·  Poor traceability of data from the trusted ‘Golden Source’

·  Decreased auditability

Fortunately, these problems are remediable through the correct implementation of data lineage tools, automation, and expertise. An effective DL programme yields a comprehensive view of data flows that encompass the systems, processes and the people involved and enables:

·  Better data accuracy and completeness,

·  Regulatory compliance,

·  Transparency of data relationships, and

·  Flagging potential risks

Delta Capita were recently approached by one of our Global Investment Banking clients to lead a robust and efficient data governance and lineage programme. The client required a clear and comprehensive overview of their account data to ensure good data quality and regulatory compliance.

‍

How did we do it?

The first step we took was to organise the Bank’s data into a Data Dictionary that would host critical data elements (CDEs); these CDEs were categorised into:

With defined CDEs at its core, the programme delivered under 3 key workstreams:

‍

1 - Data Quality Management

Rules for measuring data completeness, conformity, uniqueness, and accuracy were built using Alteryx. DQ deliverables were targeted alongside data lineage once a system of record (SOR) or ‘Golden Source’ of data was established.

‍

2 - Data Lineage Tooling

Our team leveraged their expertise in Solidatus to provide a roadmap for the data, incorporate service-level agreements (SLAs), perform regular ‘data health’ checks, and visualise data using interactive dashboards.

‍

3 - Data Source Mapping

Once the SOR was established, the team could begin to map where data had come from, assess upstream and downstream users, and identify any additional touch points. We also documented the linkage for CDEs across the relevant lines of business (LOBs) to establish clear relationships.

‍

What were the benefits for the client?

How Delta Capita are preparing for the future

Data lineage practices will continue to be influenced heavily by BCBS 239 (the Basel Committee on Banking Supervision’s Standard #239), which ensures G-SIBs’ risk data aggregation capabilities and internal risk reporting practices yield adequate insight into the risks to which they are exposed. BCBS 239 has recently been expanded to include smaller banks and hence regulatory compliance pressures will rise. This provides an opportunity to introduce into their ecosystems solutions which lead to:

·   Increased interoperability (a necessity as DL becomes required to cooperate with data warehousing, cataloguing, and visualisation tools)

·   Transparency of data traceability

·   Data automation

Our experience and ever-growing capacity to deliver Data Lineage improvements place us well to support your implementation of effective data lineage solutions. We also offer a further suite of Data Analytics and Data Visualisation solutions to enhance reporting on Data Traceability to regulators. To learn more about our service offerings, contact us today.

‍

‍

‍