Self-Funded Insurance Analytics Specialist

NFP, an Aon company

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

Competitive salary
PTO & paid holidays
401(k) with matching
Health & wellness programs

Job summary

NFP, an Aon company, seeks a diligent analyst to support self-funded programs and financial analyses. You will review reports, lead audits, and develop renewal projections to optimize funding options for clients.

The role requires strong Excel skills, experience with Power BI, and the ability to work independently while communicating effectively with Account Management teams. HIPAA compliance is essential.

Qualifications

  • Four-year college degree or higher; Finance/Statistics/Math preferred.
  • 3–5 years of related experience in carriers, consultants, or brokers.
  • Strong Microsoft Excel skills required; Access/Power BI/Power Query preferred.

Responsibilities

  • Review self-funded financial reports and provide comments for monthly/quarterly discussions.
  • Manage claims audit, dependent audit, and plan optimization/contribution differential analysis.
  • Develop self-funded renewal projections and assist in financial renewal summaries; prepare alternate funding options.
  • Prepare stop loss sensitivity analysis for self-insured clients.
  • Review IBNR reserve analysis templates prior to actuarial review.
  • Proof exhibits for accuracy and branding; ensure client readiness.
  • Update excel-based templates/models to improve reporting/renewal processes.
  • Attend seminars to stay updated on market trends and regulations.
  • Attend client meetings to review financial reports as needed.
  • Maintain confidentiality and HIPAA compliance.

Skills

Critical Thinking
Active Listening
Presentation Skills
Project Management
Multi-Tasking
Communication
Analytical Skills
Independence

Education

Finance/Statistics/Math degree
Ohio Life & Health License

Tools

Excel
Access
Power BI
Power Query

Job description

NFP, an Aon company, seeks a diligent analyst to support self-funded programs and financial analyses. You will review reports, lead audits, and develop renewal projections to optimize funding options for clients.

The role requires strong Excel skills, experience with Power BI, and the ability to work independently while communicating effectively with Account Management teams. HIPAA compliance is essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Self-Funded Insurance Analyst - Renewal & Forecasting
Self-Funded Insurance Analyst - Renewal & Forecasting

Aon plc • Independence Township (OH)

On-site
USD 80,000 - 100,000
PTO & paid holidays
401(k) with match
Health & wellness programs
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
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
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)

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
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
Employee Benefits Analytics & Financial Modeling Analyst
Employee Benefits Analytics & Financial Modeling Analyst

Aon plc • Charlotte (NC)

On-site
USD 70,000 - 90,000
Employee Benefits Financial Analyst - Client-Focused
Employee Benefits Financial Analyst - Client-Focused

NFP • Charlotte (NC)

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