Sr Business Intelligence Analyst

Ulta Beauty; 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 seeks a Senior Business Intelligence Analyst to design data models and deliver front-end reporting and dashboards for decision making in Bolingbrook, IL. The role requires strong SQL, Tableau Desktop/Server/Prep, and data warehousing concepts to support merchandising, planning, inventory, and supply chain analytics.

Collaborate with stakeholders, optimize performance, and maintain documentation to ensure reliable data pipelines across enterprise systems.

Qualifications

• Bachelor’s degree in Information Technology or related field.
• 3+ years in IT development, front end reporting, enterprise analytics and large-scale databases.
• 3+ years designing, developing, and maintaining enterprise front-end reporting and dashboards.

Responsibilities

• Develop efficient data models and SQL queries to support front end reporting and visualization solutions.
• Deliver accurate and on time solutions to stakeholders to do their jobs throughout the year.
• Create and update process documentation and/or playbooks to support maintenance of solutions.
• Support ad-hoc and non-project-based requests.
• Support the testing of enterprise system changes and implementations.

Skills

SQL

Data Modeling

ETL/ELT

Tableau

Dashboards

Python/R

Education

Bachelor’s degree in Information Technology, or related.

Tools

Tableau Desktop

Tableau Server

Tableau Prep

SAP HANA Studio

SAP Business Objects

Oracle

SQL Server

GCP

Java

Python

R

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

Ulta offers 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.