Apply on Employer Site

Hilb Group · 2 months ago

Benefit & Data Analyst

United States

Full-time

Remote

Entry Level

1+ years exp

Hilb Group is a company that values its associates and promotes a service-driven culture. They are currently seeking a motivated Benefit & Data Analyst to develop and analyze benefits claims reports, propose plan design changes, and maintain data integrity within the agency management system.

Customer ServiceFinancial ServicesInsurance

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

Qualification

Data AnalyticsEmployee Benefit plansMS ExcelVBASQLPythonCommunication skillsPresentation skillsOrganizational skills

Required

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 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 willingness to obtain license within 120 days of hire

Preferred

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.

Company

Hilb Group

Partners Together - Endless Possibilities Hilb Group provides the resources of a big insurance broker and the attentive, personal service of a small agency.

Founded in 2009

Richmond, Virginia, USA

1001-5000 employees