[Remote] Stop Loss Data Modeler
Note: The job is a remote job and is open to candidates in USA. Ryan Specialty is a company focused on providing innovative insurance solutions, and they are seeking a Stop Loss Data Modeler. This role is responsible for building and maintaining financial models that support pricing and reporting for stop-loss and reinsurance programs, collaborating closely with actuarial and underwriting teams.
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
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
- Advanced Excel skills, with experience building and maintaining complex workbooks, financial models, and related analytical tools
- 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
- Background in healthcare reinsurance, stop-loss, and/or captive insurance strongly preferred
- Familiarity with data manipulation and analytics tools (e.g., SQL, Power BI, Tableau) a plus
- Experience using AI tools (e.g., Claude, ChatGPT) to support data analysis, modeling, or process improvement will be heavily weighted
Benefits
- Paid time off for company holidays, vacation, sick and personal days
- Paid parental leave
- Mental health services
- Full-time roles are eligible for bonuses and benefits
Company Overview
Company H1B Sponsorship