Intern, Supply Chain Data Analytics & Process Automation

Wella Operations US LLC; Calabasas, Northern (CA, KY); Hybrid; USD 28,000 - 29,000; Part time

Job summary

Wella Company invites applications for an Intern, Supply Chain Data Analytics & Process Automation in Calabasas, CA. The hybrid role supports North America Supply Chain with 25 hours per week over 6-9 months, reporting to the Project Manager, Supply Chain.

Responsibilities include building dashboards, automating reports, and supporting PIPO execution across demand and inventory. The ideal candidate is pursuing a degree in a related field, with strong Excel and analytics skills; familiarity with

Qualifications

• Currently pursuing a degree in Supply Chain, Analytics, Data Science, Information Systems, or related field.
• Advanced Excel with pivot tables, lookups, and Power Query; working knowledge of Power BI or Tableau.
• Exposure to SQL, Python, Power Automate, Visio, or SAP is a plus.
• Strong analytical skills with the ability to work with large data sets and generate practical solutions.

Responsibilities

• Build and maintain reports and dashboards (Excel, Power BI) covering demand, inventory, service level, fill rate, and obsolescence.
• Document current-state processes with maps, SOPs, and work instructions; identify automation candidates.
• Design and pilot automation solutions using Power Query, Power Automate, Office Scripts or VBA, and Copilot.
• Support Phase-In/Phase-Out execution across functions; track timelines and readiness.
• Collect, clean, and reconcile data from SAP, Blue Yonder, and other systems; investigate discrepancies.
• Translate analysis into clear recommendations by highlighting trends and root causes.
• Maintain trackers and dashboards; monitor obsolescence risk and disposition.
• Collaborate with stakeholders to gather requirements and train end users on new reports.
• Apply continuous improvement methods to recurring pain points; propose corrective actions.
• Measure impact of improvement projects including hours saved and cycle time reductions.

Skills

Advanced Excel

Power BI

SQL

Python

Power Automate

Visio

SAP

Education

Pursuing Bachelor's or Master's in related field

Tools

Power BI

Tableau

Power Automate

Excel

SAP

Job description

Intern, Supply Chain Data Analytics & Process Automation

Function: Supply Chain

Location: CA, US

Work Arrangement: Hybrid

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.

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 elevate 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
• 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 [e-mail] . 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.