Benefits Analyst - Remote

Summit School Services LLC; United States; Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Holiday pay

PTO accrual

Retirement savings plan

Job summary

Summit School Services LLC is seeking a highly analytical Benefits Data Analyst to manage complex benefit data, support ACA processes, and partner with Payroll and HRIS on reconciliations and audits. The role requires expert Excel, experience with vendor systems, and strong regulatory knowledge.

The hybrid position is based at our Warrenville, IL corporate offices, offering collaboration with HR, payroll, and benefits teams.

Qualifications

• Bachelor’s degree in HR, 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 including pivot tables, XLOOKUP, VLOOKUP, data validation and reconciliation, and Power Query.
• Knowledge of leave laws and regulations and HR/benefits laws (ERISA, COBRA, HIPAA, FMLA, ADA).
• Experience with HRIS, payroll, benefits, and/or leave vendor systems.
• Excellent interpersonal and communication skills with a strong customer focus.
• Strong analytical and detail-oriented approach; able to manage multiple projects.

Responsibilities

• Manage and maintain all benefit data files, ensuring accuracy and timely delivery.
• Support reconciliations, budgeting, forecasting, and audit requests related to benefits.
• Extract, manipulate, validate, and reconcile data from vendor systems and internal platforms.
• Collect, compile, and analyze data to provide actionable recommendations.
• Lead the ACA process including hours measurement, coverage testing, and Form 1095 distribution with the IRS.
• Coordinate with 401(k) audit preparations and 5500 filings with external auditors.
• Support Annual Enrollment processes and vendor implementations as needed.
• Maintain confidentiality and ensure compliance with applicable regulations and policies.

Skills

Advanced Excel

Pivot Tables

XLOOKUP

VLOOKUP

Power Query

HRIS

Payroll systems

Benefits administration

Data analysis

Oracle Fusion

ADP

AbsenceSoft

Benefit Focus

Education

Bachelor's degree in HR/Data Analytics/Business Administration

Tools

Oracle Fusion

ADP

AbsenceSoft

Benefit Focus

Job description

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

REQUIREMENTS:

• 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.

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.