Job Posting Title Self-Funded Insurance Analyst II

Aon plc; Ohio; On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

PTO and paid holidays

401(k) with match

Health & wellness programs

Discount programs

Job summary

NFP in Ohio is seeking a skilled analyst to review self-funded financial reports and advise Account Management on monthly and quarterly discussions.

You will manage audits, develop renewal projections, prepare funding options, and perform stop loss sensitivity analyses while maintaining HIPAA confidentiality and strong client relationships.

Qualifications

• Four-year college degree; finance, statistics or math preferred.
• 3–5 years of related experience in benefits, consulting or brokerage.
• Strong Microsoft Excel skills required.
• Power BI and Power Query experience preferred; Access helpful.

Responsibilities

• Review self-funded financial reports and provide comments for Account Management discussions.
• Manage claims audits, dependent audits, and plan optimization analyses.
• Develop self-funded renewal projections and assist in preparing financial renewal summaries.
• Prepare stop loss sensitivity analyses for self-insured clients.
• Review IBNR reserve analysis templates prior to actuarial review.
• Proof exhibits for errors and ensure client readiness.
• Update Excel-based templates/models to improve reporting and renewal processes.
• Attend client meetings to review financial reports.
• Maintain confidentiality and HIPAA compliance with client information.
• Build and maintain relationships between carrier sales and Account Management teams.
• Additional duties as assigned.

Skills

Critical thinking

Active listening

Presentation skills

Project management

Multi-tasking

Benefits administration

Financial communication

Interpersonal skills

Independent worker

Analytical skills

Travel <10%

Education

Bachelor's degree in Finance/Statistics/Mathematics

6+ years of equivalent work experience

3-5 years related experience

MS Excel skills

Power BI and Power Query skills

Tools

Microsoft Access

Power BI

Power Query

Microsoft Excel

Job description

Posting Description

Essential Duties and Responsibilities:

• Review self-funded, financial reports and provide comments to Account Management team for monthly or quarterly discussions
• Mange claims audit, dependent audit, and plan optimization/contribution differential analysis process
• Develops 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
• Attends 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

Knowledge, Skills, and/or Abilities:

• Critical Thinking – Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems
• Active Listening – Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times
• Strong Presentation/Speaking Skills – Effectively communicating with others in an individual or group environment to articulate the items or information needed
• Project Management – Taking ownership of the project and seeing it through to completion through complex problem solving, operational analysis, quality control analysis, technology design, and exceptional time management
• Multi-Tasking – Efficiently organize work and manage time in order to meet deadlines and remain on task with designated timelines
• Knowledge of benefits administration, healthcare reform, industry trends, carrier products and services preferred
• Ability to correspond on all financial issues in a clear, concise and persuasive manner
• Ability to effectively establish rapport, present information and respond to questions from managers, clients and coworkers
• Ability to work independently
• Strong Communication and analytical skills
• Less than 10% travel required

Education and/or Experience:

• Four‑year college or university degree. Finance/Statistics/Mathematics is 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

Certificates, licenses, registration

• Employees required to possess or obtain the Ohio Life and Health License within 4 months of employment.
• Ongoing Education: CE Requirements

Physical demand The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Ability to sit at a desk or computer for long periods of time
• Must be able to lift and carry up to 10 pounds

What We Offer: We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others. The base salary range for this position is $80,000.00 - $100,000.00. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case‑by‑case basis. In addition to the base salary, this position may be eligible for performance‑based incentives.

NFP and You... Better Together!

NFP is an inclusive Equal Employment Opportunity employer.

#LI-NG1