 |
|
 |  |  |  |
Modelling Design Partners and SolveXia recently conducted a survey, in collaboration with Actuarial Post, to better understand the challenges faced by actuarial departments. The results revealed that the most pertinent challenge that is associated with actuarial processes is vulnerability to input error. Not surprisingly, the majority of respondents also indicated continued concern about regulatory requirements. Most worryingly, though, is that a significant dependence on spreadsheets for major calculations was noted. |
Spreadsheets are pervasive in many industries, due to their flexibility and perceived reliability. Actuarial departments are no exception: 90% of respondents indicated that their departments use spreadsheets. Despite their ease of use, spreadsheets are notoriously difficult to audit and control. Frequent manual manipulation of data and equations is often required, which leave spreadsheets vulnerable to human error. The London Whale incident and the Reinhart-Rogoff fiasco are both extreme examples of such errors- one in investment banking, and the other in international economics. In both cases, highly qualified mathematicians, and world-renowned economists accidently copied incorrect equations in spreadsheets, which led to disastrous errors. The insurance industry uses the same investment instruments as investment banks, within asset-liability hedging strategies. In our survey, almost 70% of respondents indicated that spreadsheets are used to perform major calculations in actuarial departments. Undetected errors in these spreadsheets may lead to insurance executives not correctly estimating the risks within their portfolios, thereby increasing the risk of extreme losses in relatively ordinary market conditions. Nonetheless, the survey results also show that an increasing number of actuarial departments use process automation. Process automation platforms, such as SolveXia, allow actuaries to have the flexibility of spreadsheets, while reducing the risk of error caused by manual input and also adding transparency and audit ability. Is process automation the solution to overcome these issues relating to risk and cost? To view the full results of the survey please click below.
|
|
|
|
| Specialty GI Pricing Leader | ||
| London - Negotiable | ||
| Senior Life Actuarial Assoc or Direct... | ||
| Bermuda - Negotiable | ||
| Health Insurance Manager | ||
| London/hybrid 2-3dpw office-based - Negotiable | ||
| Principal Actuary - Bermuda | ||
| Bermuda - Negotiable | ||
| GI Pricing Analyst | ||
| Wales / hybrid 2dpw in the office - Negotiable | ||
| International Investment Manager | ||
| Bermuda - Negotiable | ||
| Financial Risk Leader - Bermuda | ||
| Bermuda - Negotiable | ||
| Risk Transfer Consultant | ||
| Any UK Office location / Hybrid working, 2 days p/w in office - Negotiable | ||
| Senior Life Actuarial Analyst | ||
| South East / hybrid 3dpw office-based - Negotiable | ||
| Investment Manager - Credit Risk & Re... | ||
| South East / hybrid 3dpw office-based - Negotiable | ||
| Actuarial Project Manager | ||
| South East / hybrid 3dpw office-based - Negotiable | ||
| Senior Associate - Trustee Pensions | ||
| South East / hybrid 1-2dpw office-based - Negotiable | ||
| STAR EXCLUSIVE: BPA Pricing Actuaries | ||
| Flex / hybrid 2-3 dpw office-based - Negotiable | ||
| Ceded Re Pricing Actuary | ||
| London - £150,000 Per Annum | ||
| Senior Actuary | ||
| London - £180,000 Per Annum | ||
| Financial Reporting in Reinsurance | ||
| London / hybrid 2 days p/w office-based - Negotiable | ||
| Home Insurance Director | ||
| North West/Hybrid - £140,000 Per Annum | ||
| Head of Long-tail Global | ||
| UK/USA - £200,000 Per Annum | ||
| Challenge the pensions industry! | ||
| UK Flex / hybrid 2dpw office-based - Negotiable | ||
| Pensions Data Science Actuary | ||
| Offices UK wide, hybrid working - Negotiable | ||
Be the first to contribute to our definitive actuarial reference forum. Built by actuaries for actuaries.
Copyright © 2025 Actuarial Post. Created by Zero-One Design Ltd
