Senior Catastrophe Portfolio Modeling Analyst

Overview

The Senior Catastrophe Portfolio Modeling Analyst is responsible for supporting enterprise-wide catastrophe risk analytics across account, portfolio, and reinsurance layers. This role provides subject-matter expertise in RMS and AIR modeling platforms, develops high-quality exposure and loss analyses, and delivers technical solutions to improve modeling accuracy, efficiency, and reporting.

Responsibilities

• Perform catastrophe modeling using RMS and AIR across multiple lines of business.
• Prepare, validate, and cleanse exposure data for modeling.
• Produce portfolio-level metrics such as Probable Maximum Loss (PML), Average Annual Loss (AAL), exposed limits, and tail-risk metrics.
• Build SQL queries, scripts, and tools to support automation and reporting.
• Provide technical and modeling support to underwriting, operations, and analytics teams.
• Support catastrophe event response with exposure summaries and loss estimation.
• Maintain capacity tracking dashboards and reports.

Technology Stack

• Modeling Platforms: RMS (Risk Modeler, Underwrite IQ), AIR (Touchstone)
• Languages & Tools: SQL, Python (preferred), Excel/VBA, Alteryx
• Data: Exposure schedules, shapefiles, ELTs/EDMs, event results
• Cloud (Preferred): Azure Databricks, Azure Data Lake

Qualifications

Required

• 5+ years of catastrophe modeling or portfolio risk experience.
• Proficiency in RMS and/or AIR Touchstone.
• Strong SQL skills and experience working with large datasets.
• Ability to support real-time event response activities.
• Strong communication skills.

Preferred

• Experience with Python or R for data analysis and automation.
• Knowledge of reinsurance structures and portfolio risk metrics (PML, AAL, TVaR).
• Exposure to Azure Databricks or other cloud-based analytics platforms.
• Experience automating workflows using Alteryx or similar tools.
• Familiarity with geospatial data handling and mapping.

Core Competencies

• Analytical Thinking: Ability to interpret complex model outputs and portfolio metrics.
• Attention to Detail: Ensures accuracy in exposure data and modeling assumptions.
• Communication: Clearly conveys technical insights to non-technical stakeholders.
• Problem-Solving: Develops creative solutions for modeling challenges and data issues.

Compensation & Benefits

• Target salary range: $120,000 - $150,000 annually.
• Salary considers factors such as training, transferable skills, work experience, licensure and certification, business needs, and market demands.
• Full-time roles are eligible for bonuses and benefits.
• Comprehensive benefits package including paid time off (holidays, vacation, sick and personal days), paid parental leave, and mental health services.

Location

Not specified.

Additional Information

Reasonable accommodations are available for individuals with disabilities to participate in the application or interview process, perform essential job functions, and receive other benefits in accordance with applicable law.