Category Planner & Support Staff

Job Description

• Manage and process customer Purchase Orders (PO) accurately and in a timely manner.
• Verify PO details, coordinate with relevant departments, and ensure smooth order fulfillment.
• Maintain and update product pricelists, including promotional pricing and discount programs.
• Ensure pricing information is accurate, up-to-date, and properly communicated to internal stakeholders.
• Prepare and generate regular reports related to sales performance, pricing, promotions, inventory, and other business requirements.
• Collect, organize, and analyze data to support management decision-making.
• Utilize Microsoft Excel to manage large datasets, create reports, perform data analysis, and maintain data accuracy.
• Develop and maintain spreadsheets, Pivot Tables, VLOOKUP/XLOOKUP, and other Excel-based reporting tools.
• Conduct Days of Stock (DOS) Analysis to monitor inventory levels and product availability.

Job Requirements

• Bachelor's Degree or Diploma in Business Administration, Management, Economics, or a related field.
• Minimum 1–2 years of experience in Sales Administration, Commercial Administration, or a similar role.
• Strong proficiency in Microsoft Excel, including Pivot Tables, Lookup Functions, and data analysis.
• Experience in handling Purchase Orders (PO), pricelist management, and promotional pricing administration or sales data
• Knowledge of inventory management and DOS (Days of Stock) analysis is preferred.
• Strong analytical skills, attention to detail, and accuracy in data processing.
• Good communication and coordination skills.
• Able to work independently and manage multiple tasks effectively.

Requirements: