Data quality is a key factor for the sound and controlled operation of pension funds. It enables pension funds to give participants what they are entitled to.
The transition to the Future Pensions Act (WTP) puts even more emphasis on data quality in pension administration. According to the Decree on the Future of Pensions, pension funds must demonstrate that data quality is secured before the transition to the new pension system can take place. This is important for making a balanced entry decision and for the correct conversion of pension entitlements to capital (‘claw-in’).
The Data Quality Framework – Future Pensions Act (hereafter Framework) provides pension funds with tools to make the quality of data transparent, substantiate it, make corrections (‘get clean’) and ensure it (‘stay clean’). In this article, we discuss the challenges posed by the Framework and the tools to meet these challenges.
The Framework, published by the Pension Federation, consists of six phases:
Pension funds have already invested a lot in recent years to improve data quality. The good news is that pension funds do not have to start from ‘scratch’. However, the Framework does bring some key challenges.
Implementing the six phases requires a lot of capacity from the pension fund and pension administration organisations. This is, for instance, in collecting the activities carried out so far and using them in the Framework. In-depth analysis and documentation of data quality is required, with an average of more than 60 critical data elements to be assessed. The pension fund also needs to conduct data analysis (from data profiling to partial observations), which is mostly carried out by the PUO. Given PUOs often do this for multiple pension funds, this can lead to peak load and limited availability of data analysts.
To meet these challenges, early preparation is essential. If pension funds start preparing for data quality work early, you avoid peak workloads and project overruns. In addition, close cooperation between implementers, auditors and IT auditors ensures that the complexity and risks of the process remain manageable.
IT and data go hand in hand. To analyse data, it is advisable to use advanced data analysis techniques and AI (machine learning, data science). The risk of IT projects running out of time for pension administration organisations and self-administered funds seems significant, recent research shows. More than 70% of respondents expect that the majority of front-runners will not switch on 1 January 2025, mainly due to implementation and IT-related obstacles. This will also affect the turnaround time and completion of the Framework.
Pension funds can address challenges in IT processes by investing in advanced and proven technologies. In addition, thorough planning, collaboration with experienced IT partners, continuous monitoring and flexibility and agility are required. Going through the Framework should not be seen as a stand-alone component, but be managed integrally from project and portfolio management.
Many pension funds have a long history; some funds even have a data history going back more than 70 years. The method of data storage was significantly different back then, and often not all historical information has been preserved. This raises the question: how far back should a pension fund look to get a clear picture of the quality of their data?
All in all, a considerable challenge for pension funds, at a time when the current pension administration needs to be run and the new pension scheme is being set up in parallel.
Pension funds are not starting from scratch, but going through the Data Quality Framework does represent a significant challenge for pension funds.
Pension funds should substantiate to which year the data is traceable. In other words, up to when is the data comparable to the initial source. For data with limited traceability, we recommend carrying out plausibility analyses to understand the ‘credibility’ of the data. If certain data is no longer retrievable, a pension fund should perform a risk analysis on the impact of the missing data to demonstrate that the risk of the unavailable data is within the pension fund’s risk appetite.
We also recommend determining the time horizon based on the available data and previous analyses performed by the pension fund. Take, for example, a pension fund that has moved to a new pension administration organisation (PUO) and has conducted data research in that context. If this research shows that data up to a specific year has already been analysed, consideration may be given to not including this period within the scope of the Framework.
The listed challenges are obviously not an exhaustive list. What is central, however, is that timely preparation, intensive cooperation, and direction are key to successful implementation of the Framework. We would be happy to have a cup of coffee with you to exchange views on this.