Spare Parts Inventory Specialist (SAP/Excel)

Ultimate Staffing; Leominster (MA); On-site; USD 30,000 - 34,000; Full time

Job summary

Ultimate Staffing Services is actively seeking a diligent Spare Parts Inventory Specialist for a semiconductor manufacturing company in Leominster, MA. The role is long-term temporary and starts ASAP, with responsibilities spanning master data updates, part-number documentation, and efficient stockroom organization.

You will work with ERP systems (SAP), CMMS, and Excel to manage parts data, inventories, and supplier information, ensuring accuracy and cross-department collaboration.

Qualifications

• Previous experience in warehousing, maintenance, or trades.
• Experience with ERP systems (e.g., SAP, Oracle, Microsoft Dynamics) preferred.
• Experience with CMMS systems.
• Familiarity with supplier data management and procurement, supply chain management preferred.
• Excellent communication skills with cross-department collaboration (engineering, procurement, master data).
• Strong attention to detail and ability to navigate digital databases.
• Proficient in Excel including functions, VBA, pivot tables and queries; with procurement software tools.
• Previous startup stockroom setup experience preferred but not required.
• Familiarity with lean manufacturing, 5S, and other operational excellence methodologies.
• Background check and drug screen required.
• High school diploma or GED required.

Responsibilities

• Update Master Data Loader for Spare Parts.
• Identify and document hardware part numbers, descriptions, model numbers, and OEM part numbers.
• Sort and organize inventory by equipment.
• Research hardware to obtain all relevant information.
• Navigate and update SAP PIO.
• Set inventory to stockroom level by creating a storage system with location addresses.
• Manage and create complex Excel sheets.

Skills

Warehousing

Maintenance

Procurement

Supply chain

Excel (VBA)

Pivot tables

Data integrity

Education

High school diploma or GED

Tools

SAP

Oracle

Microsoft Dynamics

Job description

Ultimate Staffing Services is actively seeking a diligent Spare Parts Inventory Specialist for a semiconductor manufacturing company in Leominster, MA. The role is long-term temporary and starts ASAP, with responsibilities spanning master data updates, part-number documentation, and efficient stockroom organization.

You will work with ERP systems (SAP), CMMS, and Excel to manage parts data, inventories, and supplier information, ensuring accuracy and cross-department collaboration.