Aftersales Admin Support (Automotive, Vlookup Pivot Table)

The Opportunity

Adecco is partnering with a Japanese MNC Automotive Manufacturer. We are looking for a Sales Support and Finance Admin Coordinator (Pivot Table, Vlookup) to join their business!

This role provides crucial admin support for the Aftersales support duties within the Service & Workshop department, working closely with Sales and Finance teams. We are seeking a candidate who possess strong Excel skills (Pivot Tables, VLOOKUP proficiency required - Excel test will be required) and exposure to finance-related duties.

• Permanent, Full-time opportunity
• Location: West region, Tuas office (Company transport provided Boon Lay)
• Working hours: Monday - Friday, 8.30am to 5.30pm
• Salary: up to $3500 basic AWS VB

The Job

• Sales & Finance Support: Work closely with Sales and Finance teams to provide administrative support for operations.
• Finance Admin: Support management in monitoring and managing technicians’ attendance, Overtime (OT), and allowance claims.
• Billing & Documentation: Verify customer invoices, checklists, and quotations for correct details, signatures, stamps, and billing.
• Manage Purchase Orders: Prepare POs for suppliers/contractors, verify vendor invoices against POs, and ensure 3-way matching (PO, DO, Invoice).
• Aftersales Support: Respond to customer and vendor inquiries regarding billing disputes or discrepancies.
• Track Vendor Invoices: Monitor timely receipt and completeness of vendor invoices to avoid payment delays.
• Reporting: Assists the Manager with generating all necessary management reporting and compiling it for monthly review.

The Talent

• Min O Level with at least 5 years of admin support in service or workshop environment
• Possess finance/ accounting experience (AR / AP / Invoice) will be advantages
• Must: Strong in Excel using Vlookup and Pivot Table (Excel test will be required)