Self-Funded Benefits Analyst
About The Position
ESSENTIAL DUTIES AND RESPONSIBILITIES Data Management Create and implement strategies and standards to improve data warehousing and reporting processes. Manage and monitor data collection procedures across clients, vendors, and team members. Facilitate data exchanges between carriers and vendors. Create and execute data validation and auditing practices to ensure data quality. Analysis Organize and sort complex datasets. Analyze and interpret trends using statistical and visualization tools (Excel, Microsoft Power BI, R Studio, Python, etc.) Conduct health plan analytics, including: Claims utilization, trend, and lag analyses Rate and contribution analysis Financial funding analysis Renewal rate and funding projections and modeling Benchmarking IBNR reporting Utilize analytical tools to develop alternative strategies, plan modeling, and cost reduction opportunities. Perform technical analysis of group insurance contracts and financial arrangements. Communicate requirements with clients and other team members. Reporting Translate analysis into clear and compelling dashboards, presentations, and reports. Assist in the development of actionable, non-technical recommendations based on analytical insights. Prepare ad hoc reports for client teams and clients. Meet with clients to discuss quantitative reports. Perform other tasks as assigned by management. EDUCATION AND/OR EXPERIENCE Bachelor's degree in a related field. 5+ years of related experience in self-funded data analytics and plan design. Equivalent combination of education and experience.
Requirements
- Bachelor's degree in a related field.
- 5+ years of related experience in self-funded data analytics and plan design.
- Equivalent combination of education and experience.
Responsibilities
- Create and implement strategies and standards to improve data warehousing and reporting processes.
- Manage and monitor data collection procedures across clients, vendors, and team members.
- Facilitate data exchanges between carriers and vendors.
- Create and execute data validation and auditing practices to ensure data quality.
- Organize and sort complex datasets.
- Analyze and interpret trends using statistical and visualization tools (Excel, Microsoft Power BI, R Studio, Python, etc.)
- Conduct health plan analytics, including: Claims utilization, trend, and lag analyses Rate and contribution analysis Financial funding analysis Renewal rate and funding projections and modeling Benchmarking IBNR reporting
- Utilize analytical tools to develop alternative strategies, plan modeling, and cost reduction opportunities.
- Perform technical analysis of group insurance contracts and financial arrangements.
- Communicate requirements with clients and other team members.
- Translate analysis into clear and compelling dashboards, presentations, and reports.
- Assist in the development of actionable, non-technical recommendations based on analytical insights.
- Prepare ad hoc reports for client teams and clients.
- Meet with clients to discuss quantitative reports.
- Perform other tasks as assigned by management.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
1,001-5,000 employees
