What are the responsibilities and job description for the Self-Funded Benefits Analyst position at Stephens Default?
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.