Data Analytics Senior Associate

Grow With Us! At Hilb Group, we recognize that our associates are our greatest asset. We promote a service-driven culture of high performance that encourages career and professional development. The Hilb Group is currently seeking a motivated and ambitious Data Analytics Senior Associate to join our team. This position will report to our agency located in Hunt Valley, MD. 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. 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) Qualifications Associate’s degree required; Bachelor’s degree in Actuarial, Risk Management, Mathematics, Statistics, or other related/analytical degree or related discipline 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) Knowledge of or experience with VBA, SQL, or Python is a plus 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! 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. #J-18808-Ljbffr Dormont Manufacturing Co