Remote Stop-Loss Data Modeler

RT Specialty, LLC; United States; On-site; USD 112,000 - 140,000; Full time

Benefits offered by this job

Paid time off

Paid parental leave

Mental health services

Job summary

Ryan Specialty is seeking a Stop Loss Data Modeler to build, maintain, and improve financial tools for pricing, rating, and reporting across stop-loss, reinsurance, and captive programs. You will partner with actuarial and underwriting teams to deliver robust models and insights.

The role requires a Bachelor's in finance, math, or economics, 5 years of modeling experience, advanced Excel, and familiarity with SQL, Power BI, and Tableau.

Qualifications

• Bachelor's degree in finance, mathematics, statistics, economics, or related field.
• 5+ years of relevant experience in financial modeling, data analysis, or similar function.
• Advanced Excel skills with complex workbooks and models.

Responsibilities

• Build, maintain, and improve financial models and analytical tools supporting actuarial pricing, manual rating, and reporting for stop-loss, reinsurance, and captive programs.
• Translate data into usable initiatives and assist with data collection, organization, and reporting.
• Automate and standardize Excel-based tools, including AI to speed up calculations, quality checks, and data organization.
• Update rating templates and rate calculators used by underwriting for new and renewal business.
• Perform quality checks and validate outputs of financial models against source data.
• 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 knowledge of healthcare reinsurance, stop-loss, and captive concepts.

Skills

Attention to detail

Written and verbal communication

Team collaboration

Education

Bachelor's degree in finance/mathematics/statistics/economics

Tools

SQL

Power BI

Tableau

Excel (Advanced)

Job description

Ryan Specialty is seeking a Stop Loss Data Modeler to build, maintain, and improve financial tools for pricing, rating, and reporting across stop-loss, reinsurance, and captive programs. You will partner with actuarial and underwriting teams to deliver robust models and insights.

The role requires a Bachelor's in finance, math, or economics, 5 years of modeling experience, advanced Excel, and familiarity with SQL, Power BI, and Tableau.