Role Summary

HIGHLIGHTS

Associate-level financial analyst role focused on employee health benefits in Indianapolis. You will build financial reporting, prepare renewal projections and cost modeling, and use predictive modeling and Tableau to support client services. Hybrid role (onsite ~3–4 days/week) at a benefits consulting firm.

JOB DESCRIPTION SUMMARY

Build branded monthly, quarterly, and annual financial reporting using predictive models
Prepare renewal projections, cost modeling, and contribution scenarios
Use internal claims data and predictive modeling software to analyze plan performance
Create ad-hoc reporting and dashboards in Tableau
Hybrid role — typically 3–4 days per week onsite in Indianapolis

DOMAIN EXPERTISE

Employee benefits cost modeling
Claims data analysis and predictive modeling
Fully insured vs self-funded analysis

KEY REQUIREMENTS

Bachelor's degree required
Proficient in Excel
Ability to handle confidential Personal Health Information (PHI)
Comfortable creating presentations and client-facing reports
Ability to travel to corporate office and client locations

TECH STACK

Excel
Tableau
PowerPoint

Role Summary

HIGHLIGHTS

JOB DESCRIPTION SUMMARY

Build branded monthly, quarterly, and annual financial reporting using predictive models
Prepare renewal projections, cost modeling, and contribution scenarios
Use internal claims data and predictive modeling software to analyze plan performance
Create ad-hoc reporting and dashboards in Tableau
Hybrid role — typically 3–4 days per week onsite in Indianapolis