Job Description
Benefits Analyst Job Duties:
· Work closely with firm principal
· Analyze datasets in Excel, including, but not limited to:
o Market review analysis
o Benchmark client benefits against industry standards
o Renewal rate and funding projections and modeling
o Analysis of claims utilization
o Create pivot tables and write conditional formulas
o Assist the accounting department in reconciling any commission shortages/overages by making internal accounting adjustments, contacting insurance carriers, etc. to determine the source of the problem
o Audit client data against carrier invoices
Benefits Analyst Skills and Qualifications:
· Candidate should exhibit exceptional analytical abilities and advanced Microsoft Office skills as well as a talent for good communication and time management.
· Candidate, in particular, should have a deep knowledge of Excel specific to creating, formatting, and evaluating formulas and working with pivot tables.
· The position requires an ability to work in a fast-paced environment with some oversight and a high degree of accuracy and attention to detail.