Benefit Analyst

Ulta Beauty, Inc.; Bolingbrook (IL); Hybrid; USD 66,200 - 80,000; Full time

Benefits offered by this job

Health benefits

Paid time off

Hybrid work schedule

Job summary

Ulta Beauty, Inc. in Bolingbrook, IL is seeking a Benefits Analyst to support administration, reporting, analysis, and reconciliation of associate benefits and leave programs.

You will partner with Finance, Payroll, People Success and external vendors to produce accurate operational reporting and drive data-driven decisions. The ideal candidate has 5–8 years of benefits administration experience, advanced Excel (Pivot Tables, XLOOKUP/VLOOKUP, data validation, Power Query), and familiarity with

Qualifications

• 5-8 years of benefits administration, leave administration, HR operations, reporting or data analysis.
• Advanced Excel skills including pivot tables, XLOOKUP/VLOOKUP, data validation and reconciliation, and Power Query.
• Knowledge of ERISA, COBRA, HIPAA, FMLA and ADA, plus experience with HRIS/benefits systems.

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 multiple systems; analyze data for recommendations.
• Lead ACA processes including hours measurement, coverage offers, and Form 1095 distribution and IRS filings.
• Assist with annual enrollment and vendor implementations as needed.

Skills

Advanced Excel

Pivot Tables

XLOOKUP/VLOOKUP

Data Validation

Power Query

Education

Bachelor’s degree in Human Resources or related field

Tools

SuccessFactors

UKG

ADP

Job description

Overview

Authentic. Supportive. Fun. To experience human resources at Ulta Beauty is to step out of the mundane and into an environment alive with optimistic energy. Success breeds opportunity, and the opportunities to help drive an organization at the top of its game to greater heights are as uncommon as they are satisfying.

It’s fast, it’s ambitious, it’s anchored in trust. With the chance to move or flex based on new or existing interests and passions. If you want that rare culture of lived values, where “team” truly means something. Where the drive for excellence is balanced with a genuine desire to help and encourage. And where the mark you make will be seen and recognized—we challenge you to dream bigger. To imagine the possibilities.

The impact you can have

Position is located at corporate offices in Bolingbrook, IL (Hybrid work schedule – approx. 6 days in office per month)

The Benefits Analyst is a key contributor within the Benefits Team. This role is responsible for supporting the administration, reporting, analysis, and reconciliation of associate benefits and leave programs. This role partners closely with Enterprise Leaders, People Success, Finance, Payroll and external vendors to develop accurate and meaningful operational reporting, identify trends, resolve data discrepancies, and support compliance and business decision-making.

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.

You\'ll accomplish these goals by

• Responsible for managing and maintaining all benefit data files, ensuring accuracy, error resolution and timely delivery.
• Partner with Finance, Payroll, and People Success 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 essentials of success

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

Preferred 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.
• Experience with SuccessFactors, UKG, and/or ADP.

Compensation: The pay range for this position is $66,200.00 - $80,000.00 per year with the opportunity for eligible associates to earn additional compensation pursuant to the Company’s bonus plan. Exact pay will be based on factors including, but not limited to education, qualifications, certifications, experience, level, shift, geographic location, and business and organizational needs. Full-time positions are eligible for paid time off, health, dental, vision, life and disability benefits. Part-time positions are eligible for dental, vision, life, and disability benefits.

About Ulta Beauty

Ulta Beauty is the largest North American beauty retailer and the premier beauty destination for cosmetics, fragrance, skin care products, hair care products and salon services. We bring possibilities to life through the power of beauty each day in stores and online with a wide range of products across brands. We also offer a full-service salon in every store.

We will consider for employment all qualified applicants, including those with arrest records or other criminal histories, in a manner consistent with applicable laws.