Self-Funded Insurance Analyst II

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

Benefits offered by this job

PTO

Paid holidays

401(k) with match

Health & wellness programs

Employee discount

Job summary

NFP is seeking a detail-oriented analyst to support self-funded health plans by reviewing financial reports, performing audits, and developing renewal projections.

The role involves collaboration with Account Management, carrier relationships, and client meetings to review financial performance.

Qualifications

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

Responsibilities

• Review self-funded, financial reports and provide comments to Account Management for monthly or 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 client IBNR reserve analysis templates prior to actuarial review.
• Proof exhibits created by Level 1 Analysts for errors and ensure client readiness.
• Update Excel-based templates/models to improve reporting and renewal processes.
• Attend seminars or educational activities to stay up-to-date on market developments and regulations.
• Attend client meetings on an as-needed basis to review financial reports.
• Maintain confidentiality and HIPAA compliance with client information.
• Build and maintain relationships with 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

Communication skills

Independence

Travel <10%

Education

Finance/Statistics/Mathematics degree

Tools

Microsoft Excel

Microsoft Access

Power BI

Power Query

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

• 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