COCA-COLA SINGAPORE BEVERAGES PTE. LTD.

Business Data Analyst and Admin Supervisor

Job description

Position Purpose / Context

To provide a continual professional business data analyst and administrative services to the Vending Operation and Business Development (Vending and Bulk Water) Team. To ensure accurate and timely data on all customers that’s available for management to make decisive execution.


Key Duties / Responsibilities

  • Generate Daily Vending VMS sales orders and release loads for Vending CAN route team and alternate days of Vending Cup sales orders and release loads for Vending CUP route team.
  • Generate weekly Placement & Removal Report of Vending & Bulk Water.
  • Generate weekly Net Sales Revenue report for Vending & Bulk Water.
  • Roster duties on checking tender opportunities in Gebiz & Sesami portal for Vending & Bulk Water.
  • Prepare Mass Maintenance files for mass updates and/or suppression for Vending & Dasani Bulk Water, get email approvals, let Cold Drinks team to verify equipment status & Finance team to verify account outstanding status, in order for finance team to submit this Mass Maintenance request in C1DM portal.
  • Always be prepared to assist Vending and Bulk Water sales, operation team and accounts receivable team, by submitting creation and update requests, be it updating address, delivery days, suppress inactive accounts, or create new accounts due to changes in Registrar of Company etc.
  • Submit Parking, ERP and other claims of VSA, Vending Route Supervisors
  • Create TPM for price discounts of products or promotion related FOC for Bulk Water customers as and when requested by sales team.
  • Prepare Yellow Vouchers for Vending & Bulk Water customers when requested by sales team or finance team, as well as every early of the month for certain vending customers.
  • Raise RGS (Free Goods Requisition Form), GME (Goods, Meals, Entertainment Approval Form) and/or GDAT (Government Dealings Approval Tool) for sponsorship related FOC / contractual FOC to customers.
  • Create PR (Purchase Requisition) – PO (Purchase Order) for monthly headcount and commission fees
  • Filing of soft copy contracts for Vending & Dasani Bulk Water customers.
  • Generate monthly Month End Reports for Commercial Finance
  • Also compile the monthly BDR Placement Sheets provided by all the Business Development Representative on the first two working days after Month End.
  • Assisting Vending System Executive to prepare monthly Month End Report for Commercial Finance
  • Create blanket PR (Purchase Requisition) – PO (Purchase Order) for delivery of flowers or hampers for
  • Perform GR (Goods Receive) in SAP system upon receiving invoices, following up with filing of the invoices from vendors / suppliers.
  • Update refund reports and keep a record of the daily refund files.
  • Keep and maintain the accuracy of Coke Tokens.
  • Assist HR Payroll to collect monthly OT Timesheets
  • Extract monthly removal data from SAP system and update into Vending Operation team
  • Assist in preparing monthly Business Review Meeting slides for vending operation.
  • Arrange for Grab delivery for any urgent items to be received by Vending and Bulk Water team.


Requirements:

Qualification : GCE ‘O’ Level or Diploma preferably in Business Administration or related discipline.

Experience : Preferably at least 1 year of working experience in sales administration / sales support.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.