Sr Business Intelligence Analyst

Ulta Beauty, Inc.; Bolingbrook (IL); On-site; USD 112,000 - 113,000; Full time

Benefits offered by this job

Benefits package

Bonus plan eligibility

Job summary

Ulta Beauty, Inc. is seeking a Senior Business Intelligence Analyst to design and maintain data models, queries and dashboards that support retail analytics and executive reporting. You will collaborate with stakeholders across merchandising, planning and supply chain to deliver accurate insights.

The role emphasizes optimizing ETL/ELT processes, data validation and performance for large datasets, using Tableau and SAP/Oracle tech stacks. Strong SQL and programming skills are essential.

Qualifications

• Bachelor’s degree in Information Technology, or related field.
• Three years in IT development, front-end reporting development, enterprise reporting and analytics solutions.
• Three years designing and maintaining enterprise front-end reporting, dashboards and executive reports.

Responsibilities

• Develop efficient data models and SQL queries for front-end reporting and visualization.
• Deliver accurate solutions to stakeholders year-round.
• Create and update process documentation and playbooks for solution maintenance.
• Support ad-hoc requests and testing of enterprise system changes.

Skills

SQL

Tableau

ETL/ELT

Data visualization

Python

Education

Bachelor's degree in Information Technology or related

Tools

Tableau Desktop

Tableau Server

Tableau Prep

SAP HANA Studio

SAP BusinessObjects

Oracle

SQL Server

GCP

Job description

OVERVIEW

Live the experience. From professional empowerment to continual learning opportunities. From ongoing investment in new and emerging technologies to a career of self-determination. At Ulta Beauty, our tech team is critical to our scalability—and is recognized that way. We’ve been defined as a “mature start‑up.” A place where interdepartmental exposure, open doors, and genuine collaboration is ubiquitous. Where challenges come fast and furious, requiring agility, mental dexterity, and creativity. Where our passion for better solutions drives us and is core to who we are.

We’re engineering for the future of retail, and it’s no‑holds‑barred. But for those motivated by continual change and ambiguity, by superior leadership, by whip smart colleagues who will press you daily for your very best, you’ll find that virtually nothing’s impossible at Ulta Beauty.

COMPANY:

Ulta, Inc.

LOCATION:

1000 Remington Blvd., Suite 120, Bolingbrook, IL 60440

TITLE:

Senior Business Intelligence Analyst

HOURS:

Monday to Friday, 8:00 am to 5:00 pm

DUTIES:

Develop efficient data models and SQL queries to support front end reporting and visualization solutions. 10.0%

Deliver accurate and on time solutions to stakeholders to do their jobs throughout the year. 40.0%

Create and update process documentation and/or playbooks to support the maintenance of solutions. 10.0%

Support ad‑hoc and non‑project‑based requests. 25.0%

Support the testing of enterprise system changes and implementations. 15.0%

REQUIREMENTS:

Bachelor’s degree in Information Technology, or related.

Three (3) years in any occupation with IT development, front end reporting development, enterprise reporting and analytics solutions, large‑scale database management or related experience.

Three (3) years in any occupation with IT development, front end reporting development, enterprise reporting and analytics solutions, large‑scale database management or related experience must include: Three (3) years of experience designing, developing, and maintaining enterprise‑level front‑end reporting and data visualization solutions, including interactive dashboards and executive‑level analytical reports, to support complex business decision‑making. Three (3) years of experience architecting and implementing data models, dimensional schemas (star and snowflake), and data preparation workflows, including ETL/ ELT processes, data validation, and optimization techniques to ensure data accuracy, scalability, and performance. Experience must also include: Experience working with SQL and advanced database concepts, including complex joints, subqueries, window functions, indexing strategies, and query optimization across large, Indexing strategies, high‑volume datasets and Common Table expression; Tableau Desktop for advanced report and dashboard development; Tableau Server for enterprise publishing, permissions, performance optimization and user management; Tableau Prep for data cleansing, transformation and preparation workflows; SAP HANA Studio and SAP Business Objects tools; Oracle, SQL Server, and GCP; Experience supporting retail or enterprise business operations, including merchandising, planning, inventory, and supply chain analytics; and Experience with programming languages such as Java, Python, or R to support data processing, analytics, or reporting automation.

SALARY

$112,278.40 - $113,278.40 per year

Benefits

Ultaoffers a standard benefits package. See a full list of benefits here: https://careers.ulta.com/careers/about-us/benefits-and-career-development

The pay range for this position is $112,278.40 - $113,278.40 / 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. 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. For additional information concerning our benefits, visit our Benefits and Career Development page: https://learn.bswift.com/ulta

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.