NAT CAT Data Engineer/Analyst (Intern) - January 2025

Job description

*

Context

AXA Group Risk Management Property & Casualty (GRM P&C) deals with the most sophisticated P&C technical and actuarial challenges of a leading international insurance company, among which the management of natural catastrophe risks (CAT). Natural variability of climate and seismic activity have demonstrated their devastating potential, climate change bringing additional uncertainty for the future. AXA’s rapid expansion over the last years – both in terms of geographical footprint and P&C insurance offer – widely exposes AXA to natural perils, being in charge of the financial protection of its clients. In this context, AXA must maintain state-of-the-art CAT risk management techniques through permanent innovations.
<-- [if supportLineBreakNewLine]--><--[endif]-->

Group Risk Management

AXA GRM brings together high level and multidisciplinary staff with engineers, PhDs, actuaries, data scientists and financials split between Paris, Hong Kong, Zürich and Madrid. Its main missions are focused on the following key areas

• develop and maintain models and tools in an efficient and strong IT ecosystem to industrialize deliverables.
• analyze, model and aggregate the P&C Group’s risks (economic capital);
• define and implement the process enabling to secure the undertaken risks (risk appetite, assets accumulation, reserve, premium, natural catastrophe and man-made risks...);
• optimize the Group protections (reinsurance, securitization, hedging, etc.) to meet the desired strategy.

Job background

Position belongs to the Group P&C Risk Management Natural Catastrophe and Reinsurance team (21 FTE) which is organized several excellence centers NAT CAT R&D Modeling, Data Analytics, Accumulation Management and Reinsurance. As part of AXA’s Internal Model under the Solvency II framework, the NAT CAT and Reinsurance team are primarily in charge of delivering the annual NAT CAT modeling process, consisting of

• Collecting Property exposure data (geographical, physical and financial information) on a per-entity (AXA France, AXA Mexico, AXA Philippines…) and per-location basis (houses, factories, vehicles etc.);
• Assessing the risk on a per-entity per-peril basis (cyclones, earthquakes, floods, hailstorms...) which feeds the whole downstream chain locally (underwriting, pricing, strat plan, reinsurance decisions, economic capital modeling)
• Estimating the efficiency of the Group Property Reinsurance covers
• Developing in-house internal NAT CAT models, methodologies and applications to support the NAT CAT risk monitoring.

The NAT CAT modelling process has strong strategic and operational impacts since it feeds AXA Economic Capital internal model, the Economic Combined Ratio and NAT CAT budget and strategic plan calculations which drives the earnings and the solvency position of AXA Group. It and determines adequate levels of reinsurance needs, which may boost or hinder profitability. It is also a technical challenge with the data collection of 25+ millions of complex and worldwide policies covering 50+ millions risks, the parallel use of multiple modeling solutions including both physics and machine learning techniques, and finally the assessment of 190 country x peril levels of risk.

Mission

The NAT CAT DATA & Analytics team widely interacts with R&D Modelling team (in charge of developing internal CAT models), Reinsurance teams (in charge of ceded reinsurance modelling), Underwriting team (in charge of developing actuarial frameworks for technical pricings) and benefits from the IT expertise of two additional FTEs. The Internal Data Engineer/Analyst will have to develop and integrate innovative data products to enhance the NAT CAT risk assessment, be proactive and innovative in the continuous development of new functionalities.

The intern will actively contribute to this effort by:

• <-- [if supportLists]-->Developing innovative tools and technics for collecting processing, cleaning and modelling data
  • Group Property Exposure data base: cleaning, integrating, and implementing missing information from entities
  • Global Exposure Database: Contribute to a global exposure database build (searching, collecting,)
  • Collecting claims related to Nat Cat risk across major P&C entities
  • Exploit data science techniques to analyze meteorological data
  • Produce technical documentation
• Developing and improving our internal reports (Power BI) to assess the risks associated with NAT CAT risks and climate change
• Implement data analytics best-practices to assess the data accuracy and reliability
• Support the P&C risk assessment related to NAT CAT risks (Live Event Analysis)

Desired profile

Qualifications :

Education

·  Engineering or master’s degree in relevant field (engineering, natural hazards, actuarial science, applied maths)

Technical & Professional Skills

·  Robust Data and programming skills collection, transformation and mining (R/Python, SQL, Power BI)
·  Strong problem-solving skills and keen attention to detail;
·  French and Business English – fluent (spoken and written)
·  Experience with writing documentation, version control (e.g., Git) is a plus

Interpersonal skills

·  Analytical skills / Ability to evolve in a diverse technical and operational environment
·  Strong communication skills
·  Autonomous and with a strong sense of team spirit
·  Organized and rigorous
·  Motivated by an international and dynamic environment
·  Curiosity to learn about the insurance industry and actuarial science;