CAT Modeling Analyst: US Insurance Data & Risk Insights

PNI Business Solutions, Inc.; Metro Manila; On-site; PHP 3,750,000 - 5,625,000; Full time

Job summary

PNI Business Solutions, Inc. is seeking a Catastrophe Modeling Analyst to analyze US non-life insurance data, prepare data for CAT modeling, and assess property exposure to natural disasters.

You will identify risk concentrations and support risk and portfolio reporting. Responsibilities include cleaning and validating addresses, ZIP codes, and location data, coordinating with clients and underwriters, and driving process improvements through automation and documentation.

Qualifications

• Must have 1–2 years of experience in US Non-Life Insurance (Property, Commercial, Homeowners).
• Experience in CAT Modeling, Exposure Management, or Insurance Data Analysis.
• Strong understanding of US geography (states, cities, ZIP codes, properties).
• Knowledge of natural disaster risks (hurricanes, tornadoes, earthquakes, floods, severe storms).
• Experience handling policy, property, coverage, and location data.
• Excellent MS Excel skills with Pivot Tables, XLOOKUP/VLOOKUP, and INDEX-MATCH.
• Analytical mindset with attention to detail and problem-solving ability.

Responsibilities

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

Skills

Analytical thinking

Problem solving

Attention to detail

Education

Bachelor’s or Master’s degree in Mathematics, Statistics, Actuarial Science, Insurance, Engineering, Geography, Data Analytics

Tools

MS Excel

Power BI

SQL

Python

VBA

Job description

PNI Business Solutions, Inc. is seeking a Catastrophe Modeling Analyst to analyze US non-life insurance data, prepare data for CAT modeling, and assess property exposure to natural disasters.

You will identify risk concentrations and support risk and portfolio reporting. Responsibilities include cleaning and validating addresses, ZIP codes, and location data, coordinating with clients and underwriters, and driving process improvements through automation and documentation.