Inventory Coordinator

Smart Resources; Ogden (UT); On-site; USD 24,000 - 34,000; Full time

Job summary

Smart Resources Group is seeking an Inventory Coordinator in Ogden, UT who can manage inventory records on the warehouse floor and in Excel. The role combines hands-on forklift work with data-heavy inventory reporting and pivot-table analysis.

The ideal candidate has forklift experience and strong Excel skills to create pivot tables, maintain spreadsheets, and generate inventory reports that support daily warehouse operations.

Qualifications

• Forklift operation experience is required.
• Strong Microsoft Excel skills are required.
• Hands-on experience creating and using Excel pivot tables is required.
• Experience maintaining and managing spreadsheets.
• Experience in inventory control, warehouse, or inventory coordination.
• Strong data entry and organizational skills.
• Ability to identify and resolve inventory discrepancies.
• Excellent attention to detail and accuracy.
• Ability to work independently and manage multiple priorities.
• Ability to perform both administrative and hands-on warehouse duties.

Responsibilities

• Coordinate and maintain accurate inventory records.
• Operate forklifts to move, stage, and organize inventory as needed.
• Perform regular cycle counts and physical inventory audits.
• Investigate and resolve inventory discrepancies.
• Maintain Excel spreadsheets and inventory tracking reports.
• Create, update, and analyze Excel pivot tables.
• Monitor inventory levels and track incoming and outgoing materials.
• Verify inventory receipts, transfers, and shipments.
• Maintain organized warehouse storage locations.
• Work closely with warehouse, purchasing, and operations teams.
• Identify opportunities to improve inventory accuracy and warehouse efficiency.
• Ensure inventory transactions are accurately documented and entered into the system.

Skills

Forklift operation

Microsoft Excel

Pivot tables

Data entry

Attention to detail

Organizational skills

Independent work

Tools

Excel (pivot tables)

ERP software

Job description

Inventory Coordinator

Job Type: Full-Time Pay: $21/HR DOE Schedule: Day shift Location: Ogden, UT

Job Summary

We are seeking a detail-oriented and organized Inventory Coordinator to oversee inventory accuracy, warehouse organization, and inventory reporting. This position requires a combination of hands‑on warehouse experience and strong computer skills. The ideal candidate will have previous forklift operating experience and advanced Microsoft Excel skills, including the ability to create and work with pivot tables, maintain spreadsheets, analyze inventory data, and generate reports. This role is ideal for someone who is comfortable working on the warehouse floor while also managing inventory records and reporting responsibilities.

Key Responsibilities

• Coordinate and maintain accurate inventory records.
• Operate forklifts to move, stage, and organize inventory as needed.
• Perform regular cycle counts and physical inventory audits.
• Investigate and resolve inventory discrepancies.
• Maintain Excel spreadsheets and inventory tracking reports.
• Create, update, and analyze Excel pivot tables.
• Monitor inventory levels and track incoming and outgoing materials.
• Verify inventory receipts, transfers, and shipments.
• Maintain organized warehouse storage locations.
• Work closely with warehouse, purchasing, and operations teams.
• Identify opportunities to improve inventory accuracy and warehouse efficiency.
• Ensure inventory transactions are accurately documented and entered into the system.

Required Qualifications

• Previous forklift operating experience is required.
• Strong Microsoft Excel skills are required.
• Hands‑on experience creating and using Excel pivot tables is required.
• Experience maintaining and managing spreadsheets.
• Previous inventory control, warehouse, or inventory coordination experience.
• Strong data entry and organizational skills.
• Ability to identify and resolve inventory discrepancies.
• Excellent attention to detail and accuracy.
• Ability to work independently and manage multiple priorities.
• Ability to perform both administrative and hands‑on warehouse duties.
• Must pass background and drug screening

Preferred Qualifications

• Experience with inventory management systems or ERP software.
• Experience with cycle counting and inventory reconciliation.
• Previous experience preparing inventory reports.

What We Are Looking For

We are looking for someone who is equally comfortable operating a forklift and working with Excel spreadsheets. The successful candidate must be able to manage physical inventory while maintaining accurate inventory data, creating pivot tables, and providing reports that support daily warehouse operations.

Please note: Forklift experience, Microsoft Excel proficiency, and pivot table experience are required qualifications for this position.