Logo for Ryan Specialty

Healthcare Insurance - Stop Loss Modeler

Role overview

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

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

Key facts

  • Remote from: United States
  • Full time
  • Senior (5-10 years)
  • English

Hard skills

Other skills

  • Microsoft Excel
  • Detail Oriented
  • Social Skills
  • Teamwork

About the company

Ryan Specialty logo

Ryan Specialty

Insurance

Ryan Specialty (NYSE: RYAN) is an international specialty insurance firm that provides distribution, underwriting, product development, administration and risk management services by acting as a wholesale broker and a managing underwriter. Our mission is to provide industry-leading innovative specialty insurance solutions for insurance brokers, agents and carriers. Ryan Specialty was founded in 2010 by Patrick G. Ryan, the widely respected insurance veteran, founder and former Chairman and CEO of Aon Corporation. Mr. Ryan saw the need in the marketplace for a specialty organization dedicated exclusively to creating sophisticated insurance solutions for risks that demand innovation, proven leadership, outstanding industry expertise and quality services on behalf of brokers, agents and carriers. For more information about Ryan Specialty, visit our website at ryansg.com.

Company details

Company typeLarge
IndustryInsurance
Company size1001 - 5000

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. Differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. This policy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment.

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/. 

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation at HR@Ryansg.com 

The above is intended to describe this job's general requirements. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. 

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Related jobs

Other jobs at Ryan Specialty

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.