Self-Funded Insurance Analyst II
Core
Analyze self-funded insurance financial reports, manage claims and dependent audits, and develop renewal projections and funding options for self-insured clients.
Role type
Senior self-funded insurance analyst
Builds
Financial renewal summaries, stop loss sensitivity analyses, and client-ready exhibits
Domain
Insurance / Healthcare finance
Deliverable
dashboards & analysis
Required skills
Financial reporting, claims audit, dependent audit, plan optimization, renewal projections, stop loss analysis, IBNR reserve review, Excel modeling, regulatory compliance
Preferred skills
Benefits administration, healthcare reform trends, carrier products, Microsoft Access, Power BI, Power Query, Ohio Life and Health License
Technologies
Microsoft Excel, Microsoft Access, Microsoft Power BI, Power Query
Responsibilities
Review self-funded financial reports and provide comments to Account Management, manage claims and dependent audits, develop self-funded renewal projections and alternate funding options, prepare stop loss sensitivity analysis, review client IBNR reserve analysis templates, proof exhibits for accuracy and branding, update Excel templates/models, attend client meetings to review financial reports
Seniority
Mid-Senior, hands-on IC