Benefit and Data Analyst

Overview:

This position will report to our agency located in Cranston, RI. The ideal candidate will be motivated to succeed, is well organized, able to prioritize, and able to work well with a team. This is a remote position.

Responsibilities:

• Assist the RFP team in meeting proposal timelines by organizing, analyzing, and preparing census data.
• Utilize Excel formulas for benefits calculations, including life volume rounding, tiered rate structures, and eligibility assessments.
• Ensure data accuracy and completeness in all submissions.
• Proactively pull claims reports from carrier websites based on published release schedules.
• Maintain tracking of monthly, quarterly, and annual claim performance reports to provide timely insights.
• Identify data trends and anomalies in medical, dental, and ancillary benefits claims.
• Perform monthly data entry related to ongoing medical claim performance, ensuring accuracy and consistency.
• Analyze client claims utilization, cost trends, and financial impact reports.
• Support the team with ad hoc reporting needs to assist client strategy.
• Learn and utilize benefits administration systems such as:
• Employee Navigator (enrollment & eligibility tracking)
• BenefitPoint (carrier and broker management system)
• ImageRight (document management)
• Adapt quickly to new software tools for data entry and reporting.
• Develop a strong understanding of employee benefits terminology to effectively interpret benefits data.
• Work towards obtaining a Life & Health Insurance license to expand knowledge and career development.
• Stay informed on industry regulations, trends, and compliance requirements affecting benefits data.

Qualifications:

• Strong proficiency in Microsoft Excel, including VLOOKUPs, pivot tables, conditional formatting, and complex formulas.
• Strong math skills for data validation, financial modeling, and claims analysis.
• Ability to manage tight deadlines and competing priorities in a fast-paced environment.
• Excellent attention to detail with a focus on accuracy in data processing.
• Willingness to learn employee benefits concepts and insurance-related terminology.
• Interest in obtaining Life & Health Insurance licensing certification within the first year of employment.
• Bachelor's degree in Mathematics, Business, Finance, Economics, or a related field (or equivalent work experience).

Benefits:

• Company Paid Life Insurance, Long-Term and Short-Term Disability.
• Medical, Dental, Vision and FSA/HSA plans.
• 401(k) with company match.
• Additional voluntary benefits including Critical Illness, Accident Insurance, Hospital Indemnity and Supplemental Life Insurance, Legal and Identity Protection, and Pet benefits.
• Generous PTO.
• An awesome team of professionals!

The Hilb Group is an equal opportunity employer, and we actively support and comply with all applicable federal, state, and local laws prohibiting all forms of discrimination in employment. Additionally, we have a zero-tolerance policy for all forms of harassment in violation of federal, state, and local laws.