Catastrophe Modeling Specialist (US Insurance)

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

Job summary

RecruitNest Consulting is seeking an Insurance - Catastrophe Modeling Senior Analyst to join our client’s team in a hybrid Ortigas, Pasig location. You will analyze US non-life insurance data, prepare data for CAT modeling, and assess risks across states and locations.

The role requires 2+ years in US Non-Life Insurance, CAT modeling exposure management, and strong Excel skills. Collaboration with underwriters and clients is essential, with a focus on data quality and automation improvements.

Qualifications

• Bachelor's in Mathematics, Statistics, Computer Science, or related field.
• 2+ years in US Non-Life Insurance (Property, Commercial Insurance, Homeowners).
• CAT Modeling, Exposure Management, Insurance Risk Analysis, Underwriting, or Insurance Data Analysis experience.
• Strong knowledge of US geography (states, cities, ZIPs, addresses).
• Natural disaster risk knowledge (hurricanes, tornadoes, earthquakes, floods).
• Experience handling insurance policy, property, coverage, and location data.
• Advanced Excel skills: Pivot, XLOOKUP/VLOOKUP, INDEX-MATCH.

Responsibilities

• Analyze US non-life data (property, policy, coverage, location).
• Clean/validate addresses, ZIPs, property details, geographic data.
• Prepare data for CAT Modeling.
• Assess exposures to hurricanes, tornadoes, earthquakes, floods, storms.
• Identify risk concentrations across US states/locations.
• Review CAT results and prepare risk reports.
• Perform data quality checks and investigate discrepancies.
• Collaborate with clients/teams to resolve issues.
• Support automation and process improvements.
• Mentor junior team members.

Skills

MS Excel

Pivot Tables

XLOOKUP/VLOOKUP

INDEX-MATCH

Power BI

SQL

Python

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 - Mid/Senior
• 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: 5+ FTEs
• Industry: Business Process & Services (BPO)

About the Job:

We are looking for an Insurance - Catastrophe Modeling Senior 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, identify potential losses and risk concentrations, and contribute to improving data and modeling processes.

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.
• Handle complex analysis and support the review of work performed by junior team members.

Qualifications:

• Bachelor's degree in Mathematics, Statistics, Computer Science, or a related field.
• 2+ 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.