Back to Use Cases
RPMI Railpen
Financial Services - Pensions
June 22, 2022

Compliance Audit - Automated Data Validation & Monitoring

One of UK's largest pension funds, £34 billion AUM

Financial Services
Compliance
Audit
Pensions
Data Validation

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.

Automated financial data reconciliation and validation
Implemented proactive identification and alerting
Created detailed validation exception reports
Replaced manual inspection with automated processes
Integrated with Tableau dashboards for accurate reporting

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

Achieved 100% data accuracy with no programming needed
Recovered 50% of analyst time previously spent on manual validation
Enabled confident attestation to data quality for audits
Ensured timely and accurate Tableau dashboard reporting
Mitigated risk across the entire enterprise data flow
Compliance Audit - Automated Data Validation & Monitoring

Want similar results?

See how RightData can help your organization achieve trusted data and better business outcomes.

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

Financial Services
Compliance
Audit
Pensions
Data Validation

Ready to Transform Your Data?

See how RightData can help your organization achieve similar results