About a-team Marketing Services
The knowledge platform for the financial technology industry
The knowledge platform for the financial technology industry

A-Team Insight Blogs

Tackling the TRIM Challenge – How Banks Can Get their Data Quality Processes up to Scratch

Subscribe to our newsletter

By Martijn Groot, Vice President of Product Management, Asset Control

The Targeted Review of Internal Models (TRIM) is underway and significantly impacting banks across the eurozone. TRIM is an initiative of the European Central Bank (ECB), designed to assess whether the internal risk assessment models used by banks supervised by the ECB, comply with regulatory requirements and whether their results are reliable and comparable.

As part of the programme, the ECB is engaged in a process of reviewing the banks’ models, providing them with ‘homework’ to improve their processes, and then returning to inspect again. In carrying out this process, however, the ECB understands that detailed discussions with the banks about their risk assessment models will be of little value if they can’t trust the data that is fed into them.

Data Quality Principles

TRIM can be said to build on the results of the Basel Committee for Banking Supervision’s BCBS 239 document, published in 2013. While BCBS 239 laid out 14 principles for risk data aggregation for banks to abide by, it was quite generic in nature. TRIM is more specific, especially around data quality aspects and measurements.

In fact, TRIM provides a range of governance principles for developing a data quality framework that covers relevant data quality dimensions including completeness, timeliness, accuracy, consistency and traceability.

To comply with TRIM, banks need to show that they can trace back the price they have used historically for a model or for a financial instrument valuation through the data supply chain back to original sources. They also need to know what processes have been carried out on the data, including checks that have been conducted, what the sources are, what the original parameters and data quality rules were, and whether they have been changed over time? Traceability is the term used to describe this in the TRIM document but data lineage, effectively the data lifecycle that includes the data’s origins and where it moves over time, is the broader term more widely used in the data management arena.

The TRIM document also contains important reporting guidelines – including that banks will need to report on how often they have proxied their market data inputs or risk calculations. Doing this also defines a process for how a bank has derived and validated this proxy. Is it really a comparable instrument? Does it behave similarly to the original instrument?

In other words, in line with the focus on data quality in TRIM, it is important that banks are regularly validating their proxies. Finally, and to ensure they have a better grasp of the quality of the market data they use in risk calculations, banks need to have a handle on how much data is stale per asset class.

Today, most banks would typically struggle to comply with many of the data quality guidelines that TRIM puts in place. Most have no data quality or control frameworks in place or, at best, assess quality in different isolated silos. As such, they don’t have the ability to report daily on key data and metrics. They may have implemented checks and controls, but generally they have little real insight into data across the whole chain. Very few have a full audit trail in place that describes how data flows from sources through quality checks and workflows into the financial models, and that tracks not just data values, but also the rules and the rule parameters that have acted on the data.

Finding a Way Forward

So, how can banks effectively meet the TRIM guidelines? Banks first need to get the basic processes right. That means putting a robust data governance and data quality framework in place. To do that, they need to document their data management principles and policies. They also need to agree on a common data dictionary and understand more clearly exactly what they are measuring, including how they define financial products across the group and the control model for the whole lifecycle.

The next stage is putting in place the technology that enables banks to achieve this. Organisations first need a data management system that has the end-to-end capability to gather, integrate and master key data, derive risk factors and publish them to different groups. This should provide banks with a single funnel and consistent set of data and data quality metrics that support TRIM compliance.

It is worth highlighting, too, that there are benefits on offer for banks that go beyond simply complying with TRIM – important though that is. Some of the remediation that they will have to do to comply will also be required for key regulations, including the Fundamental Review of the Trading Book (FRTB). However, for many, TRIM is their current focus and with the programme expected to run to 2020 only, banks know there is still much work to do to meet its guidelines.

Subscribe to our newsletter

Related content


Recorded Webinar: The time is now for buy-side firms to re-evaluate their approach to data management

Increased cost pressures, rising volumes of data, and the challenges of legacy systems are pushing buy-side firms to re-evaluate current approaches to data management. The aim is cost-effective, optimised data management that can provide flexibility and scalability, support various data types including ESG data, and ensure headroom for development in line with business objectives. Achieving...


M&G Investments Selects Bloomberg as Sanctions Data Provider

M&G Investments has selected Bloomberg as its sanctions data provider to support compliance decision-making, as well as portfolio and risk management. The deal extends Bloomberg’s relationship with M&G Investments, which previously adopted all the services offered by Bloomberg Data Management Services. Using Bloomberg’s sanctions data solution, M&G Investments will have access to the data vendor’s...


A-Team Innovation Briefing: Innovation in Cloud

This Innovation Briefing will explore approaches to data infrastructure transformation, technologies required and how to make sure processes are optimised to support real time data management. Hear from leading practitioners and innovative technology solution providers who will share insight into how to set up and leverage your data infrastructure to provide user access to consistent data and analytics, and companies the ability to monetise their data.


Regulatory Data Handbook 2022/2023 – Tenth Edition

Welcome to the tenth edition of A-Team Group’s Regulatory Data Handbook, a publication that has tracked new regulations, amendments, implementation and data management requirements as regulatory change has impacted global capital markets participants over the past 10 years. This edition of the handbook includes new regulations and highlights some of the major regulatory interventions challenging...