Employee Benefits Data Analyst

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.