Data Analytics Senior Associate

Hilb Group • Hunt Valley, MD

14h • Onsite

About The Position

The Hilb Group is seeking a motivated and ambitious Data Analytics Senior Associate to join their team at the Hunt Valley, MD agency. The company, founded in 2009, is a Top 25 middle-market independent insurance broker specializing in property & casualty, employee benefits, human resources consulting, and retirement services. They emphasize a service-driven culture that promotes career and professional development. The ideal candidate will be motivated, well-organized, able to prioritize, and work well in a team, in an in-office setting. The Hilb Group prides itself on combining the resources of a large broker with the personal service of a small agency, driven by values of trust, passion, integrity, and growth.

Requirements

• Associate’s degree required
• Minimum of 2-3 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)

Nice To Haves

• Bachelor’s degree in Actuarial, Risk Management, Mathematics, Statistics, or other related/ analytical degree or related discipline
• Knowledge of or experience with VBA, Sql, or Python is a plus

Responsibilities

• Assist with the 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)

Benefits

• Compensation: $65,000-$75,000/yr.
• 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 include Critical Illness, Accident Insurance, Hospital Indemnity and Supplemental Life Insurance, Legal and Identity protection, and Pet benefits
• Generous PTO
• An awesome team of professionals!

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree
• Number of Employees: 501-1,000 employees