Catastrophe Modeling Analyst

Arch Insurance Group Inc.; Cebu City; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

Arch Global Services (Philippines) Inc. is seeking a Catastrophe Modeling Analyst to manage exposure data, validate against sources, and prepare outputs for catastrophe models like RMS and AIR. The role supports per-account modeling and data integrity across underwriting and reinsurance teams.

The candidate will develop data cleansing techniques, acquire data from multiple sources, and identify trends to improve workflow efficiency and decision making.

Qualifications

• Proficient in Excel and modeling software (RMS, AIR, EQE).
• Experience in data quality review and exposure data profiling.
• Knowledge of statistics and reporting for large datasets.
• Experience with querying and presenting data to stakeholders.

Responsibilities

• Review and profile property and casualty exposure data for completeness and quality.
• Validate exposure data against bordereaux, claims, and placements to identify discrepancies.
• Prepare data outputs for reinsurers and catastrophe models (RMS/AIR).
• Process insured exposure schedules for per-account modeling with data integrity checks.
• Interpret data and report to underwriting, actuarial, reinsurance, and business teams.
• Develop data cleansing techniques and workflows to improve processing efficiency.
• Acquire data from primary/secondary sources and maintain exposure databases.
• Identify trends in exposure and loss data sets.
• Filter and scrub data to fix coding and data-quality issues.
• Identify process improvements for catastrophe modeling workflows.

Skills

Excel

Modeling software

SQL

MS Access

Analytical skills

Communication skills

Statistics knowledge

Data interpretation

Education

BS in Geo Science, Meteorological Engineering, or related discipline

Tools

RMS

AIR

EQE

MS Access

Job description

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility.

Job Summary

The Catastrophe Modeling Analyst is responsible for collecting, organizing, reviewing, cleansing, interpreting, analyzing, documenting, and distributing catastrophe modeling exposure data and results. This role supports per-account modeling by processing insured exposure schedules, ensuring data integrity, validating exposure information against supporting sources, and preparing data outputs for internal business users, reinsurers, and third-party catastrophe models such as RMS/AIR.

Job Responsibilities

• Perform review and profiling of property and casualty exposure data to assess completeness, consistency, and overall data quality.
• Validate exposure data against premium bordereaux, claims reported, and facultative placements to identify discrepancies, gaps, or data issues requiring resolution.
• Format and prepare exposure data for internal and external use, including outputs to reinsurers and outputs to catastrophe modeling platforms such as AIR.
• Process insured exposure schedules for per-account catastrophe modeling and ensure data integrity through queries, views, reports, and quality-control checks.
• Interpret data, analyze catastrophe model results, and provide ongoing reporting to support underwriting, actuarial, reinsurance, and business decision-making.
• Develop and implement data cleansing techniques and workflow strategies that improve efficiency, accuracy, and repeatability of exposure data processing.
• Acquire data from primary and secondary sources and maintain exposure databases, reporting files, and related data systems.
• Identify, analyze, and interpret trends or patterns in exposure and loss data sets.
• Filter, scrub, and evaluate data for performance indicators to locate and correct coding, mapping, or data-quality issues.
• Identify and define process improvement opportunities that enhance catastrophe modeling workflows, reporting accuracy, and operational efficiency.

Required Skills

• Technical skills: Microsoft Excel, Modeling software (RMS, AIR, EQE)
• Good to have : SQL, MS Access
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Technical expertise or programming background with exposure to database management is a plus.
• Experience developing queries, writing reports, and presenting findings to business stakeholders.
• Knowledge of statistics and experience using statistical tools or packages to analyze large datasets, particularly in Excel and Access.
• Knowledge of reporting packages such as Business Objects and databases such as SQL.
• Previous catastrophe modeling exposure preferred, including experience with RMS, AIR, or similar third-party catastrophe modeling software.
• Excellent communication and interpersonal skills, with the ability to coordinate with internal teams and external stakeholders.

Education

BS inGeo Science, Meteorological Engineering, or related discipline

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.

10400 Arch Global Services (Philippines) Inc.