Benefits Analyst

Durham School Services; Warrenville (IL); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Basic life insurance

Holiday pay

PTO accrual

Retirement savings plan

Job summary

Summit School Services is seeking a Benefits Analyst to join the Benefits Team at our Warrenville, IL corporate offices. The role focuses on administration, reporting, analysis, and reconciliation of benefits and leave programs, partnering with HR, Payroll, HRIS, and vendors to deliver actionable operational reports.

The ideal candidate is highly analytical, proficient in Excel, and comfortable working with large datasets. The position is hybrid (2 days in office per week) in Warrenville, IL.

Qualifications

• Bachelor’s degree in Human Resources, Data Analytics, Business Administration, or related field.
• 5–8 years of experience in benefits administration, leave administration, HR operations, reporting or data analysis.
• Experience with HRIS, payroll, benefits, and/or leave vendor systems.
• Advanced Microsoft Excel skills including pivot tables, XLOOKUP/VLOOKUP, data validation and reconciliation, and Power Query.

Responsibilities

• Manage and maintain all benefit data files with accuracy and timely delivery.
• Support reconciliations, budgeting, forecasting, and audit requests with Payroll and HRIS.
• Extract, manipulate, validate, and reconcile data from vendor systems and internal platforms.
• Collaborate with benefits and leave vendors to understand reporting functionality and troubleshoot issues.
• Assist with vendor implementations and annual enrollment processes.

Skills

Advanced Excel

Power Query

Education

Bachelor’s degree in HR, Data Analytics, Business Administration

Tools

Oracle Fusion

ADP

AbsenceSoft

Benefit Focus

Job description

Summit School Services companies share a strong commitment to provide the highest level of transportation safety, quality transportation, outstanding customer service and positive employee relations. Our corporate headquarters, located in Warrenville, Illinois, houses the administrative and corporate support functions for the organization. Our 250+ local customer service centers (CSCs) are supported by regional operations teams located throughout North America.

The Benefits Analyst is a key contributor within the Benefits Team. This role is responsible for supporting the administration, reporting, analysis, and reconciliation of benefits and leave programs. This role partners closely with HR Directors, General Managers, Payroll, HRIS, and external vendors to develop accurate and meaningful operational reporting, identify trends, resolve data discrepancies, recommend fixes and automate processes as well as support compliance.

The ideal candidate is highly analytical, advanced in Excel, comfortable working with large datasets, and able to independently navigate vendor reporting platforms to build actionable reporting solutions. The position is located at corporate offices in Warrenville, IL (Hybrid work schedule – 2 days in office per week).

Responsibilities

• Responsible for managing and maintaining all benefit data files, ensuring accuracy,
• error resolution and timely delivery.
• Partner with Payroll and HRIS to support reconciliations, budgeting, forecasting, and
• audit requests related to associate benefits.
• Extract, manipulate, validate, and reconcile data from multiple vendor systems and
• internal platforms.
• Collect, compile, and analyze data to make recommendations.
• Leads the execution of the ACA process including hours measurement and coverage
• offers on a monthly and annual basis as well as working with benefit enrollment
• vendor to test, communicate, and distribute Form 1095 and file ACA forms with the
• IRS.
• Works with external auditors to complete 401(k) audit and prepare 5500.
• Supports the execution of the Annual Enrollment process.
• Collaborates with benefits and leave vendors to understand available reporting
• functionality and troubleshoot reporting issues.
• Assists with vendor implementations as needed.
• Maintain confidentiality and ensure compliance with applicable regulations and
• company policies.

The base salary range is $65,000 - $75,000 annually.

Qualifications

• Bachelor’s degree in Human Resources, Data Analytics, Business Administration, or
• a closely related discipline, or an equivalent combination of education,
• certifications, and experience.
• 5-8 years of experience in benefits administration, leave administration, HR
• operations, reporting or data analysis.
• Experience with Oracle Fusion, ADP, AbsenceSoft, Benefit Focus.
• Advanced Microsoft Excel skills required, including pivot tables,
• XLOOKUP/VLOOKUP, data validation and reconciliation, and Power Query.
• Knowledge of leave laws and regulations and HR/benefits laws, including ERISA,
• COBRA, HIPAA, FMLA and ADA.
• Experience working with HRIS, payroll, benefits, and/or leave vendor systems.
• Excellent interpersonal and communication skills with a strong customer focus.
• Strong analytical and critical thinking skills with high attention to detail.
• Able to effectively handle multiple projects and meet deadlines.

The pay range for this position is $65,000 - $75,000 per year

Summit School Services has a zero-tolerance policy on conduct that is incompatible with its policies and values, including sexual exploitation and abuse, harassment, abuse of authority, and discrimination. Summit School Services is committed to promoting the protection and safeguarding of all children and passengers.

We offer medical, dental, vision, basic life insurance coverage, holiday pay, and PTO accrual. Additionally, employees are able to enroll in a retirement savings plan.

At Summit School Services our goal is to be a diverse workforce that is representative of the communities we serve. All employment decisions are based on business needs, job requirements and individual qualifications, without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law.

Summit School Services LLC's independent subsidiaries and affiliates are an equal employment opportunity (EEO) employer

The pay rate range, along with most all of the other terms and conditions of employment, vary between different sites, geographical markets, customer/ contractual terms and positions.