Compliance Audit - Automated Data Validation & Monitoring
One of UK's largest pension funds, £34 billion AUM
1The Background
RPMI Railpen is one of the UK's largest and longest established pension funds. Their source data used a custom developed data quality and testing solution in preparation for downstream data management analytical processes. Business analysts managed data quality control (DQC) by running queries on data sources, feeding data to Tableau dashboards, and using custom tools to verify the data.
2The Challenge
The manual process directly impacted the team's productivity and consumed an estimated 50% of the business analyst's time. Along with costing valuable time, the manual approach exposed risks in compliance, credibility, and financial audit. A comprehensive solution was needed to feed accurate data to Tableau dashboards while ensuring compliance and financial governance.
Technical Environment
- Custom-developed data quality tools
- Tableau dashboards for reporting
- Multiple source data systems
- Downstream analytical processes
3The Solution
RPMI trusted RightData to automate their financial data reconciliation and validation processes. The proactive identification and alerting process, along with detailed validation exceptions reports, reduced time to resolve data quality issues. The platform provides automated data reconciliation without requiring programming.
The RightData Edge
The DataTrust suite of tools allows Railpen to work forwards with proactive quality processes and business rules, as well as backwards for important audit. Using the flexible DataTrust platform, along with the expertise of RightData support, has allowed Railpen to continually improve both the process and the data quality across the enterprise.
4The Results

Quick Facts
Company
RPMI Railpen
Industry
Financial Services - Pensions
Company Size
One of UK's largest pension funds, £34 billion AUM
Published
June 22, 2022
Categories
