Stop Loss Data Modeler

Overview

This role is responsible for building, maintaining, and improving financial tools and models that support pricing, rating, and reporting for stop-loss, reinsurance, and captive insurance programs. The position involves collaboration with actuarial and underwriting teams to support organizational goals.

Responsibilities

• Build, maintain, and enhance financial models and analytical tools for actuarial pricing, manual rating, and reporting related to stop-loss, reinsurance, and captive programs
• Translate collected data into actionable initiatives and assist with the development, collection, organization, and reporting of additional meaningful data
• Support automation and standardization of Excel-based tools, including applying AI to accelerate calculations, quality checks, and data organization
• Update and maintain rating templates and rate calculators used by underwriting for new and renewal business
• Perform quality checks and validate financial model outputs against source data
• Track 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 senior actuarial leadership
• Maintain and expand knowledge of healthcare reinsurance, stop-loss, and captive insurance concepts

Requirements

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

Compensation & Benefits

• Target salary range: $112,000 - $140,000 annually
• Salary range considers factors such as training, transferable skills, work experience, licensure, certification, business needs, and market demands
• Full-time roles are eligible for bonuses and benefits
• Comprehensive benefits package including paid time off for holidays, vacation, sick and personal days, paid parental leave, and mental health services
• Reasonable accommodations are provided for individuals with disabilities throughout the application and employment process

Location

Not specified

This job description is intended to outline general requirements and is not exhaustive. Duties and responsibilities may be assigned or reassigned at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.