Senior Stop-Loss Modeling & Analytics Engineer

Ryan Specialty; United States; Remote; USD 112,000 - 140,000; Full time

Benefits offered by this job

Bonus eligibility

Benefits package

Job summary

Ryan Specialty seeks a skilled professional to build and enhance financial models supporting pricing, rating, and reporting for stop-loss, reinsurance, and captive programs. You will collaborate with actuarial and underwriting teams to drive data-driven decisions and automation.

The role emphasizes advanced Excel, data analytics, and AI tools to streamline calculations, ensure data quality, and support portfolio-level insights. Collaboration and documentation are key to success in this team.

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, or captive insurance knowledge preferred.
• Advanced Excel with complex models; AI tools experience valued.

Responsibilities

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

Skills

Advanced Excel

AI tools

SQL

Power BI

Tableau

Attention to detail

Interpersonal skills

Time management

Education

Bachelor’s degree in finance, mathematics, statistics, economics, or related field

Tools

Power BI

Tableau

SQL

Job description

Ryan Specialty seeks a skilled professional to build and enhance financial models supporting pricing, rating, and reporting for stop-loss, reinsurance, and captive programs. You will collaborate with actuarial and underwriting teams to drive data-driven decisions and automation.

The role emphasizes advanced Excel, data analytics, and AI tools to streamline calculations, ensure data quality, and support portfolio-level insights. Collaboration and documentation are key to success in this team.