Avatar for Stephens
Financial services for companies, governments, institutions, and investors

Employee Benefits Data Analyst

Posted: 1 year ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
Data Warehousing
Excel
R Studio
Data Validation
Benchmarking
Data Management
Microsoft Power BI
Statistical tools
Visualization Tools
Analytical tools
Data Collection Procedures
Data Exchanges
Financial Funding Analysis
Renewal Rate Projections
IBNR Reporting

About the job

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.