OpeningsFirst
How it worksPricingLog in
OpeningsFirst › Jobs in the United States › Jobs in Kansas City, Missouri › Data / BI Analyst jobs in Kansas City, Missouri

Benefits Analyst

Search · lockton.com
Kansas CityEntry level0–3 yrs
Apply on Search’s site
Posted 1 month ago. 14 more Data / BI Analyst jobs in Kansas City, Missouri went up on company career pages this week. See the newer ones

Share this job on LinkedIn · X

Straight from the company’s own careers site.

The job in short

ICHRA benefits data analysis and financial modeling for employer health plans.

Excel

Details

Found
45 d ago · posted 2026-10-04
Location
MO-Kansas City

Full description

Job Description: Associate – ICHRA Analyst (Non-Exempt) Position Summary The Associate – ICHRA Analyst will play a key role in supporting the development and expansion of Lockton’s Individual Coverage Health Reimbursement Arrangement (ICHRA) practice. This position partners closely with internal Subject Matter Experts, producers, and client service teams to deliver data-driven insights, financial modeling, and market analysis that inform client strategy and decision-making. This is a non-exempt, salaried role requiring the following focus areas: Key Responsibilities ICHRA Analytics (Approx. 85%) • Analyze and manipulate large census datasets to support ICHRA feasibility assessments and modeling • Conduct local market analysis, including individual health plan pricing, carrier options, and plan design comparisons • Develop financial models to evaluate employer contributions, employee affordability, and enrollment scenarios • Track and maintain state-level pricing updates, marketplace dynamics, and renewal trends • Perform benchmarking analysis on employer contribution strategies and enrollment patterns • Identify trends across employer segments and provide insights to guide strategy development • Support onboarding and implementation activities, including coordination with internal and external stakeholders Client Services Support (Approx. 15%) • Support ongoing client service delivery within assigned accounts, including issue resolution and data analysis • Assist in development of client deliverables, presentations, and reporting materials • Collaborate with producers and account teams to support client strategy discussions • Ensure accuracy and quality of data used in client-facing materials • Contribute to continuous improvement of processes and tools within the Client Services team Qualifications Required • Bachelor’s degree in Business, Finance, Economics, Healthcare Administration, Or relevant experience • 0–3 years of experience in employee benefits, healthcare consulting, financial analysis, or related analytical role • Strong analytical and quantitative skills with experience working with data sets • Proficiency in Excel (modeling, pivot tables, data manipulation) • Ability to synthesize complex information into clear, actionable insights • Strong organizational skills with ability to manage multiple priorities Core Competencies • Analytical thinking and problem-solving • Attention to detail and data accuracy • Communication skills (written and verbal) • Adaptability in a growing and evolving practice area • Initiative and intellectual curiosity Role Expectations • Exercises independent judgment in analyzing data and developing recommendations • Works on complex and non-routine assignments requiring discretion and critical thinking • Operates with limited supervision while managing deliverables and deadlines • Contributes to the development of tools, methodologies, and best practices as the ICHRA practice scales Why Join This Role • Gain deep exposure to a rapidly growing, strategic area of employee benefits • Build highly marketable technical and analytical skills • Work directly with producers, subject matter experts, and leadership • Help shape and grow an emerging practice within Lockton Reporting Relationship Reports to: Casey Hanneman, Unit Leader Works directly with and will be trained by: Jackson Lee, ICHRA Specialist

Data / BI Analyst jobs in the United States · All Search jobs · Entry-level jobs in Kansas City, Missouri

Get jobs like this every morning

Jobs in India · Jobs in the US · Who’s hiring in India · Who’s hiring in the US · Browse all jobs · Companies · How OpeningsFirst works · Free jobs widget · Leadership jobs in India · Leadership jobs in the US · Senior jobs in India · Senior jobs in the US · Fresher jobs in India · Entry-level jobs in the US · Remote jobs in the US · Jobs paying $150k+ · Leadership hiring this week · Guides
OpeningsFirst · Use with AI · Terms · Privacy · Refunds · Contact · Follow us on LinkedIn · X