Catastrophe Modeling Analyst

RecruitNest Consulting; Pasig; Hybrid; PHP 781,000 - 1,228,000; Full time

Job summary

RecruitNest Consulting in Ortigas, Pasig is seeking an Insurance - Catastrophe Modeling Analyst to support CAT modeling, exposure management, and data analysis for US non-life insurance lines. You will prepare and validate property and exposure data, assess disaster risks, and help identify potential losses across locations.

The role requires a degree in a quantitative field and 1+ years in US non-life insurance, with strong Excel and CAT modeling software familiarity.

Qualifications

• Bachelor's degree in Mathematics, Statistics, CS, or related field.
• 1+ year experience in US Non-Life Insurance.
• Experience with CAT Modeling, Exposure Management, or Insurance Data Analysis.
• Strong Excel skills with Pivot Tables and lookup formulas.
• Familiarity with CAT modeling software is preferred.

Responsibilities

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

Skills

Data analysis

Excel Pivot Tables

XLOOKUP/VLOOKUP

Index-Match

Power BI

SQL

Python

VBA

CAT Modeling

US geography

Education

Bachelor's degree in Mathematics

Bachelor's degree in Statistics

Bachelor's degree in Computer Science

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.

-