Lead Catastrophe Modeler – Analytics Specialist

Ledgebrook

. Model individual E&S property submissions using Moody’s RMS model to deliver timely loss metrics (AAL, PML) to underwriters .

Posted 11/4/2026full-timeRemote • United States, CanadaSenior💰 $130,000 - $180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in modeling E&S property submissions using Moody’s RMS and AIR Touchstone, with advanced skills in SQL, Power BI, and Python for data analysis and reporting. Capable of translating complex model outputs into actionable insights for stakeholders while ensuring data integrity and compliance with industry standards.

Highest-signal resume keywords

Moody’s RMS ModelingAdvanced SQLPower BI Dashboard DevelopmentData Analysis in P&C InsuranceAI Tool Integration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingCatastrophe ModelingAutomated Data ValidationExposure Data CleaningPortfolio Performance AnalysisAggregate Accumulation MonitoringTechnical Analysis PresentationLoss Metrics CalculationData Standards SettingFinancial Data Integration

Soft Skills

Excellent CommunicationAttention to DetailCuriositySelf-StarterAccountability

Tools & Technologies

Power BIPythonSQLExcelSnowflakeWorkdayPower QueryAI Tools

Industry Keywords

P&C InsuranceActuarial AnalysisAnalyticsFinance FunctionsReinsurance

Tech Stack

Tools & technologies

ERPPythonSnowflakeSQL

About the role

Key responsibilities & impact

Model individual E&S property submissions using Moody’s RMS model to deliver timely loss metrics (AAL, PML) to underwriters
Model and monitor aggregate accumulations by running the entire portfolio through catastrophe models to track tail values at risk and average annual losses
Clean and enhance submission exposure data, set data standards, and build automated validations
Develop and oversee automated CAT modeling pipelines from raw exposure data to modeled results
Develop dashboards and analyses in Power BI, Python, and SQL tracking exposure, accumulations, and portfolio performance across Property and Inland Marine
Collaborate with Capital Modeling, Finance, Actuarial, and Data Engineering on pricing, reinsurance, and capital decisions
Translate complex model output into actionable insights and present technical analysis to underwriters and executive stakeholders
Report to the Head of Property Pricing

Requirements

What you’ll need

At least five years experience analyzing P&C insurance data (e.g., policy, premium, claims, or submission metrics) in support of actuarial, analytics, or finance functions
Advanced SQL, Excel, and Power BI for investigation, data modeling, and reporting
Excellent communication and presentation skills to collaborate with stakeholders across the organization
Close attention to detail and the curiosity to trace complex data inconsistencies back to their source
Comfort integrating AI tools in day-to-day workflows to drive efficiencies
A self-starter who takes accountability, thrives in a fast-paced environment, and handles ambiguity well
Hands-on proficiency in RMS and/or AIR Touchstone
Familiarity with integrating data with finance/ERP systems (e.g., Workday)
Exposure to Snowflake, Python, Power Query, and/or AI tools that streamline day-to-day workflows
Must be authorized to work in the United States or Canada without current or future employer-sponsored work authorization

Benefits

Comp & perks

Full remote flexibility and asynchronous work culture
Unlimited PTO and fully paid sick leave
Comprehensive health benefits, including medical, dental, and vision coverage, plus HSA and FSA options
Additional financial protection and retirement benefits, including a 401(k), company-paid life insurance, and disability coverage
Equity incentive program