top of page
Organisational Change
Single Data Asset

Case Studies

Developing a Single Data Asset for Broker Business at Aviva

General Insurance

Aviva underwrites c £3bn in premiums through Brokers. An opportunity was identified to enhance performance reporting by streamlining multiple data sources. By consolidating these sources, Aviva aimed to create a more consistent, efficient, and aligned approach across Sales, Distribution, and Finance teams, benefiting over 1,500 employees.

Key Opportunities

1

Enhanced efficiency by reducing time spent on data preparation, allowing teams to focus on performance analysis

3

Streamlined data processes, minimising manual effort and accelerating insights

2

Improved data reliability, fostering trust and reducing the need for alternative sources

4

Greater clarity in decision making through a unified approach to data interpretation 

To drive these improvements, Aviva launched a strategic project to develop a single, trusted data asset—enabling real-time insights, faster decision-making, and enhanced data governance.

Data Transformation
  • 1. Understanding the Opportunity: The Audit
    A dedicated project team was formed to conduct an in-depth review of closed claims, with support from the Data Insight team. A statistically valid sample of 1,200 claims was analysed to determine the extent of missed recoveries. The findings were remarkable: High-propensity claims for recovery were identified, including: Escape of water Fire Third-party property damage The audit findings supported a business case estimating an annual recovery opportunity of £4m, requiring an initial investment of £250,000. With leadership approval secured, the next step was to build the right processes and teams to capitalize on this opportunity.
  • 2. Leveraging Data Mining for Recovery Identification
    Since there were no system flags to identify recoverable claims at notification, a data-driven approach was developed. A data mining program was built with support from data specialists, using machine learning to scan claim files for key indicators of subrogation potential. A data dictionary was developed and refined monthly over a six-month period to improve accuracy and capture new claim patterns. This program was used to triage recovery opportunities within 24 hours of notification, significantly reducing manual workload. To create an immediate pipeline of cases for the recovery team, the data mining tool was run across historical claims, uncovering £1 million in recoverable losses.
  • 3. Building a High-Performing Recovery Team
    To execute on recoveries, RSA needed skilled specialists who could manage legal negotiations and settlements. A partnership was formed with one of RSA’s preferred legal firms to recruit newly qualified law graduates eager to gain corporate legal experience. Graduates received specialised training from RSA’s panel law firm, equipping them with the skills to manage subrogation claims. The team scaled quickly from 6 to 20 members within a year, benefiting from the legal firm's talent pipeline. Retention was high as the role provided valuable legal experience and a pathway to potential training contracts.
  • 4. Engaging Operational Teams & Claims Handlers
    To ensure long-term success, it was critical to secure buy-in from frontline claims handlers and field-based loss adjusters. Detailed communication plans were rolled out to explain how accurate claim data would directly improve recoveries, reinforcing the importance of quality information capture. Project team members attended operational team meetings to share updates, celebrate early wins, and address concerns about role devaluation. Live audits by team managers helped monitor missed opportunities and drive continuous improvement. Loss adjusters embraced the initiative, seeing it as an opportunity to showcase their value by securing evidence that would strengthen recovery claims.

From Data Transformation to Team Excellence

Results & Impact

1 day per month saved on report production, freeing up time for analysis and decision-making

​

A simplified data model driving efficiencies across teams

​

One version of the truth enabling teams to confidently assess broker performance and shape growth strategies

​

Improved data governance through automated reconciliation at multiple points in the data pipeline

​

Senior stakeholders welcomed the increased data granularity and enhanced reporting accuracy

Lessons Learned & Future Improvements
  • Early Team Identification: Ensuring all project team members are engaged from day one is essential.

​

  • Embracing a Non-Green RAG Status: A non-green status isn’t a failure - it creates focus, urgency, and ensures key issues receive attention.

​

  • Valuing People: Recognising team strengths, saying thank you, and understanding personal circumstances create a stronger, more resilient team.

Conclusion

By fostering a culture of teamwork, structured communication, and proactive stakeholder engagement, Aviva successfully delivered a transformational data asset - laying the foundation for long-term broker business growth.

 

Struggling with disconnected data, inefficient reporting or stakeholder misalignment. Building a single source of the truth requires more than just technology - it demands strong teamwork, communication and strategic alignment.

Data Preparation
Aviva
"Phil played a key role in the transformation of a key data asset for General Insurance. Coming into the project mid-way through the project lifecycle, he reshaped project scope securing funding and senior stakeholder approval for 2024-2025 implementation. Strategic thinking and an attention to detail enabled successful deployment across sensitive financial reporting periods.

Phil’s outstanding communication, a proactive approach and problem solving skills were crucial in turning the project around."


-Dan B, Head of Finance SME & Distribution
Streamlined Data Processes
Business Operation Optimisation

Get Started

Let’s discuss how we can optimise your business operations.

bottom of page