Ulta Beauty is a beauty retailer with a large supply chain network connecting distribution centers, stores, digital channels, and teams across the organization. The Supply Chain Data & Analytics Intern will use SQL, Power BI, reporting, and data visualization to analyze operational data, improve supply chain visibility, and deliver an end-to-end dashboard or analytics solution for a business need.
Responsibilities
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
Qualification
Required
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 to the Chicago area and/or able to come into the Bolingbrook Corporate office at least 6 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
Preferred
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
Benefits
The internship will be hybrid for Corporate interns and in-person for Distribution Center and Field interns.
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.
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.
Ulta Beauty is a beauty retailer that offers a wide range of products including cosmetics, fragrances, skincare, and hair care.
