Senior Benefits Analyst – Data-Driven HR Impact

Ulta Beauty; Chicago (IL); Hybrid; USD 66,000 - 80,000; Full time

Benefits offered by this job

Paid time off

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability benefits

Bonus plan

Job summary

Ulta Beauty is seeking a Benefits Analyst to join its Bolingbrook, IL team. You will manage benefits data, support reconciliations, and drive accurate reporting alongside Finance, Payroll, and People Success.

A strong Excel and data-analysis skillset supports regulatory compliance and annual enrollment activities. You will analyze vendor data, coordinate ACA and 1095 processes, and partner with HRIS vendors to optimize reporting.

Qualifications

• 5-8 years of experience in benefits administration, leave administration, HR operations, reporting or data analysis.
• 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, 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.

Responsibilities

• Manage and maintain all benefit data files, ensuring accuracy and timely delivery.
• Support reconciliations, budgeting, forecasting, and audit requests related to associate benefits with Finance, Payroll, and People Success.
• Extract, manipulate, validate, and reconcile data from multiple vendor systems and internal platforms.
• Collect, compile, and analyze data to make recommendations.
• Lead ACA process including hours measurement and coverage offers monthly and annually; coordinate Form 1095 and ACA filing with IRS.
• Work with external auditors to complete 401(k) audit and prepare 5500.
• Support the Annual Enrollment process.
• Collaborate with vendors to understand reporting functionality and troubleshoot issues.
• Assist with vendor implementations as needed.
• Maintain confidentiality and ensure compliance with regulations and company policies.

Skills

Advanced Excel

Data analysis

HR analytics

Attention to detail

Communication

Education

Bachelor’s degree in Human Resources

Tools

SuccessFactors

UKG

ADP

HRIS

Power Query

Job description

Ulta Beauty is seeking a Benefits Analyst to join its Bolingbrook, IL team. You will manage benefits data, support reconciliations, and drive accurate reporting alongside Finance, Payroll, and People Success.

A strong Excel and data-analysis skillset supports regulatory compliance and annual enrollment activities. You will analyze vendor data, coordinate ACA and 1095 processes, and partner with HRIS vendors to optimize reporting.