Job description
Overview:
This position will report to our agency located in Fairfield, CT. The ideal candidate will be motivated to succeed, is well organized, able to prioritize, and able to work well with a team. This is an in-office position for the first 4 months, then will move to a hybrid schedule.
Grow With Us!
The Hilb Group is currently seeking a motivated and ambitious Benefits Data Analyst to join our team. This is an exciting opportunity to build relationships and service our benefits customers.
This position will report to our agency located in Fairfield, CT. The ideal candidate will be motivated to succeed, is well organized, able to prioritize, and able to work well with a team. This is an in-office position for the first 4 months, then will move to a hybrid schedule.
Responsibilities:
- 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.
- 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 the ability to function as a benefit expert, reviewing and analyzing unique situations and recommending appropriate action to Consultants and Producers
- Proactively identify issues within data or client analyses and develop innovative solutions.
- Maintain data integrity of account and plan information in agency management system (BenefitPoint)
- Analyze Salesforce and Risk Match data to provide meaningful insights helpful to cross sell employee benefits and property and casualty business.
- All other duties as assigned.
Qualifications:
- Associate’s degree required; Bachelor’s degree in Data Analytics, Mathematics, Statistics, or other related/ analytical degree or related discipline
- Minimum of 1-2 years’ experience preferred.
- Working knowledge of Employee Benefit plansStrong computer skills, primarily with MS Excel, Access, PowerPoint, and Word
- License in Life and Health required or willingness to obtain license within 120 days of hire.
- Knowledge of or experience with VBA, Sql, or Python is a plus.
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.
caravetterealestate.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caravetterealestate.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, caravetterealestate.com is the ideal place to find your next job.