Stop-Loss Modeling & Analytics Lead

Ryan Specialty, LLC

Colorado

Hybrid

USD 112,000 - 140,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Bonuses

Benefits

Job summary

Ryan Specialty, LLC is seeking a Senior Financial Modeling Analyst to design, build, and improve financial models and analytical tools supporting actuarial pricing, manual rating, and reporting for stop-loss, reinsurance, and captive programs. The role collaborates with actuarial and underwriting teams to meet strategic goals.

You will translate collected data into actionable initiatives, automate Excel tools using AI, and maintain rating templates for underwriting.

Qualifications

Bachelor's degree in finance, mathematics, statistics, economics, or related field.
5 years of relevant experience in financial modeling or data analysis.
Healthcare reinsurance/stop-loss/captive insurance background preferred.
Advanced Excel skills with complex workbooks and models.
Experience using AI tools (Claude, ChatGPT) for analysis.
Familiarity with SQL, Power BI, Tableau is a plus.
Strong attention to detail and communication skills.
Able to manage multiple priorities and work independently.

Responsibilities

Build, maintain, and improve financial models for actuarial pricing, rating, and reporting in stop-loss, reinsurance, and captive programs.
Translate data into actionable initiatives; assist in data collection, organization, and reporting.
Automate and standardize Excel-based tools; apply AI to speed calculations, quality checks, and data organization.
Update and maintain rating templates and rate calculators for underwriting teams.
Perform quality checks and validate outputs of financial models against source data.
Assist in tracking cost drivers, trends, and portfolio-level metrics across programs.
Collaborate with actuarial, underwriting, finance, and sales to gather tool requirements.
Prepare and maintain documentation for models, tools, and processes.
Support ad hoc data requests for Chief Actuary and Actuarial Directors.
Expand working knowledge of healthcare reinsurance concepts.