Self-Funded Insurance Analyst II

NFP Corp•Independence, OH

26d•$80,000 - $100,000

About The Position

The Self-Funded Insurance Analyst II reviews self-funded financial reports and provides comments to the Account Management team for monthly or quarterly discussions. The role manages claims and dependent audits, plan optimization and contribution differential analyses, develops self-funded renewal projections, assists with financial renewal summaries, prepares alternate funding options, and conducts stop-loss sensitivity analyses for self-insured clients. It also reviews client IBNR reserve analysis templates before actuarial review and proofreads exhibits created by Level 1 Analysts for accuracy, quality, and client readiness. The analyst updates Excel-based templates and models to improve reporting and renewal processes, stays current on market developments, trends, and regulations through educational activities, and attends client meetings as needed to review financial reports. The position requires maintaining confidentiality and HIPAA compliance, building relationships with carrier sales representatives and Account Management teams, and performing additional duties as assigned. Less than 10% travel is required. The role requires a four-year college or university degree, preferably in Finance, Statistics, or Mathematics, or six or more years of equivalent work experience. Candidates need 3–5 years of related experience or training with a carrier, consultant, or broker, strong Microsoft Excel skills, and must possess or obtain an Ohio Life and Health License within four months of employment. Microsoft Access, Power BI, and Power Query skills are preferred. The salary range is $80,000–$100,000, with possible performance-based incentives.

Requirements

Four-year college or university degree, or six or more years of equivalent work experience.
Three to five years of related experience and/or training with a carrier, consultant, or broker.
Strong Microsoft Excel skills.
Must possess or obtain the Ohio Life and Health License within four months of employment.
Critical-thinking skills, including the ability to use logic and reasoning to evaluate alternatives and approaches to problems.
Active-listening skills.
Strong presentation and speaking skills.
Project-management skills, including ownership through completion, complex problem solving, operational and quality-control analysis, technology design, and time management.
Ability to multitask, organize work, manage time, meet deadlines, and remain on schedule.
Ability to communicate financial issues clearly, concisely, and persuasively.
Ability to establish rapport, present information, and respond to questions from managers, clients, and coworkers.
Ability to work independently.
Strong communication and analytical skills.
Ability to sit at a desk or computer for long periods and lift and carry up to 10 pounds.

Nice To Haves

Degree in Finance, Statistics, or Mathematics.
Knowledge of benefits administration, healthcare reform, industry trends, and carrier products and services.
Microsoft Access skills.
Microsoft Power BI skills.
Microsoft Power Query skills.

Responsibilities

Review self-funded financial reports and provide comments to the Account Management team for monthly or quarterly discussions.
Manage claims audits, dependent audits, and plan optimization and contribution differential analysis processes.
Develop self-funded renewal projections, assist with financial renewal summaries, and prepare alternate funding options.
Prepare stop-loss sensitivity analyses for self-insured clients.
Review client IBNR reserve analysis templates before actuarial review.
Proofread Level 1 Analyst exhibits for mathematical, formulaic, spelling, grammatical, and branding errors, and ensure they are client-ready.
Update Excel-based templates and models to improve reporting or renewal processes.
Attend seminars or educational activities to stay current on market developments, trends, and regulations.
Attend client meetings as needed to review financial reports.
Maintain confidentiality and HIPAA compliance with client information.
Build and maintain relationships with carrier sales representatives and Account Management teams.
Perform additional duties as assigned.
Obtain or possess an Ohio Life and Health License within four months of employment.