Benefit Analyst

Experienced

JOB SUMMARY:

Reporting to the Manager, Benefit Analytics, the Benefit Analyst is responsible for assisting Account Executives and Benefit Consultants with the analysis of client and prospect employee plan data. This position functions as analytics expert regarding benefit plan marketing, renewal, and claims analysis. The Benefit Analyst is an active member of the PSA Benefits team and provides assistance on larger group clients (100+), working with self-funded and fully insured plans and/or with complex clients.

ESSENTIAL FUNCTIONS:

  • Assist with development of employee benefit plan design
  • Develop and review monthly and other periodic benefits claims reports, including analysis of claims and utilization costs and trends
  • Develop benefits claims and cost projections for fully- and self-insured plans
  • Develop loss ratio reports for fully-insured plans
  • Prepare benchmarking analyses and reports for clients and prospects
  • Prepare RFPs for benefit plan marketing
  • Manage vendor rate and plan design negotiations to meet clients’ benefit plan and budget goals
  • Propose recommended benefit plan design changes in support of clients’ benefits program goals
  • Prepare financial portions of client and prospect presentations, including executive summary, analysis results, and recommendations
  • Develop clients’ benefits budget and balance sheets, and maintain monthly or quarterly updates
  • Develop premium equivalents for self-insured plans
  • Manage vendor relationships, including preparing and analyzing vendor RFPs and RFIs
  • Prepare Healthcare Reform/ACA and other financial or claims analyses impacting the client’s benefits budget
  • Function as a benefit expert, reviewing and analyzing unique situations and recommending appropriate action to Consultants and Producers
  • Manage development and maintenance of best practice templates
  • Proactively identify issues within data or client analyses and develop innovative solutions
  • Coordinate and complete peer reviews of all work to be presented to a client
  • Assist with mentoring and training new hire Benefits Analysts
  • Maintain data integrity of account and plan information in agency management system (Benefit Point)

QUALIFICATIONS:

  • Associate’s degree required; Bachelor’s degree in Actuarial, Risk Management, Mathematics, Statistics, or other related/ analytical degree or related discipline
  • Minimum of 1-2 years experience preferred
  • Working knowledge of Employee Benefit plans
  • Demonstrated ability to analyze data and make appropriate recommendations
  • Demonstrated ability to independently organize and perform work activities and to simultaneously handle multiple complex projects
  • Demonstrated ability to communicate effectively, both verbally and in writing
  • Demonstrated ability to prepare and deliver presentations
  • Ability to plan work and lead and motivate others
  • Strong computer skills, primarily with MS Excel, Access, PowerPoint and Word
  • License in Life and Health required (or attained within 30 days from date of hire)
  • Knowledge of or experience with VBA, Sql, or Python is a plus.

PERSONAL ATTRIBUTES:

  • Problem-solver
  • Strategic thinker
  • Winning attitude – passionate
  • High energy, upbeat
  • Smart — intellectually curious
  • Strong mathematical, financial, and Excel acumen
  • Results oriented – make-it-happen sense of urgency
  • Ethical
  • Ability to think in multi-dimensional complex terms
  • Multi-tasking abilities
  • Organizational and time management skills
  • Ability to be “hands-on” and be tactical
  • Values relationships – a collaborator – team oriented
  • Ability to get into the details – involved in the business
  • Inspires trust
  • Listens and follows direction well
  • Ability to promote continuous improvement and drive efficiencies
  • Can be relied upon for consistent time and attendance