VU

CAT Modeling

Vuram
Gurgaon2-6 LPA Posted 18 Jun 2025
FULL TIME
Rms
Air
Sql
Vba

Job Description

  • Portfolio Modeling (3+ years experience in end-to-end portfolio rollups)
  • Regulatory Reporting (4+ years experience in EDM/RDM/SCHEMA)
  • Model Validation (4+ years experience in Model Validation with tools like RMS/AIR)
  • Technical Solution (3+ years experience in SQL Query writing for CAT Modeling function)
  • Portfolio Modeling
  • Good understanding Cat Modeling process and workflows
  • Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) for insureds and perform portfolio risk analyses.
  • Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms through coding in RMS and SQL.
  • Assist clients in the understanding of catastrophe risk of individual insured through analytics based on catastrophe model results.
  • Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements
  • Provide timely and frequent feedback to team members.
  • Preparing MIS reports
  • Training and mentoring of team members inducted in the pricing process.
  • Assisting in monthly post bind and portfolio rollup activities.
  • Ensure all SLAs are met Communication with onshore SPOCs at regular intervals.

Regulatory Reporting

  • Good understanding Cat Modeling process and workflows.
  • Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) including accumulation analysis for reporting needs, whenever required
  • Thorough knowledge of RMS EDM-RDM schema
  • Ability to understand the requirements of regulatory submissions and further deliver them accordingly
  • Understanding of RDS scenarios of Lloyds including Non-Modelled scenarios as well
  • Working knowledge regulatory reports like LCM, RDS Scenarios, Terror Accumulations & reporting.
  • Working knowledge of any other regulatory reports.
  • Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms.
  • Provide analytical support to catastrophe modeling team operations by sharing knowledge and information
  • Develop processes and scripts for process improvements
  • Assisting in portfolio rollup activities.
  • Ensure all SLAs are met
  • Communication with onshore SPOCs at regular intervals.

Model Validation:

  • Perform model validation and provide recommendations on model use and/or required adjustments.
  • Work with internal teams and external data providers on analysis, utilising available data including scientific information, claims and insured exposure
  • Contribute to and lead Group projects as required, liaising with other teams globally.
  • Produce customised reports on exposure and modelled results.
  • Evaluate re/insurance pricing for individual accounts and product classes.
  • Analyse catastrophe reinsurance structures and strategies to support reinsurance placements.
  • Assist with the analysis of real time events and identify learnings from post-event reviews.
  • Strong analytical and numerical ability, in order to interrogate large datasets
  • Experience of working with re/insurance catastrophe data and/or catastrophe modelling software
  • Excellent written and verbal communication skills, and the ability to explain technical concepts clearly
  • Intermediate/Advanced Excel skills
  • Pro-active attitude to identifying inefficient processes and developing improvements
  • Desirable Requirements
  • Knowledge of commercial insurance and/or the catastrophe modelling industry
  • Sound working knowledge of RMS/AIR and any other vendor modelling platforms
  • Coding experience in a relevant language (e.g. SQL, VBA, R, C#) Experience in using mapping software (e.g. GIS)
  • Technical Solution (SQL query):
  • Catastrophe Modelling Analyst in the Accumulation Management department, working with the Technical Solutions team
  • The Technical Solutions team is focused on developing customized in-house tools and databases for the Accumulation Management team, to streamline processes and organize data in an efficient manner
  • Technical role with large potential for growth in responsibilities
  • Develop an understanding of existing Catastrophe Modelling processes, licensed software, and the various in-house tools used to automate processes
  • Maintain existing Accumulation Management tools. Debug errors in the code when users experience issues
  • Assist users with technical questions. Explain how tools work and deliver training sessions when required
  • Test new functionality prior to launch to ensure that tools are working as intended
  • Support team to design and develop new tools to automate processes. Update user guides when needed
  • Work with colleagues around the globe on ad-hoc projects

Qualifications

Bachelor s Degree in Mathematics/ Applied Mathematics/ Statistics/ Operations Research/ Actuarial Science

Required Skills

Join WhatsApp Channel