Ryan Specialty Group

Stop Loss Data Modeler

Ryan Specialty Group$112K — $140K *
US-AnywhereRemote in United States
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in finance, mathematics, statistics, economics, or 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 preferred.
  • Advanced Excel skills for complex workbooks and financial models.
  • Experience with AI tools for data analysis and modeling a strong plus.
  • Familiarity with data manipulation and analytics tools like SQL, Power BI, Tableau preferred.

Responsibilities

  • Build and enhance financial models for pricing and reporting of stop-loss and captive programs.
  • Translate collected data into actionable insights and assist with additional data management.
  • Automate Excel-based tools to improve efficiency with AI applications.
  • Update rating templates and calculators used by the underwriting team.
  • Perform quality checks on financial model outputs and validate against source data.
  • Track cost drivers and trends across stop-loss and captive insurance metrics.
  • Collaborate with various teams to gather requirements for financial tools and reports.

Benefits

  • Paid time off for holidays, vacation, sick and personal days.
  • Paid parental leave.
  • Access to mental health services.
  • Comprehensive health benefits that support physical and emotional well-being.
Full Job Description
Position Summary
This role is responsible for building, maintaining, and improving the financial tools and models that support pricing, rating, and reporting for our stop-loss, reinsurance, and captive programs. This role will collaborate with the actuarial and underwriting teams in support of our goals

What will your job entail?

Job 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

Education/Experience/Skills:
  • 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


How We Support Our Teammates

Ryan Specialty seeks to offer our employees a comprehensive and best-in-class benefits package that helps them - and their family members - achieve their physical, financial, and emotional well-being goals. In addition to paid time off for company holidays, vacation, sick and personal days, Ryan offers paid parental leave, mental health services and more.

The target salary range for this position is $112,000.00 - $140,000.00 annually.

The wage range for this role considers many factors, such as training, transferable skills, work experience, licensure and certification, business needs, and market demands. The pay range is subject to change and may be modified in the future. Full-time roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards, visit our website https://benefits.ryansg.com/.

About Ryan Specialty Group

Ryan Specialty Group (RSG) is a leading international specialty insurance organization that provides innovative solutions for brokers, agents and insurance carriers. The company was founded in 2010 by industry veteran Patrick G. Ryan, the founder and former Chairman and CEO of Aon Corporation. RSG?s mission is to provide the highest quality insurance products and services to its customers, delivered with unparalleled expertise and customer service. The company operates as a holding company with subsidiaries that offer a wide range of specialty insurance products and services.
Learn more about Ryan Specialty Group
Size
2,000 employees
Market Cap
$10.6 billion
Industry
Founded
2010

Similar Jobs

More Jobs at Ryan Specialty Group

More Finance & Insurance Jobs

Find similar Stop Loss Data Modeler jobs: