CAT Modeling Data Analyst

Position Summary

The Property Underwriting Data Analyst supports the Large Property Team by preparing, validating, and analyzing exposure data for use in industry-standard catastrophe models. This role serves as a critical quality control checkpoint between data intake and final model output delivery to underwriters. The successful candidate will bring intellectual curiosity, excellent attention to detail, and the ability to think critically about property exposures across diverse risk types and geographies.

Key Responsibilities:

Data Quality Control, Exposure Analysis & Validation
. Review cleansed Statement of Values (SOV) and policy detail files for completeness, consistency, and reasonableness prior to modeling.
. Identify and investigate data anomalies, missing fields, and suspect values across COPE attributes, utilizing all available resources, including publicly available information.
. Cross-reference policy data against submission documents to verify accuracy of insured values, location counts, and coverage structures, terms and conditions.
. Flag data quality issues, make changes to post-cleanse SOV, and coordinate with the risk analytics team to resolve/approve discrepancies before final model runs.
. Research publicly available data sources, aerial imagery, and geocoding tools to supplement or validate submitted property information, and coordinate with the data management team or underwriters to resolve discrepancies before final model runs.
Catastrophe Model Execution
. Execute property catastrophe model runs using AIR Touchstone workbook.
. Apply appropriate model settings, resolution levels, and financial perspectives consistent with portfolio standards and submission characteristics.
. Review model output for outliers, unexpected loss patterns, and results that are inconsistent with the risk profile of the submission.
. Perform sensitivity testing and scenario analysis as directed to support underwriting decision-making.

Reporting & Underwriter Support
. Prepare clean, finalized model outputs for delivery to underwriters so that submission is ready for rating, narrative development, etc.
. Document data quality findings, model assumptions, and any adjustments made during the QC process.
. Communicate results clearly and concisely to underwriters, highlighting material data limitations or modeling uncertainties that may affect pricing or terms.

Qualifications:

Experience
. 1-3 years of professional experience with property data and underwriting prior internship or academic project experience in insurance, reinsurance, or catastrophe risk is a plus.
. Understanding of property insurance concepts, including policy structure, coverage terms, and Statement of Values, is required.

Technical Skills
. Proficiency in Microsoft Excel, including data manipulation, formula-based validation, and pivot table analysis.
. Exposure to catastrophe modeling platforms (AIR, Verisk/ISO) is beneficial but not required training will be provided.
. Comfort working with large, complex data sets and identifying patterns or inconsistencies.

Core Competencies:

. Exceptional attention to detail with a disciplined approach to data accuracy and quality control.
. Strong analytical and critical thinking skills - able to assess whether a risk profile is internally consistent and plausible.
. Effective written and verbal communication skills, with the ability to translate technical findings for a non-technical audience.
. Self-motivated and organized, with the ability to manage multiple submissions simultaneously under time constraints.
. Collaborative team player who is comfortable asking questions and escalating issues appropriately.