Self-Funded Insurance Analyst - Renewal & Forecasting

Aon plc

Independence Township (OH)

On-site

USD 80,000 - 100,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

PTO & paid holidays
401(k) with match
Health & wellness programs

Job summary

NFP is seeking a detail-oriented professional in Ohio to support self-funded healthcare programs. You will review financial reports, assist with audits and renewal projections, and prepare funding options for client discussions.

Strong Excel and data-analytic skills are essential. The role involves attending client meetings, maintaining HIPAA compliance, and partnering with Account Management and carrier teams.

Qualifications

  • Four-year college degree; Finance/Statistics/Mathematics preferred or 6+ years of equivalent work experience.
  • 3‑5 years of related experience and/or training with a carrier, consultant or broker
  • Strong Microsoft Excel skills required
  • Microsoft Access and Microsoft Power BI and Power Query skills preferred

Responsibilities

  • Review self-funded, financial reports and provide comments to Account Management team for monthly or quarterly discussions.
  • Manage claims audit, dependent audit, and plan optimization/contribution differential analysis process
  • Develop self-funded renewal projections, assist in the preparation of financial renewal summary, prepare alternate funding options
  • Prepare stop loss sensitivity analysis for self‑insured clients
  • Review client IBNR reserve analysis templates prior to actuarial review
  • Proof exhibits created by Level 1 Analysts for mathematical, formulaic, spelling, grammatical and branding errors and ensure they are client ready
  • Update excel-based templates/models to improve the reporting or renewal process
  • Attend seminars or educational activities to stay up-to-date on the latest developments, trends and regulations in the market place
  • Attend client meetings on an as-needed basis to review financial reports
  • Maintain confidentiality and HIPAA compliance with all client information obtained in the course of work.
  • Build and maintain solid relationships carrier sales representatives and Account Management teams
  • Additional duties as assigned

Skills

Critical Thinking
Active Listening
Presentation Skills
Project Management
Multi-Tasking
Benefits administration knowledge
Financial communication
Relationship building
Independent work
Analytical skills

Education

Four-year college degree; Finance/Statistics/Mathematics preferred
3-5 years related experience in carrier/consultant/broker
Strong Microsoft Excel skills
MS Access, Power BI, Power Query preferred

Tools

Microsoft Access
Power BI
Power Query
Microsoft Excel

Job description

NFP is seeking a detail-oriented professional in Ohio to support self-funded healthcare programs. You will review financial reports, assist with audits and renewal projections, and prepare funding options for client discussions.

Strong Excel and data-analytic skills are essential. The role involves attending client meetings, maintaining HIPAA compliance, and partnering with Account Management and carrier teams.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Self-Funded Insurance Analytics Specialist
Self-Funded Insurance Analytics Specialist

NFP, an Aon company • Independence Township (OH)

On-site
USD 80,000 - 100,000
Competitive salary
PTO & paid holidays
401(k) with matching
+1
Self-Funded Insurance Analyst II
Self-Funded Insurance Analyst II

NFP, an Aon company • Independence Township (OH)

On-site
USD 80,000 - 100,000
Competitive salary
PTO & paid holidays
401(k) with matching
+1
Job Posting Title Self-Funded Insurance Analyst II
Job Posting Title Self-Funded Insurance Analyst II

NFP • Ohio

On-site
USD 80,000 - 100,000
PTO and paid holidays
401(k) with match
Health & wellness programs
+1
Self-Funded Insurance Analyst II
Self-Funded Insurance Analyst II

Aon plc • Independence Township (OH)

On-site
USD 80,000 - 100,000
PTO & paid holidays
401(k) with match
Health & wellness programs
Self-Funded Insurance Analyst II
Self-Funded Insurance Analyst II

Aon plc • Ohio

On-site
USD 80,000 - 100,000
PTO
Paid holidays
401(k) with match
+2
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

NFP, an Aon company • Charlotte (NC)

On-site
USD 70,000 - 90,000
Competitive salary
PTO & paid holidays
401(k) with match
+1
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

Aon plc • Charlotte (NC)

On-site
USD 70,000 - 90,000
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

NFP • Charlotte (NC)

On-site
USD 70,000 - 90,000
PTO and paid holidays
401(k) with match
Health & wellness programs
Business Data Analyst II
Business Data Analyst II

Alliant Insurance Services • Omaha (NE)

On-site
USD 55,000 - 75,000
Business Data Analyst
Business Data Analyst

Senior Market Sales • Omaha (NE)

On-site
USD 55,000 - 90,000