Senior Large-Group Benefits Data Analyst | Flexible & Bonus

Kapnick Insurance; Ann Arbor (MI); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Team-based approach

Flexible schedule

Full benefits package

11 paid holidays including birthday

Competitive salary

Profit sharing

Bonus potential

Caring workplace culture

Job summary

Kapnick Insurance is seeking a Large Group Benefit Analyst to transform claims data into strategic insight for large employer clients in Michigan. You will lead client meetings, explain trends, and influence benefit design and renewal outcomes.

You’ll partner with executives to deliver detailed analyses, build dashboards, and provide actionable recommendations across fully insured, self-funded, and other funding arrangements. A collaborative, growth-oriented culture awaits.

Qualifications

• Bachelor’s degree in Mathematics, Finance, Business, Economics, or a related field preferred.
• 5-7 years of experience in employee group benefits, with experience supporting large group clients.
• Strong understanding of medical claims data, funding arrangements, renewals, and carrier underwriting.
• Demonstrated experience working in claims analysis and reporting tools, with the ability to interpret and explain data to non-technical audiences.
• Advanced computer skills in Microsoft Excel, Outlook, Word, and PowerPoint.
• Familiarity with carrier underwriting tools (employee benefits) and agency management systems preferred.
• Ability to manage multiple priorities, meet deadlines, and work effectively in a client-facing environment.

Responsibilities

• Participate in client-facing meetings, including renewal reviews, claims reviews, and strategic planning discussions.
• Partner with Client Executives to present and explain claims experience, utilization trends, and financial drivers in a clear and professional manner.
• Serve as an analytical resource for clients and internal teams, responding to questions related to claims performance, plan design, and cost containment strategies.
• Support large employer groups (typically 100+ lives) across a variety of funding arrangements, including fully insured, self-funded, level‑funded, reference-based pricing (RBP), and alternative solutions such as direct primary care (DPC).

Skills

Claims analysis

Reporting tools

Funding arrangements

Data storytelling

Client presenting

Attention to detail

Education

Bachelor’s degree in Mathematics, Finance, Business, Economics, or related field

Tools

Excel

Outlook

Word

PowerPoint

Analytics platforms

Job description

Kapnick Insurance is seeking a Large Group Benefit Analyst to transform claims data into strategic insight for large employer clients in Michigan. You will lead client meetings, explain trends, and influence benefit design and renewal outcomes.

You’ll partner with executives to deliver detailed analyses, build dashboards, and provide actionable recommendations across fully insured, self-funded, and other funding arrangements. A collaborative, growth-oriented culture awaits.