Self-Funded Insurance Analyst II

NFP, an Aon company; Independence Township (OH); On-site; USD 80,000 - 100,000; Full time

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

• 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

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.

2589437