The Town of Wellesley is seeking a detail-oriented Benefits Analyst to join our Human Resources team. This role demands strong Microsoft Excel skills (vlookup, pivot tables, formulas), data analysis expertise, and experience managing payroll and HR data systems. The ideal candidate will be analytical, proactive, and capable of managing multiple systems while ensuring accuracy and efficiency.

Key Responsibilities:

• Process payroll deductions for new hires, terminations, and open enrollment changes, ensuring accurate data entry and compliance.
• Use advanced Excel functions (vlookup, pivot tables, formulas) for data analysis, reporting, and maintaining accurate benefits records.
• Conduct benefits audits and ensure smooth integration of benefits data into payroll systems.
• Manage and analyze benefits-related data, including 1095-C reporting, opt-out programs, and open enrollment data uploads.
• Provide administrative support, including appointment scheduling, benefits payments, budget support, and meeting coordination.

Requirements:

• Bachelor’s degree in HR, Business Administration, or related field.
• Strong proficiency in Microsoft Excel (vlookup, pivot tables, formulas) and experience with data analysis.
• Familiarity with payroll functions and HR data systems (MUNIS a plus).
• Experience working with benefits administration (health, retirement planning, or leave management) and ensuring data accuracy.
• Familiarity with COBRA, FMLA, and other federal and state benefits laws.
• Ability to work independently in a fast-paced environment, managing multiple systems and maintaining high accuracy.

Salary: $55,000 - $70,000 (based on qualifications)

To apply, please email your resume and cover letter as a PDF to hr@wellesleyma.gov or submit to the Human Resources Department, 525 Washington Street, Wellesley, MA 02482. Open until filled. AA/EOE.