Stop Loss Data Modeler

Ryan Specialty

Building, maintaining, and improving financial tools and models for healthcare reinsurance pricing. Collaborating with actuarial and underwriting teams to support company goals.

Posted 7/27/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $112,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in financial modeling and data analysis, with advanced proficiency in Excel and familiarity with AI tools for process improvement. Possesses strong knowledge of healthcare reinsurance, stop-loss, and captive insurance concepts, along with the ability to collaborate effectively across teams.

Highest-signal resume keywords

Financial ModelingAdvanced Excel SkillsData AnalysisHealthcare Reinsurance KnowledgeAI Tools Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Financial ModelingData AnalysisExcelSQLPower BITableauData ManipulationAnalytical ToolsQuality ChecksReporting

Soft Skills

Attention to DetailInterpersonal SkillsTeam PlayerCommunication SkillsIndependent Work

Tools & Technologies

ExcelAI ToolsSQLPower BITableau

Industry Keywords

Healthcare ReinsuranceStop-LossCaptive InsuranceActuarial PricingManual Rating

Tech Stack

Tools & technologies

SQLTableau

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

Paid time off for company holidays, vacation, sick and personal days
Paid parental leave
Mental health services