- 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
