Merchandising Executive (6 months Contract) - #1163508

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