Merchandising Executive - #1099787

Please note that all positions must be applied for through the portal; applications sent via direct email will not be considered for shortlisting.

Business Reporting

• Generate, perform and potentially analyses relevant merchandising/performance ROI reports which will be in a weekly, monthly, annually period based, detailed reports for sales by SKU/brands report, stock level monitoring, identify/monitor slow moving, promotions & bestsellers items
• Reporting on ad-hoc price data summary & survey verification on pricing
• Additional Global Merchandising support for ad-hoc reporting for SG, HK & Korea.

Purchase Order & SKU Maintenance

• Extract system data such as [historical sales, stock inventory, on order, pricing] to prepare buying spreadsheet for Buyer to work on
• Upload PO and follow-up vendor shipment delivery status
• Upload prices data and other information by SKU
• Creation of New merchandises SKU

Shipment & Stock Management

• Communicate to Logistics & Brands for shipment PO/stock issues/ any discrepancy reporting
• Communicate to Operations on stock availability/ arrivals/ requisitions/ transfers etc
• Distribution list preparation for New merchandises
• Communication to Operations for New merchandise orders

Additional

• Any other administrative tasks which may include but not limited to order processing, creating & maintaining system SKU data, managing non-commercial items, liaising with warehouse on shipment status & stock related matters
• Monthly rebate & discount billings calculation amount to bill back Brands
• Follow up on monthly routine with Brands e.g. sales incentive/contest & on-counter GWPs & discount summary update
• Manage timely stocks return to vendors and stocks write-off/conversion
• Provide GWPs shipping information for warehouse follow-up on SKU tagging
• Ensure & communicate agreed promotion mechanics with vendors & Operations

Requirement:

• Diploma in Business or Retail Management
• Minimum 2 years of related work experience
• High competence in business reporting with strong excellence in MS Excel (Pivot is required)
• MS PPT & SAP system is an added advantage
• Meticulous and multi-tasking is required
• Has good initiative and organizational skills
• Is independent yet a team player
• Good interpersonal, coordination & communication skills
• Strength in numbers is a must.
• Ensure data accuracy [managing SAP/JV system]
• Strong sense of commitment and urgency to meet deadline