Benefit & Data Analyst
Hilb Group
full-time
Posted on:
Location Type: Remote
Location: Rhode Island • United States
Visit company websiteExplore more
About the role
- 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.
Requirements
- 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.
- Preferred 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!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ExcelVLOOKUPpivot tablesconditional formattingdata analysisfinancial modelingdata entryclaims analysisbenefits calculationsemployee benefits terminology
Soft Skills
attention to detailtime managementability to manage deadlinesadaptabilityproactive communicationorganizational skillsanalytical thinkingproblem-solvingteam supportwillingness to learn
Certifications
Life & Health Insurance license