Stop-Loss Modeling & Analytics Architect

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

Benefits offered by this job

Bonuses

Benefits package

Job summary

Ryan Specialty is seeking a skilled financial modeling professional to build, maintain, and improve tools and models that support pricing, rating, and reporting for stop-loss, reinsurance, and captive programs. You will collaborate with actuarial and underwriting teams to drive analytics and operational efficiency.

The role emphasizes advanced Excel usage, AI-assisted data analysis, and data integration across SQL, Power BI, and Tableau to produce reliable outputs for senior actuarial staff

Qualifications

• Bachelor's degree in finance, mathematics, statistics, economics, or a related field.
• 5 years of relevant experience in financial modeling, data analysis, or a similar function.
• Background in healthcare reinsurance, stop-loss, and/or captive insurance strongly preferred.
• Advanced Excel skills, with experience building and maintaining complex workbooks, financial models, and related analytical tools.
• Experience using AI tools (e.g., Claude, ChatGPT) to support data analysis, modeling, or process improvement will be heavily weighted.
• Familiarity with data manipulation and analytics tools (e.g., SQL, Power BI, Tableau) a plus.
• Strong attention to detail and accuracy.
• Strong interpersonal skills (written and verbal).
• Committed team player, comfortable supporting senior actuarial staff as needed.
• Ability to manage multiple priorities and work independently.

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 the data currently being collected into usable and actionable initiatives, and assist with the development, collection, organization, and reporting of additional data meaningful for the firm
• Support initiatives to automate and standardize Excel-based tools, including the application of AI to speed up calculations, quality checks, and data organization
• Update and maintain rating templates and rate calculators used by the underwriting team for new and renewal business
• Perform quality checks and validate the 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 and analyses for the Chief Actuary and Actuarial Directors
• Maintain and expand working knowledge of healthcare reinsurance, stop-loss, and captive insurance concepts

Skills

Advanced Excel

AI tools

SQL

Power BI

Tableau

Attention to detail

Interpersonal skills

Team player

Multitasking

Independent worker

Education

Bachelor's degree in finance or related field

Tools

SQL

Power BI

Tableau

Job description

Ryan Specialty is seeking a skilled financial modeling professional to build, maintain, and improve tools and models that support pricing, rating, and reporting for stop-loss, reinsurance, and captive programs. You will collaborate with actuarial and underwriting teams to drive analytics and operational efficiency.

The role emphasizes advanced Excel usage, AI-assisted data analysis, and data integration across SQL, Power BI, and Tableau to produce reliable outputs for senior actuarial staff