Catastrophe Modeling Analyst

Responsibilities include:

• Model input preparation - Includes data preparation as well as data scrubbing using SQL/Excel.
  • Analyzing the exposures - Includes geocoding the exposures, implementing modeling assumptions accurately in the modeling process, ensuring correct model and peril settings, etc. in order to quantify insurers' catastrophe loss potential.
  • Generating reports - Includes using internal tools like iFM, WorkFlowManager for creating exposure as well as loss summary reports, visualizing various statistics by creating maps using SpatialKey, ArcGIS, etc.
  • Running proprietary models - Running customized peril analysis using WTW proprietary models.
  • Model Sensitivity Analysis - Testing the change in model output with change in input parameters.
  • Answering SRQ - using internal tools and modeled losses for answering Natural Catastrophe portion of SRQs.
• Modeled loss investigation Undertake studies to find drivers of losses and validate the loss movements. May need some support from the seniors for complicated loss movements .

The incumbent will also be expected to co-ordinate and communicate with the onshore lead analyst as and when needed in order to

• discuss the progress made as well as any items of significance
• seek feedback and suggestions

Scientific/ Technical

Competencies

SQL (including stored procedures)

Excel (including VBA)

Statistics including knowledge of simulation methodologies

Catastrophe Model Framework (including RiskLink and Touchstone Financial Modules)

Insurance and Re-insurance terms coding, including multi layered sublimits and policy restrictions

Treaty coding

Proprietary Modeling (iQUIP modeling)

ArcGIS

Event Response

Programming skills (Preferred) R/Python/Matlab

Model Sensitivity Analysis

Financial Module / Backend loss calculations

Model Change Management

Database schema (manipulate tables and automate tasks through backend)

Inter model exposure conversion