Benefit Analyst

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

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability benefits

Job summary

Ulta Beauty in Bolingbrook, IL seeks a Benefits Analyst to support administration, reporting, analysis and reconciliation of associate benefits and leave programs. You’ll partner with Finance, Payroll, People Success and vendors to develop accurate operational reporting and drive data‑driven decision making.

The ideal candidate is highly analytical, with advanced Excel skills and experience handling large datasets and vendor systems to build actionable reporting solutions.

Qualifications

• 5-8 years of experience in benefits administration, leave administration, HR operations, reporting or data analysis.
• Advanced Microsoft Excel skills (pivot tables, XLOOKUP/VLOOKUP, data validation, Power Query).
• Knowledge of leave laws and regulations (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 critical thinking skills with high attention to detail.
• Able to manage multiple projects and meet deadlines.

Responsibilities

• Manage and maintain all benefit data files, ensuring accuracy and timely delivery.
• Partner with Finance, Payroll and People Success to support reconciliations, budgeting, forecasting and audits related to associate benefits.
• Extract, manipulate, validate and reconcile data from 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 filings with the IRS.
• Collaborate with external auditors to complete 401(k) audits and prepare 5500 forms.
• Support the Annual Enrollment process.
• Work with vendors to understand reporting capabilities and troubleshoot reporting issues.
• Assist with vendor implementations as needed.
• Maintain confidentiality and ensure regulatory compliance.

Skills

Pivot tables

XLOOKUP / VLOOKUP

Data validation

Power Query

Analytical thinking

Attention to detail

Project management

Education

Bachelor's degree in Human Resources or related

Equivalent combination of education and experience

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. After all, success breeds opportunity, and the opportunities to help drive an organization at the top of its game to even 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.

The pay range for this position is $66,200.00 - $80,000.00 / 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 relevant education, qualifications, certifications, experience, level, shift, geographic location, and business and organizational needs. For additional information concerning our benefits, visit our Benefits and Career Development page: https://learn.bswift.com/ulta

• 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

At Ulta Beauty (NASDAQ: ULTA), the possibilities are beautiful . 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 and every day in our stores and online with more than 25,000 products from approximately 500 well-established and emerging beauty brands across all categories and price points, including Ulta Beauty's own private label. Ulta Beauty also offers a full-service salon in every store featuring---hair, skin, brow, and make-up services.

We will consider for employment all qualified applicants, including those with arrest records, conviction records, or other criminal histories, in a manner consistent with the requirements of any applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York City Fair Chance Act.