2025-7569_Catastrophe Modelling Analyst

Arch Global Services (Philippines) Inc.; Cebu City; On-site; PHP 600,000 - 900,000; Full time

Job summary

A leading global service provider in Cebu City is seeking a Catastrophe Modeling Analyst to clean and analyze client data for effective Cat risk modeling. Ideal candidates will have excellent MS Excel skills and strong analytical abilities, with experience in insurance data handling being a plus. You will work closely with Underwriters and need to adapt to changing requirements. A Bachelor’s degree in a related field is required.

Qualifications

• Experience working with third-party Cat modeling software is a plus.
• Basic knowledge of insurance and/or reinsurance contracts is desirable.
• Strong analytical, communication and time-management skills
• Ability to work in a diverse and dynamic team and adapt to changing workloads
• Willingness to work outside normal hours including evenings, weekends and public holidays

Responsibilities

• Clean clients' exposure data for accurate Cat risk modeling.
• Liaise with Underwriters on specific account requests.
• Analyze modeling data from insurance clients using software like AIR.
• Understand results and trends from data outputs.
• Interpret results outputs and identify trends and patterns in data

Skills

Proficiency in MS Excel

Strong analytical skills

Strong communication skills

Strong time management skills

Interpersonal skills

Flexible hours

Education

Bachelors degree in Science/Mathematics

BS in Computer Science/Engineering/Mathematics/Information Management/Statistics

Tools

SQL

MS Access

Visual Basic

Third Party Modeling Software

Python

JavaScript

SQL Server

Job description

Overview

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

Job Description

The Catastrophe Modeling Analyst is responsible for cleaning clients exposure data to enable accurate modelling of Cat risk (i.e. earthquakes, hurricanes, floods, etc.) as well as that from other manmade exposures such as Terrorism. The major tasks include data cleansing and modelling data from insurance clients in third party software (AIR) through an excel API.

• Cleansing Address and other location level information (scrubbing, importing and geocoding data).
• Liaise with Underwriters on specific account requests.
• Understand and extract information from Insurance contracts (slips).
• Analyze modeling data from insurance clients in third party software such as AIR.
• Understand results output and be able to see trends and patterns in the data where applicable.

Qualifications

• Proficiency in MS Excel.
• Strong analytical, communication and time management skills with an ability to exhibit critical thinking.
• Strong interpersonal skills with the ability to work in a diverse and dynamic team, to adapt to change in workload and/or priorities.
• Should be ready to potentially work outside of normal office hours on a regular basis, including evenings, weekends and public holidays as necessary.
• Flexible with changing requirements and ability to learn new processes quickly.

Preferred / Desirable

• SQL and MS Access, Visual Basic and database management systems such as SQL Server or other similar software.
• Basic knowledge of Insurance and/or reinsurance contracts and terminology.

A previous working experience using Third Party Cat modeling software (e.g. RMS, AIR, EQE.).

Technical Skills

Technical Skills Proficiency Level Required (R) /Optional (O)

• Microsoft Excel 3 R
• Third Party Modeling Software 3 R
• Microsoft Access 3 O
• Visual Basic 3 O
• SQL 3 O
• Programming Language (C#, VB, .NET, Python, JavaScript) 3 O

Additional Information

• Bachelors degree, Ideally science/mathematical Degree (e.g. BS in Computer Science, Engineering, Mathematics, Economics, Information Management or Statistics.)

Please refer to job description.