Skip to main content
Ryan Specialty

Stop Loss Data Modeler

RemoteUnited States only
Published
Role
Data Engineering
Experience
Senior
Employment
Full-time
$112k–$140k/yr
Check eligibility

Open to US only. Set where you work from to check your eligibility.

No BS summary

Senior financial/data modeller for stop-loss and reinsurance products. Needs ~5+ years building complex Excel financial models and working knowledge of healthcare reinsurance/stop-loss/captive insurance. Remote within the United States (US work authorization expected).

Core skills

Advanced Excelfinancial modeling

Required skills

data analysisSQLPower BITableauAI tools (Claude, ChatGPT)Excel (advanced)AI tools (Claude or ChatGPT)

Optional skills

SQLPower BITableau

What you'll do

  • 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

What they require

  • 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
  • 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)
  • Ability to manage multiple priorities and work independently
  • Experience using AI tools (e.g., Claude, ChatGPT) to support data analysis, modeling, or process improvement will be heavily weighted

Benefits

  • Comprehensive benefits package including paid time off for company holidays, vacation, sick and personal days
  • Paid parental leave
  • Mental health services
  • Eligibility for bonuses and benefits for full-time roles
  • Reasonable accommodations for individuals with disabilities
  • Paid time off for company holidays, vacation, sick and personal days
  • Eligible for bonuses and benefits
  • Comprehensive benefits package; see https://benefits.ryansg.com/

Ryan Specialty is a dynamic and fast-paced environment where innovation and collaboration drive our success. If you are a strategic thinker with a passion for driving results and fostering teamwork, we want to hear from you! • Ryan Alternative Risk, Credit Solutions, a division of Ryan Specialty, is a managing general underwriter focused on delivering innovative credit insurance solutions for institutional investors. We specialize in structuring and underwriting transactions across credit wraps, fund finance, NAV lending, structured credit enhancements, and other complex risk-transfer strategies. • Our team combines deep expertise in credit markets with a research-driven, team-oriented approach to underwriting. We partner with banks, asset managers, and insurers to create bespoke solutions that address evolving market needs. As part of the Ryan Specialty platform, we operate at the intersection of institutional scale and entrepreneurial agility, guided by a culture that values innovation, collaboration, and excellence.

HealthcareEnterprise
$112k–$140k/yr