How to Futureproof Data and Analytics Capabilities for Reinsurers
Now more than ever, the reinsurance industry needs insight. But it is still slow to implement advanced data and analytics.
Key Takeaways
-
Most reinsurers are 'spreadsheet nations,' lacking a defined strategy to deliver business results through analytics
-
Investing in data and analytics enables reinsurer outperformance through superior risk selection and portfolio optimisation
-
Developing a data and analytics strategy and roadmap are key to maximising the impact of investment
As reinsurers reassess their appetite in light of climate change, cat losses, inflation and other market shocks, they seek to make better-informed decisions that will help them develop cedent relationships, optimize their capital and drive superior returns.
The reinsurance industry needs data-driven insight more than ever, but it is still slow to implement advanced data and analytics (D&A). Time-consuming data-cleansing and out-of-date, generic management information is a reality for most reinsurers.
A recent study of reinsurer data and analytics conducted by Aon’s Strategy and Technology Group found that most reinsurers are not realizing the potential benefits from the available data in submissions and third-party sources — concerning, for example, granular bordereaux reports. Many are still operating as “spreadsheet nations” with a heavy reliance upon Excel to support their pricing, reserving and capital modelling processes.
Reinsurers with more advanced D&A outperform the market by making better risk selection and portfolio management decisions at pace.
Looking to the future, reinsurer value propositions will expand beyond pure risk-transfer. Best-in-class reinsurers leverage technology to underpin robust analytics capabilities, offering cedents valuable insights in return for loyalty and better commercial relationships with the ceding insurers.
Understanding the Reinsurer Data and Analytics Landscape
Significant Opportunity for Improvement
Table 1
Aon's Strategy and Technology Group analysis.
67%
Companies that experienced between 21 and more than 40 insider incidents in 2022.
Source: 2022 Cost of Insider Threats Global Report | Ponemon
A few companies in the market have started to move ahead of the pack through investing in targeted areas such as pricing systems or advanced analytics capabilities. Those reinsurers classified as “Best in Class” and “Average” by Aon’s Strategy and Technology Group make a "build-or-buy" decision either to develop proprietary pricing systems or license tools available in the market. Additionally, “Best in Class” reinsurers have invested heavily in building large, dedicated D&A teams which not only serve their own businesses but generate income through developing and selling D&A solutions to others.
D&A Flow: Visualizing the Movement of Data
We have characterized how data moves between cedents, brokers and reinsurers as a 10-stage flow. There are significant inefficiencies across the flow with rekeying of data a major “time sink”.
Table 2
Aon's Strategy and Technology Group analysis.
44%
Increase in insider threats over last two years.
Source: 2022 Cost of Insider Threats Global Report | Ponemon
Deep Dive on 3 Areas of Data and Analytics
1. Data Ingestion: Optimizing Data Flows at the Source
One Insurtech executive has estimated that, alarmingly, some underwriters and actuaries can spend more than two-thirds of their time doing basic transformation and cleansing before they can use the data to make decisions. Differing standards in terms of the format, quantity, and quality of data in cedent submissions mean that vast amounts of manual work are required to bring the data into systems.
Additionally, much of the data is either “lost” and unusable, stuck on PDFs or huge spreadsheets with no efficient process to consolidate it into data systems. This leads to inconsistencies across the business, as individual teams use the raw data differently for their own processes — cleansing and standardizing the same data multiple times. The ability to capture and structure data accurately and efficiently at source will not only direct time that would otherwise be wasted towards value-add activities, but it is a pre-requisite for more advanced analytics. Best-in-class reinsurers invest significantly in developing a strong data culture, processes and partnerships to maximize the quality and scope of their data capture.
2. Systems and Methods: Integrating Systems for Effective Underwriting
Multiple disconnected systems are the norm across reinsurers. Often resulting from rapid growth or acquisition, these inefficient and cumbersome systems mean that data is typically scattered across the business. Individual teams create their own tools in Excel to store and analyze data which they then need to manually update. A lack of co-ordination between these teams gives rise to inefficiencies and inconsistencies across the business in addition to the risk that, without a central data repository and central control, the knowledge is lost when key personnel leave the company.
For reinsurers, there are two options for having an integrated pricing system: build or buy. Only the very largest reinsurers have the budget and scale of developer teams to build and maintain a pricing system in-house. For most reinsurers, the right option is to license integrated pricing systems off-the-shelf.
3. Advanced Analytics: Leveraging Data to Improve Risk Understanding
Once an efficient ingestion method and central system has been established with more granular data at their fingertips, reinsurers can conduct more sophisticated analyses to enhance their decision making. This includes sensitivity testing of parameters, portfolio optimization or marginal impact analysis on treaty deals. Most reinsurers can only perform a basic version of these portfolio analyses at a high level, months after a renewal period has concluded.
Sourcing and integrating third-party data — such as for example industry-specific inflation data — can also enrich the underwriter’s knowledge to enhance risk selection and better manage market cycles. Most reinsurers take a view on the current trends in the market to build into their view of risk via ad-hoc research projects. However, digitizing and centralizing analysis of market indicators using third-party data sources (both publicly available and licensed) would allow reinsurers to take a proactive approach to market cycle trends. This would enable reinsurers who do this effectively to react faster than their peers to market movements.
The Way Forward: Developing the Solution
1. Characteristics of a Best-In-Class Integrated Technology Solution
A best-in-class reinsurer will have multiple systems, typically licensed from the vendor market, and developed in-house. The architecture and selection of systems will vary, depending on the profile of the business they write and their in-house capabilities but will exhibit the following characteristics:
- There will be a configurable workflow to guide users efficiently through the underwriting process
- It will be supported through role-based access that is configured to in-house permissions
- Systems will be integrated, ensuring seamless data flow with no double-keying
- Data is stored securely in a schema that collects data consistently and comprehensively
- There will be flexibility to scale up or down the infrastructure to cope with peaks and troughs of usage, which is typically achieved using cloud computing
Reinsurers that have invested in improving their technology solution can take the next step in driving greater efficiencies and further automate their processes:
- Automated data-cleansing and formatting leveraging robotics
- Intelligent role-based workflows
- Automated documentation generation
- System integration, internal and external systems (e.g. connect to databases for sanctions checking)
- Automated data upload
- Dashboards and reporting layer build upon databases to analyze the portfolio, perform benchmarking etc.
2. Why invest in D&A as a reinsurer?
Developing best-in-class D&A requires investment. This will pay dividends for a reinsurer across four key areas:
- Improved risk selection: Capture more data and complement internal with external data to get more insights to improve your underwriting
- Improved efficiency in underwriting: Removal of manual tasks, freeing time for value adding activities such as writing new business
- Portfolio optimization: Improved data to support decision making on ideal business mix and the fine tuning of pricing, lines, and net positions
- Enhanced client proposition: Offering data driven services (in the longer-term) such as providing detailed exposure information to support risk selection, aggregation analysis, portfolio analysis and pricing
As an example, early investment in property catastrophe D&A enabled one data-driven reinsurer to take a differentiated view of risk, allowing it to build a market- leading portfolio.
The benefits are clear but the key to the success of the D&A journey is having a clear strategy and structured plan to drive progress forward. For basic reinsurers, the first step of the journey is to develop a comprehensive understanding of the current state of D&A and to define the future state with reference to best practice. These reinsurers can then identify providers to support the development of new integrated systems. For average reinsurers that are at a more advanced stage of development, data ingestion should become a key focus — both in third party and increasing capture from cedent submissions and then investing in developing advanced portfolio analytics.
About the Study
Aon’s Strategy and Technology Group conducted a study assessing the D&A landscape for reinsurers. The study was composed of significant secondary research element combined with extensive primary research including 25+ interviews with participants from across reinsurance value chain: brokers, actuaries, underwriters, data, and technology leaders and InsurTech founders.
About the Authors
Thomas Griffiths
Thomas Griffiths leads Aon's Strategy Consulting proposition for Reinsurers. He has nine years of experience advising reinsurance company management teams on a broad range of topics including: Market entry strategies, portfolio optimization, product development & innovation, growth strategies and operational improvement.
https://www.linkedin.com/in/thomas-griffiths-897b8579/
Jessica Cremin
Jessica Cremin is a Manager in the Strategy Consulting team within STG. She has nine years of experience working within the insurance industry, with four of those working for Aon advising insurers and reinsurers on their strategy. This has included working for several global reinsurers to advise them on the use of data and analytics in reinsurance.
https://www.linkedin.com/in/jessica-cremin-acii-37874656/
Jamie MacRitchie
Jamie MacRitchie is a Senior Associate in the STG’s Strategy Consulting team. Based in London, Jamie has more than five years of experience at various strategy consulting firms, working across industries and disciplines. Since joining Aon’s STG in 2021, he has worked with more than a dozen (re)insurers on projects spanning all areas of specialization within STG Strategy Consulting.
https://www.linkedin.com/in/jamie-macritchie/
General Disclaimer
The information contained herein and the statements expressed are of a general nature and are not intended to address the circumstances of any particular individual or entity. Although we endeavor to provide accurate and timely information and use sources we consider reliable, there can be no guarantee that such information is accurate as of the date it is received or that it will continue to be accurate in the future. No one should act on such information without appropriate professional advice after a thorough examination of the particular situation.
Terms of Use
The contents herein may not be reproduced, reused, reprinted or redistributed without the expressed written consent of Aon, unless otherwise authorized by Aon. To use information contained herein, please write to our team.
Aon's Better Being Podcast
Our Better Being podcast series, hosted by Aon Chief Wellbeing Officer Rachel Fellowes, explores wellbeing strategies and resilience. This season we cover human sustainability, kindness in the workplace, how to measure wellbeing, managing grief and more.
Aon Insights Series Asia
Expert Views on Today's Risk Capital and Human Capital Issues
Aon Insights Series Pacific
Expert Views on Today's Risk Capital and Human Capital Issues
Aon Insights Series UK
Expert Views on Today's Risk Capital and Human Capital Issues
Client Trends 2025
Better Decisions Across Interconnected Risk and People Issues.
Construction and Infrastructure
The construction industry is under pressure from interconnected risks and notable macroeconomic developments. Learn how your organization can benefit from construction insurance and risk management.
Cyber Labs
Stay in the loop on today's most pressing cyber security matters.
Cyber Resilience
Our Cyber Resilience collection gives you access to Aon’s latest insights on the evolving landscape of cyber threats and risk mitigation measures. Reach out to our experts to discuss how to make the right decisions to strengthen your organization’s cyber resilience.
Employee Wellbeing
Our Employee Wellbeing collection gives you access to the latest insights from Aon's human capital team. You can also reach out to the team at any time for assistance with your employee wellbeing needs.
Environmental, Social and Governance Insights
Explore Aon's latest environmental social and governance (ESG) insights.
Q4 2023 Global Insurance Market Insights
Our Global Insurance Market Insights highlight insurance market trends across pricing, capacity, underwriting, limits, deductibles and coverages.
Global Risk Management Survey
Better Decisions Across Interconnected Risk and People Issues.
Regional Results
How do the top risks on business leaders’ minds differ by region and how can these risks be mitigated? Explore the regional results to learn more.
Top 10 Global Risks
Trade, technology, weather and workforce stability are the central forces in today’s risk landscape.
Industry Insights
These industry-specific articles explore the top risks, their underlying drivers and the actions leaders are taking to build resilience.
Human Capital Analytics
Our Human Capital Analytics collection gives you access to the latest insights from Aon's human capital team. Contact us to learn how Aon’s analytics capabilities helps organizations make better workforce decisions.
Human Capital Quarterly Insights Briefs
Read our collection of human capital articles that explore in depth hot topics for HR and risk professionals, including using data and analytics to measure total rewards programs, how HR and finance can better partner and the impact AI will have on the workforce.
Insights for HR
Explore our hand-picked insights for human resources professionals.
Workforce
Our Workforce Collection provides access to the latest insights from Aon’s Human Capital team on topics ranging from health and benefits, retirement and talent practices. You can reach out to our team at any time to learn how we can help address emerging workforce challenges.
Mergers and Acquisitions
Our Mergers and Acquisitions (M&A) collection gives you access to the latest insights from Aon's thought leaders to help dealmakers make better decisions. Explore our latest insights and reach out to the team at any time for assistance with transaction challenges and opportunities.
Natural Resources and Energy Transition
The challenges in adopting renewable energy are changing with technological advancements, increasing market competition and numerous financial support mechanisms. Learn how your organization can benefit from our renewables solutions.
Navigating Volatility
How do businesses navigate their way through new forms of volatility and make decisions that protect and grow their organizations?
Parametric Insurance
Our Parametric Insurance Collection provides ways your organization can benefit from this simple, straightforward and fast-paying risk transfer solution. Reach out to learn how we can help you make better decisions to manage your catastrophe exposures and near-term volatility.
Pay Transparency and Equity
Our Pay Transparency and Equity collection gives you access to the latest insights from Aon's human capital team on topics ranging from pay equity to diversity, equity and inclusion. Contact us to learn how we can help your organization address these issues.
Property Risk Management
Forecasters are predicting an extremely active 2024 Atlantic hurricane season. Take measures to build resilience to mitigate risk for hurricane-prone properties.
Technology
Our Technology Collection provides access to the latest insights from Aon's thought leaders on navigating the evolving risks and opportunities of technology. Reach out to the team to learn how we can help you use technology to make better decisions for the future.
Trade
Our Trade Collection gives you access to the latest insights from Aon's thought leaders on navigating the evolving risks and opportunities for international business. Reach out to our team to understand how to make better decisions around macro trends and why they matter to businesses.
Transaction Solutions Global Claims Study
Better Decisions Across Interconnected Risk and People Issues.
Weather
With a changing climate, organizations in all sectors will need to protect their people and physical assets, reduce their carbon footprint, and invest in new solutions to thrive. Our Weather Collection provides you with critical insights to be prepared.
Workforce Resilience
Our Workforce Resilience collection gives you access to the latest insights from Aon's Human Capital team. You can reach out to the team at any time for questions about how we can assess gaps and help build a more resilience workforce.
More Like This
-
Article 9 mins
6 Insights to Build Risk Resilience in a Volatile Retail Market
Retailers in North America are navigating intense competition, shifting consumer demands and rising costs. Add to that a wave of evolving risks — from cyber to litigation — and the pressure mounts. These six insights can help retailers rethink their risk strategy.
-
Article 9 mins
Breaking the Silence – Tailored Strategies for Men’s Mental and Financial Health
Conversations at work about mental health and finances can be daunting. That’s especially true for male employees, who fear the associated stigma. Employers can help those conversations by supporting a healthy culture and providing benefits designed to help with financial and mental wellbeing.
-
Article 5 mins
Rethinking Talent Strategy as H1B Visa Costs Rise
As H1B visa costs surge, organizations face complex decisions in talent strategy and global workforce planning. This article explores how employers, talent, and industry must adapt holistically to remain resilient and competitive amid sweeping immigration and market changes.
-
Article 25 mins
Country-Level Findings
Explore how risk perceptions vary across countries with insights from Aon’s 2025 Global Risk Management Survey.
-
Article 10 mins
Latin America’s Risk Landscape: Turning Complexity into Competitive Advantage
Latin American organizations face converging risks, but those who rethink resilience can unlock growth and gain a competitive edge.
-
Article 1 mins
Regional Results
Aon’s 2025 Global Risk Management Survey explores how organizations across four regions are responding to top risks—revealing both the challenges they face and the opportunities to build resilience in a fast-changing world.
-
Article 11 mins
Rethinking Resilience: Addressing Asia Pacific’s Top Risks
Asia Pacific’s risk landscape is shifting fast. Organizations that rethink resilience as a strategic differentiator will be best placed to navigate volatility and seize emerging opportunities.
-
Article 10 mins
Rethinking Resilience: Navigating North America’s Evolving Risk Landscape
North American organizations face intensifying risks across cyber, supply chain, reputation, and talent. Those who rethink resilience and risk management can turn uncertainty into a source of competitive advantage.
-
Article 10 mins
Turning Uncertainty into Opportunity: Managing Risk in the EMEA Region
In a region shaped by volatility and transformation, EMEA organizations are rethinking risk and resilience to unlock competitive advantage and navigate a rapidly evolving global landscape.
-
Article 10 mins
Where Cyber Meets Physical: Rethinking Risk in the AI Age
From drones that dodge surveillance to deepfakes that unlock doors, AI is reshaping physical security. It’s time for risk managers to rethink how they protect their organizations.
-
Article 8 mins
Cyber Risk is the Weak Link in Data Center Construction
Data center construction is booming — but cyber risk management hasn’t kept pace. As digital infrastructure becomes ever more critical, fit-for-purpose insurance solutions are essential to protect projects from costly cyber events that derail timelines and budgets.
-
Article 7 mins
Optimizing and Personalizing Benefits with Artificial Intelligence
There are a few important ways AI is already influencing the health and benefit ecosystem in the U.S. Here’s how HR teams can harness their vendor ecosystem and use this technology to influence better health outcomes for their workforces.
-
Article 13 mins
Securing Power: Global Strategies for Data Center Energy Resilience
Artificial intelligence is driving unprecedented demand for data center power, straining global grid capacity and reshaping energy strategies. Developers are racing to secure reliable energy but face complex risks and challenges.
-
Article 11 mins
High Stakes in High Tech: Securing the Technology Supply Chain
As in-demand, high-value technology cargo travels through complex supply chains, any disruption can trigger costly delays and reputational damage. Leaders can manage volatility with a future-ready risk management approach backed by innovative insurance solutions and data-driven logistics.
-
Article 5 mins
2026 Salary Increase Planning Tips
Global voluntary turnover remains low, shaping cautious 2026 salary budgets and prompting a renewed focus on employee development to sustain engagement. Employers are balancing cost control with strategic investments in skills, paying high performers, pay equity and total rewards.
-
Article 8 mins
Adapting to Disruption: How Financial Institutions are Reframing Risk
Financial institutions are navigating a landscape of converging risks, from cyber threats and regulatory complexity to economic volatility and geopolitical disruption.
-
Article 9 mins
Building Resilience to Support Growth in Construction and Real Estate
Construction and real estate organizations are navigating a risk landscape shaped by economic volatility, digital acceleration and workforce disruption.
-
Article 1 mins
Industry Insights
Business risks impact industries in different ways. Aon’s 2025 Global Risk Management Survey reveals how organizations across nine sectors are responding to today’s most pressing threats—from geopolitical volatility and cyber risk to supply chain disruption and talent shortages.
-
Article 10 mins
Managing Risk and Unlocking Opportunity in the Food, Agribusiness and Beverage Industry
Surging input costs, supply chain fragility and geopolitical instability are reshaping the risk landscape for the food, agribusiness and beverage (FAB) industry. As organizations face mounting pressure on margins and operations, leaders are rethinking risk strategies to unlock resilience and growth.
-
Article 11 mins
Navigating Risk in Insurance: Turning Complexity into Competitive Advantage
Aon’s Global Risk Management Survey shows insurers face a convergence of risks — cyber, climate and geopolitical volatility — that demand strategic resilience, sharper underwriting and innovation to stay relevant in a shifting landscape.
-
Article 10 mins
Navigating Risk in Life Sciences: Building Resilience to Support Growth
Faced with fragile supply chains, regulatory upheaval and rising competition, life sciences firms are reframing risk as a strategic enabler – using analytics and alternative capital to protect innovation and unlock growth.
-
Article 10 mins
Navigating Risk in Transportation and Logistics: Gearing Up for Big Transitions
As geopolitical instability, workforce disruption and rapid technological change converge, the transportation and logistics industry is undergoing a strategic transformation. Organizations are rethinking supply chains, investing in automation and reshaping workforce strategies to build resilience.
-
Article 11 mins
Navigating Volatility in Natural Resources: Risk Management as a Value Driver
From business interruption and commodity price volatility to shifting regulations and cyber threats, risks are converging to reshape the operating environment for the natural resources industry.
-
Article 9 mins
Technology, Media and Communications: Rethinking Risk in a Shifting Landscape
As disruption accelerates across the TMC industry, organizations face a complex web of risks — from cyber threats and AI upheaval to regulatory shifts and intensifying competition. Leaders are rethinking risk to build resilience, unlock growth and stay ahead in a rapidly evolving landscape.
-
Article 10 mins
Turning Risk into Resilience in the Industrials and Manufacturing Industry
From commodity price volatility and economic uncertainty to supply chain disruption and cyber threats, the industrials and manufacturing industry faces a convergence of risks that are reshaping the operating environment and requiring a new approach to risk.
-
Article 6 mins
Optimizing Your Property Program: A Risk Capital Approach to Manage Volatility
Risk buyers can build resilience in their property portfolios by implementing a risk capital strategy that utilizes alternative risk transfer sources to access capital and support long-term program stability.
-
Article 10 mins
Cyber and E&O: Pricing Holds, but Market Momentum is Shifting
The global cyber and tech errors and omissions market continues to favor buyers — for now. As AI-driven threats, privacy litigation and supply chain exposures intensify, forward-thinking organizations are using this window to build resilience.
-
Article 10 mins
A Better Approach to Succession Planning Using Assessment Data
Succession planning is evolving. By gathering comprehensive data and adopting predictive approaches, organizations can better anticipate workforce needs and build deeper benches of future leaders.
-
Article 7 mins
Business Interruption: Managing Risk in an Interconnected World
Business interruption is the second-highest global risk in 2025 — but is expected to fall to seventh place by 2028. As interconnected threats multiply, from cyber attacks to climate events, organizations must diversify supply chains, embed geopolitical insight and regularly update continuity plans.
-
Article 6 mins
Cash Flow and Liquidity Risk: A Rising Challenge
Cash flow and liquidity risk re-enters the top ten global risks in 2025 — and is expected to remain in tenth place by 2028. Amid an uncertain macroeconomic outlook, organizations must strengthen forecasting and unlock working capital to build financial resilience.
-
Article 7 mins