Supply Chain Data & Analytics Intern

Ulta Beauty, Inc.; Bolingbrook (IL); Hybrid; USD 28,000 - 34,000; Full time

Job summary

Ulta Beauty, Inc. is offering a Supply Chain Data & Analytics Intern position for Summer 2027 in Bolingbrook, IL. The 10-week program targets rising juniors and seniors and includes hybrid and in-person tracks, with hands-on projects and cross-functional exposure.

You'll develop SQL skills, create Power BI dashboards, and partner with analysts to deliver an end-to-end analytics project for leadership. This internship emphasizes real-world data work in a fast-paced retail supply chain.

Qualifications

• Pursuing a Bachelor's or Master's degree in a related field.
• Strong SQL and data visualization skills.
• Experience with Excel and analytical thinking is preferred.

Responsibilities

• Develop and enhance Power BI dashboards and data visualizations for key supply chain metrics.
• Write and optimize SQL queries to retrieve and transform data.
• Support reporting across Distribution Center Operations and Retail Operations.
• Assist with data validation to ensure accuracy and reliability of reports.
• Collaborate with team members to translate business questions into dashboards and insights.
• Complete an end-to-end internship project delivering a Power BI dashboard addressing a real supply chain need.

Skills

SQL

Data visualization

Excel

Analytical thinking

Education

Bachelor's or Master's degree in a related field

Tools

Power BI

Google Cloud Platform (GCP) / BigQuery

Python

ETL concepts

Job description

OVERVIEW

Discover the possibilities. At Ulta Beauty, we believe in the best ideas that create greatest impact. And we know that those insights can come from anyone, at any time. Which is why we empower our interns in ways few organizations do. Here, you’ll take what you’ve learned in the classroom into a world of real-life challenges that require creativity and new perspectives. That push you to think in new ways. Because it’s all about inspiration and transformation, not simply checking a box or building a resume. We’re here to help prepare you to realize your future career ambitions.

Experience the difference for yourself.

Supply Chain Data & Analytics, Summer Intern 2027

The 2027 Ulta Beauty Internship is a structured 10-week program designed to develop future talent and provide interns with a unique and impactful development experience. This program is tailored for rising college Juniors and Seniors, offering Corporate, Field, and Distribution Center internship tracks. The internship will be hybrid for Corporate interns and in-person for Distribution Center and Field interns. Interns will gain hands-on experience in Ulta Beauty’s operations while contributing to business needs, engaging in meaningful projects, and broadening their professional development. The internship program provides real-world experience directly related to the academic discipline and career goals, offering a better understanding of career options.

• Hands-on experience working as a member of a specific department, team, and or location.
• Assigned projects to accelerate learning of key functions and processes.
• Cross-functional exposure to various departments.
• Comprehensive overview of the company structure and strategy.
• Tailored professional development sessions and valuable networking opportunities.
• Capstone presentation to leadership, showing project outcomes and recommendations.

OVERVIEW

Imagine

With over 1,400 stores throughout the U.S. and a thriving supply chain network, there has never been a greater need for people of high initiative, big-picture thinking, and adaptability to share in our journey. At Ulta Beauty, we have greater ambitions. Growing what works. Iterating in areas that have promise. Creating new offerings for industry advantage.

Behind the thousands of beauty products and brands our guests discover every day is a complex supply chain connecting distribution centers, stores, digital channels, and teams across the organization. Data plays an important role in helping those teams understand performance, identify opportunities, and make better decisions.

For someone excited by both analytics and the beauty industry, this internship provides an opportunity to see how data and technology help bring the possibilities of beauty to life for our guests.

THE IMPACT YOU CAN HAVE:

As a Supply Chain Data & Analytics Intern, you will gain hands-on experience using data to support decision-making across Ulta Beauty's supply chain. Working alongside the Supply Chain Data & Analytics team, you will help transform data from Distribution Center (DC) Operations and Retail Operations into reporting, visualizations, and insights that improve visibility into supply chain performance.

