Catastrophe Modeling Analyst (US Insurance)

RecruitNest Consulting; Pasig; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

RecruitNest Consulting in Ortigas, Pasig, is seeking an Insurance - Catastrophe Modeling Analyst to join our client's team and support catastrophe modeling, insurance risk analysis, and exposure management activities. You will analyze US non-life insurance data, prepare and validate property and exposure information for CAT modeling, assess disaster risks, and identify risk concentrations across locations.

Collaborative efforts with clients, underwriters, and internal teams will drive data

Qualifications

• Bachelor's degree in Mathematics, Statistics, Computer Science, or a related field.
• 1+ years of experience in US Non-Life Insurance (Property, Commercial Insurance, Homeowners) or related areas.
• Experience with CAT Modeling, Exposure Management, Insurance Risk Analysis, Underwriting, or Insurance Data Analysis.
• Strong understanding of US geography (states, cities, ZIP codes, addresses, property locations).
• Knowledge of natural disaster risks (hurricanes, tornadoes, earthquakes, floods, severe storms).
• Strong MS Excel skills (Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH).
• Experience with CAT modeling software (RMS, AIR/Touchstone, Verisk) is highly preferred.
• Exposure to Power BI, SQL, Python, or VBA is an advantage.
• Ability to start immediately, if possible.

Responsibilities

• Analyze US non-life insurance data, including property, policy, coverage, and location information.
• Clean and validate data to ensure accurate addresses, ZIP codes, property details, and geographic information.
• Prepare insurance data for Catastrophe (CAT) Modeling.
• Analyze property exposure to hurricanes, tornadoes, earthquakes, floods, and severe storms.
• Identify risk concentrations and potential losses across different US states and locations.
• Review CAT modeling results and prepare risk, exposure, and portfolio reports.
• Perform data quality checks and investigate data discrepancies and issues.
• Work with large datasets to identify trends, risks, and data errors.
• Collaborate with clients, underwriters, and internal teams to resolve data and technical issues.
• Support process improvement initiatives through automation, documentation, and other efficiency improvements.

Skills

CAT Modeling

Data Cleaning

Data Validation

Excel

Pivot Tables

SQL

Python

Power BI

US Geography

Team Collaboration

Education

Bachelor's degree in Mathematics, Statistics, Computer Science, or a related field

Tools

RMS

AIR/Touchstone

Verisk

Job description

Job Expectations:

• Position Type: Experienced - Junior/Mid
• Employment Type: Full-Time; Permanent (Direct Hire)
• Work Setup & Location: Hybrid (3-4x onsite/week) - Ortigas, Pasig
• Work Schedule: Weekdays; Night Shift (US)
• Headcounts Needed: 10+ FTEs
• Industry: Business Process & Services (BPO)

About the Job:

We are looking for an Insurance - Catastrophe Modeling Analyst to join our client's team and support catastrophe modeling, insurance risk analysis, and exposure management activities. In this role, you will analyze US non-life insurance data, prepare and validate property and exposure information for CAT modeling, assess natural disaster risks, and help identify potential losses and risk concentrations across different locations.

Key Responsibilities:

• Analyze US non-life insurance data, including property, policy, coverage, and location information.
• Clean and validate data to ensure accurate addresses, ZIP codes, property details, and geographic information.
• Prepare insurance data for Catastrophe (CAT) Modeling.
• Analyze property exposure to hurricanes, tornadoes, earthquakes, floods, and severe storms.
• Identify risk concentrations and potential losses across different US states and locations.
• Review CAT modeling results and prepare risk, exposure, and portfolio reports.
• Perform data quality checks and investigate data discrepancies and issues.
• Work with large datasets to identify trends, risks, and data errors.
• Collaborate with clients, underwriters, and internal teams to resolve data and technical issues.
• Support process improvement initiatives through automation, documentation, and other efficiency improvements.

Qualifications:

• Bachelor's degree in Mathematics, Statistics, Computer Science, or a related field.
• 1+ years of experience in US Non-Life Insurance, such as Property, Commercial Insurance, Homeowners, or related areas.
• Experience in CAT Modeling, Exposure Management, Insurance Risk Analysis, Underwriting, or Insurance Data Analysis.
• Strong understanding of US geography, including states, cities, ZIP codes, addresses, and property locations.
• Knowledge of natural disaster risks, including hurricanes, tornadoes, earthquakes, floods, and severe storms.
• Experience handling insurance policy, property, coverage, and location data.
• Strong MS Excel skills, including Pivot Tables, XLOOKUP/VLOOKUP, and INDEX-MATCH.
• Experience with RMS, AIR/Touchstone, Verisk, or similar CAT modeling software is highly preferred.
• Experience with Power BI, SQL, Python, or VBA is an advantage.
• Can start immediately, if possible.

-