Service Administrator (Automotive, Vlookup Pivot Table) - #1093996

Adecco is partnering with a Japanese MNC Automotive Manufacturer. We are looking for a Service Administrator (Vlookup and Pivot Table) to support the sales and finance department!

The Opportunity

Adecco is partnering with a Japanese MNC Automotive Manufacturer. We are looking for a Service Administrator (Pivot Table, Vlookup) to support both the sales and finance department for operation work!

This role provides crucial aftersales admin 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 $3800 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).

Next Steps

• Prepare your updated resume (please include your current salary package with a full breakdown such as base, incentives, annual wage supplement, etc.) and the expected package.
• Apply through this application or send your resume to [email protected] in MS Word Copy.
• We regret that only shortlisted candidates will be notified.

Hazel Wong
EA License No: 91C2918
Personnel Registration Number: R24121511