You will have the opportunity to develop practical skills in SQL, data visualization, reporting, and analytics while learning how data moves from operational systems through transformation processes and ultimately into the dashboards and insights used by the business.

Throughout the internship, you will collaborate with analysts and business partners, contribute to existing analytics solutions, and work toward an end-to-end dashboard project that addresses a real Supply Chain business need that will be presented to Leadership teams. From understanding the business question and exploring the underlying data to developing the visualization and presenting the finished solution, this project will provide the opportunity to experience the analytics delivery lifecycle from beginning to end.

YOU'LL ACCOMPLISH THESE GOALS BY:

• Develop and enhance Power BI dashboards and data visualizations that provide visibility into key Supply Chain metrics and operational performance.
• Write and modify SQL queries to retrieve, analyze, validate, and transform Supply Chain data.
• Support reporting and analytics across Distribution Center Operations, Retail Operations, and other areas of the Supply Chain.
• Assist with data validation and troubleshooting to help ensure reporting is accurate, consistent, and reliable.
• Analyze operational data to identify trends, patterns, and opportunities that can improve Supply Chain visibility and decision-making.
• Support recurring reporting and KPI measurement for Supply Chain teams and leadership.
• Partner with Supply Chain Data & Analytics team members to understand business questions and translate them into effective reporting and visualization solutions.
• Collaborate with Distribution Center Operations, Retail Operations, and other business partners to understand the processes and business context behind data.
• Assist with improvements to existing dashboards, datasets, reporting processes, and data pipelines.
• Gain exposure to data transformation and ETL processes used to prepare Supply Chain data for reporting and analytics.
• Help document data sources, business logic, reporting requirements, and analytics solutions.
• Communicate analytical findings in a clear, structured, and easy-to-understand way to both technical and business audiences.
• Complete an end-to-end internship project delivering a Power BI dashboard or analytics solution that addresses a Supply Chain business need

THE ESSENTIALS FOR SUCCESS:

• Currently pursuing a Bachelor's or Master's degree from an accredited college or university in Data Analytics, Business Analytics, Supply Chain, Computer Science, Information Systems, Engineering, Statistics, Business, or a related field.
• Must be local totheChicagoarea and/or able to come into theBolingbrook Corporateofficeat least6 days a month(3 days every other week).
• Passion for beauty, retail, and Ulta Beauty's mission to bring the possibilities of beauty to life.
• Interest in Supply Chain, Retail, and how data and technology support the guest experience.
• Entry-level experience using SQL, including the ability to query and work with structured datasets through coursework, academic projects, internships, or other experience.
• Basic experience with data visualization, including creating charts, dashboards, or other visual representations of data through coursework, projects, or previous experience.
• Working knowledge of Excel or similar analytical tools.
• Strong interest in data analytics, business intelligence, and using data to solve real-world business problems.
• Strong analytical and problem-solving skills with an ability to approach questions in a structured and curious way.
• Detail-oriented with an interest in understanding both the data and the business processes behind it.
• Ability to communicate findings and analytical concepts clearly to technical and non-technical audiences.
• Ability to collaborate effectively with team members and cross-functional business partners.
• Eagerness to learn, ask questions, receive feedback, and take ownership of assigned work.

NICE TO HAVE:

• Experience with Power BI or another business intelligence and visualization platform.
• Exposure to Python or another programming language used for data analysis.
• Familiarity with ETL, data transformation, or data pipeline concepts.
• Exposure to Google Cloud Platform (GCP), BigQuery, or another cloud data platform.
• Familiarity with AI automation and processing
• Coursework, academic projects, or previous internship experience involving analytics, dashboards, reporting, data engineering, or Supply Chain.
• Interest in learning how analytics solutions are developed from initial business requirements through data preparation, visualization, deployment, and ongoing support.

The pay range for this position is $25.00 - $0.00 / Hour. 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. Eligible associates may also earn overtime pay as required by applicable law. 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.