Merchandising Executive

Shilla Travel Retail Pte Ltd; Singapore; On-site; SGD 42,000 - 68,000; Full time

Job summary

Shilla Travel Retail Pte Ltd is seeking a detail-oriented professional to support business reporting, PO and SKU maintenance, and shipment/stock management. The role involves extracting data to create buying sheets for Buyers, updating system SKUs, and communicating with Logistics and Brands to resolve stock and shipment issues.

Candidate should have a Diploma in Business or Retail Management with at least two years of related experience and strong Excel Pivot skills.

Qualifications

• Diploma in Business or Retail Management.
• Minimum 2 years related work experience.
• Strong Excel skills with Pivot tables.
• Good communication and coordination abilities.

Responsibilities

• Generate and analyze merchandising/performance ROI reports on a weekly, monthly, and annual basis.
• Prepare buying spreadsheets by extracting historical sales, stock, and pricing data for Buyers.
• Coordinate shipment/stock issues with Logistics, Brands and Operations; monitor stock levels and transfers.
• Handle miscellaneous admin tasks including SKU data maintenance and vendor communications.
• Compute monthly rebates, discounts, and promotional billings with Brands.

Skills

Excel Pivot

Data analysis

MS PowerPoint

SAP

Communication skills

Multitasking

Education

Diploma in Business

Diploma in Retail Management

Tools

SAP

Job description

Job Description

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

Job Requirements

• 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