Demand & Supply Coordinator

Job description / Role

- Coordinate with brands, DS team and plants to obtain and share product information.
- Input, maintain and collate data related to forecasting and inventory management to support the DS Planners.
- Generate forecast vs. sales reports/ in transit reports/ master data updates.
- Generate inventory reports (including ageing, out of stock, over stock, dead stock and DIP inventory).
- Generate discrepancy reports JDE versus system/physical stock in Agility and investigate discrepancies. Report discrepancies to the DSP Manager and make agreed adjustments to stock in the system.
- Maintain stock expiry/batch data, reconcile with Agility expiry/batch data and generate expiry report. Amend expiry data as per instructions from DS Planner.
- Update the brands on monthly basis on expired and quarantined products.
- Manage/approve/advise on part allocation reports liaising with Customer Service and Agility.
- Follow up with the plants prior to shipping to ensure timely supply for new launches and report deviations from the plan to the DS Planner.
- Monitor the Inbound Tracker after shipping and advise the DS Planner/brand of any deviations to timing.
- Maintain the master data, including entering new codes and making old codes inactive.
- Enter cost price into JDE.

Requirements

- University level of education or equivalent professional qualification.
- Minimum 1 - 3 years experience preferably in a related industry
- Excellent Computer skills in Excel
- Confident communicator
- Detail orientated
- Comfortable working with numbers and spreadsheets

About the Company

The Estée Lauder Companies Inc. is one of the world’s leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. The Company’s products are sold in over 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Prescriptives, Lab Series, Origins, Tommy Hilfiger, M•A•C, Kiton, La Mer, Bobbi Brown, Donna Karan New York, DKNY, Aveda, Jo Malone London, Bumble and bumble, Michael Kors, Darphin, Tom Ford, Smashbox, Ermenegildo Zegna, AERIN, Marni, Tory Burch, RODIN olio lusso, Le Labo, Editions de Parfums Frédéric Malle and GLAMGLOW.