Excel-Powered Purchasing & Inventory Analyst

Autolac; Sydney; On-site; AUD 65,000 - 90,000; Full time

Job summary

Autolac Group is seeking a detail‑oriented Purchasing & Data Administrator to support purchasing and inventory functions for the national business. The role emphasizes Excel analysis, master data maintenance, and accurate data entry, with liaison duties across branches and suppliers.

The successful candidate will maintain master data, prepare and analyse Excel reports, and ensure data accuracy in NetSuite while supporting the Purchasing and Inventory Team and providing regular management reports.

Qualifications

• Minimum of 3 years' experience in administration, data, purchasing or inventory support.
• Very strong Microsoft Excel skills including VLOOKUP/XLOOKUP, PivotTables, formulas and large datasets.
• Excellent analytical and numerical skills.
• Exceptional accuracy and attention to detail.
• Strong organisational and time management skills.
• Experience with NetSuite or another ERP system would be highly regarded.

Responsibilities

• Maintain and updating product, supplier and inventory master data.
• Prepare, update and analyse Excel spreadsheets and reports to support purchasing decisions.
• Extract, reconcile and validate data to ensure accuracy.
• Process data uploads and maintain records within NetSuite.
• Enter and update purchase orders / create inbound shipments.
• Manage ETAs on incoming orders.
• Liaise with branches regarding stock requirements and order updates.
• Contact suppliers to place orders, confirm deliveries and follow up outstanding orders.
• Coordinate back orders and special order items.
• Provide general administrative support to the Purchasing and Inventory Team.
• Regular reporting to Management.

Skills

Excel

Data analysis

Attention to detail

Supplier liaison

Inventory management

ERP systems

Tools

NetSuite

PivotTables

Job description

Autolac Group is seeking a detail‑oriented Purchasing & Data Administrator to support purchasing and inventory functions for the national business. The role emphasizes Excel analysis, master data maintenance, and accurate data entry, with liaison duties across branches and suppliers.

The successful candidate will maintain master data, prepare and analyse Excel reports, and ensure data accuracy in NetSuite while supporting the Purchasing and Inventory Team and providing regular management reports.