Inventory Optimization Officer (Modern Trade Channel)

PT Garudafood Putra Putri Jaya; Jakarta Utara; On-site; IDR 133,920,000 - 223,200,000; Full time

Job summary

PT Garudafood Putra Putri Jaya, a leading food and beverage company in Indonesia, is seeking a skilled Inventory/Modern Trade Analyst to drive inventory performance and data-driven decisions. The role focuses on MT distribution, EOQ optimization, and robust reporting.

The candidate will work with ERP systems, Excel-based forecasting, and BI tools to monitor DOI, OOS, service levels, and slow-moving stock, delivering weekly and monthly analyses.

Qualifications

• Bachelor's degree in Industrial Engineering or related field.
• Strong understanding of Modern Trade distribution channels.
• Knowledge of inventory management concepts (ROP, EOQ, safety stock, service level, WOS).
• Advanced Excel proficiency (VLOOKUP, Pivot Tables, forecasting).
• Familiarity with ERP systems such as SAP, Oracle, or MS Dynamics.
• Power BI or data visualization tools a plus.
• Ability to analyze Modern Trade data (POS, sell-in/sell-out).
• Strong analytical and reporting skills for weekly/monthly inventory performance.

Skills

Modern Trade

Inventory management

Excel advanced

ERP familiarity

Power BI

Data analysis

Reporting

Education

Bachelor’s degree in Industrial Engineering or related field

Tools

SAP/Oracle/MS Dynamics

Power BI

Job description

• Bachelor’s degree in Industrial Engineering, Supply Chain/Logistics Management, Business, Statistics, or a related field.
• Strong understanding of Modern Trade (MT) distribution channels, including Key Accounts, Minimarket Chains, Supermarkets/Hypermarkets, and Central Distribution Center (CDC)/Distribution Center (DC) systems.
• Strong knowledge of inventory management concepts, including Safety Stock, Reorder Point (ROP), Economic Order Quantity (EOQ), Service Level, Weeks of Stock (WOS), Lead Time, and Stock-Out Analysis.
• Advanced proficiency in Microsoft Excel, including VLOOKUP, Pivot Tables, complex formulas, and forecasting.
• Familiarity with ERP systems such as SAP, Oracle, or Microsoft Dynamics.
• Proficiency in Power BI or other data visualization tools is a plus.
• Ability to process and analyze Modern Trade data, including Point of Sale (POS), Sell-in/Sell-out, and inventory data from partner portals.
• Strong analytical and reporting skills, with the ability to prepare and present weekly/monthly inventory performance reports covering Days of Inventory (DOI), Out-of-Stock (OOS) Rate, Service Level, and Slow-Moving/Dead Stock.

GarudaFood is a food and beverage company subordinated of Tudung Group. In addition to GarudaFood, Tudung Group also subordinates in Agribusiness companies operating ini Crude Palm Oil field and Peanuts. GarudaFood Group had originated from PT Tudung, it was established in Pati, Central Java. The company founder is the deceased Darmo Putro, ex-warrior who had chosen to engage in business sector after the independence of Indonesia. In early of 1987, TPJ started selling its peanut production products using a brand of Kacang Garing Garuda, which was recently known as: Kacang Garuda. Kacang Garuda earned the following awards: Indonesian Customer Satisfaction Award (ICSA) under the category of branded peanut for eight times consecutively (2000-2007); Superbrands (2003); Top Brand for Kids (2004); Indonesian Best Brand Award (IBBA, 2004-2007); Top Brand (2007). When national economy suffered from economic crisis, on December 1997, PT GarudaFood Jaya (GFJ) was established, producing Gery-branded biscuit. Gery Saluut earned Indonesian Best Brand Award (IBBA) from MARS and SWA Magazine for a period of 2005-2010 under the category of wafer salut. In 2007-2010 Gery Chocolatos earned IBBA under the category of wafer stick. In 1998 GarudaFood acquired PT Triteguh Manunggal Sejati (TRMS), producer of jelly and launched jelly product using brands of Okky and Keffy. Achievement of Okky jelly has been proven by its successfulness in earning Top Brand for Kids (TBK) Award 2004 under the category of jelly. In addition to TBK, OKKY Jelly also managed to earn IBBA (2005-2010). Okky jelly Drink also earned Top Brand Award 2007-2010 from Marketing Magazine in cooperation with Frontier. In the end of 2002, TRMS launched jelly beverage products with a brand of Okky Jelly Drink and it also constituted a new phase for GarudaFood to deal with beverages business. Seriousness of GarudaFood in focusing on beverages business had also become apparent by the launching of Mountea, fruit-flavored tea beverage. Mountea had even been awarded by IBBA 2007-2010 under the category of tea beverage in cup packaging. GarudaFood also produces Snack with a brand of Leo, for category of Potato chips, banana chips, cassava chips products initiated from the end of 2005. In 2007-2010 Leo earned IBBA award for category of potato chips. In national level, GarudaFood is also positively perceived as one of the admired food and beverage companies. Survey made by Frontier and BusinessWeek Indonesia Magazine in Jakarta and Surabaya in 2006-2010 indicated that GarudaFood was in the third position of Indonesian Most Admired Company (IMAC). GarudaFood also actively performs corporate social responsibility (CSR) under the flag of GarudaFood Sehati. To accelerate the achievement of its vision, in 2011 GarudaFood Group with non-alcohol divion of Suntory Beverage & Food, a company from Japan established a subsidiary PT Garuda Suntory Beverage, focused on the development of the beverage. Now, all potencies supported by 20 thousands knowledge workers have become main asset to GarudaFood in the effort to go forward to meet a success as sustainable enterprise.