Intern, Supply Chain Data Analytics & Process Automation

Wella International; Calabasas (CA); Hybrid; USD 28,000 - 29,000; Part time

Job summary

Wella Company in Calabasas, CA is offering a 6-9 month internship in Supply Chain Data Analytics and Process Automation. The role is 25 hours per week, hybrid onsite with 3 days in the office, and reports to the Project Manager, Supply Chain.

You will build reports and dashboards across demand, inventory, service, and supply performance, and identify automation opportunities using Power BI, Power Query, and related tools.

Qualifications

• Enrolled in bachelor's or master's program in a related field throughout the internship.
• Strong Excel skills with pivot tables and lookups; knowledge of Power Query is a plus.
• Familiarity with Power BI and basic SQL/Python is desirable.

Responsibilities

• Build and maintain dashboards across demand, inventory, service, and supply performance.
• Document processes and identify automation opportunities using Power Query, Power Automate, and Copilot.
• Support cross-functional Phase-In / Phase-Out (PIPO) activities and data quality initiatives.

Skills

Advanced Excel

Pivot Tables

Power Query

Power BI

SQL

Python

Power Automate

Visio

SAP

Education

Pursuing bachelor's or master's in Supply Chain Analytics Data Science

Tools

Tableau

Copilot

Office Scripts

Job description

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 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

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 [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.

Information regarding your rights: Know Your Rights and Pay Transparency Nondiscrimination Provision.

Equal employment opportunity, including veterans and individuals with disabilities.

PI287632831