Employee Benefits Data Analyst at Stephens Insurance

ESSENTIAL DUTIES AND RESPONSIBILITIES  

• Data Management
  • Implement strategies and standards to improve data warehousing and reporting processes.
  • Manage 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.
• 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 data analytics, underwriting, and/or benefit design.
• Equivalent combination of education and experience.