Intern, Supply Chain Data Analytics & Process Automation

Position Title: Intern, Supply Chain Data Analytics & Process Automation   Location: Calabasas, CA - Hybrid (3 Days Onsite)   Reports to: Project Manager, Supply Chain   Scope / Brands: North America Supply Chain, All Brands   Duration: 6-9 months; 25 hours/week     ABOUT THE WELLA COMPANY  Together, WE enable individuals to look, feel, and be their true selves.  Wella Company is one of the world’s leading beauty companies, comprised of a family of iconic brands such as Wella Professionals, Clairol, OPI, Nioxin and ghd. With 6,000 employees globally, presence in over 100 countries, Wella Company and its brands enable consumers to look, feel, and be their true selves. As innovators in the hair and nail industry, Wella Company empowers its people to delight consumers, inspire beauty professionals, engage communities, and deliver sustainable growth to its stakeholders.  For additional information about the Wella Company please visit www.wellacompany.com.     THE ROLE  The Supply Chain Data Analytics & Process Automation Intern will support the North America Supply Chain team turn operational data into decisions and make day-to-day processes faster, more reliable, and easier to scale. The intern will build and maintain reporting and dashboards across demand, inventory, service, and supply performance; support Phase-In / Phase-Out (PIPO) execution so product transitions land on time, in full, and with minimal write-off; and identify manual, repetitive work that can be improved through automation and AI-assisted tools such as Excel Power Query, Power BI, Power Automate, and Microsoft Copilot. This is a structured learning role reporting to the Project Manager, Supply Chain, with coaching on supply chain fundamentals, analytics practices, and continuous improvement methods.   KEY RESPONSIBILITIES   Build, maintain, and automate recurring supply chain reports and dashboards (Excel, Power BI) covering demand, inventory, service level, fill rate, and excess and obsolete inventory. Document current-state processes through process maps, SOPs, and work instructions, and identify manual, repetitive, or error-prone steps that are candidates for standardization or automation. Design and pilot automation solutions using Power Query, Power Automate, Office Scripts or VBA, and AI-assisted tools such as Microsoft Copilot to reduce manual effort and cycle time. Support Phase-In / Phase-Out (PIPO) execution cross-functionally with Demand Planning, Supply Planning, Marketing, Master Data, and Customer Service, tracking launch and discontinuation timelines, run-out plans, and cutover readiness. Collect, clean, and reconcile data from SAP, Blue Yonder, and other planning and reporting systems; investigate discrepancies and escalate data quality issues to the appropriate process owner. Translate analysis into clear recommendations by highlighting trends, exceptions, and root causes rather than reporting numbers alone. Maintain the PIPO tracker and related dashboards; monitor phase-out inventory run-down, flag obsolescence risk early, and recommend disposition. Partner with cross-functional stakeholders to gather requirements, test solutions, and train end users on new reports and automated workflows. Apply basic continuous improvement methods, including process mapping and root cause analysis, to recurring supply chain pain points and propose corrective actions. Measure and report the impact of improvement projects (hours saved, errors avoided, cycle time and accuracy gains) before and after implementation. Assist with ad hoc analysis requests from Supply Chain leadership, including scenario analysis, KPI deep dives, and business case support.   QUALIFICATIONS     Currently pursuing a degree in Supply Chain, Business Analytics, Data Science, Information Systems, or a related field; Must be actively enrolled in a bachelor's or master's degree program throughout the internship. Advanced Excel skills, including pivot tables, lookups, and Power Query; working knowledge of Power BI or Tableau preferred. Exposure to SQL, Python, Power Automate, Visio, or SAP is a plus. Strong analytical skills with the ability to work with large data sets, identify issues, and generate practical solutions Curious and investigative mindset, comfortable asking why a process works the way it does and proposing a better way Able to stay organized, manage multiple workstreams, and adjust priorities while working with several stakeholders and deadlines. Self-starter with solid oral and written communication skills and the ability to present findings clearly to non-technical audiences   Desirable:   Exposure to process improvement or Lean Six Sigma concepts, or to AI-assisted productivity tools such as Microsoft Copilot Ability to collaborate across functions and levels, gather input from stakeholders, and follow through independently on agreed solutions. Demonstrated teamwork, interpersonal skills, and follow-through through coursework, internships, projects, or work experience. We disclose the compensation range for positions in compliance with local law. Actual salaries will vary and may be above or below the range based on various factors including but not limited to location, experience, skills and in comparison, to internal incumbents currently in similar roles. Pay Range: $20 - $21 per hour. NOTICES  All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status. If you need assistance and/or a reasonable accommodation due to a disability during the application process, please email NA.Recruiting@wella.com. This email account will not respond to inquiries regarding the status of a candidate’s application. [For CA located postings ONLY]: Qualified Applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Information regarding your rights: Know Your Rights and Pay Transparency Nondiscrimination Provision.