Manager, Inventory Control

Socket.dev; Heath Springs (SC); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid Work Model

401(k) plan with company match

Health, dental, and vision benefits

Paid holidays and generous PTO

Job summary

Pattison ID seeks an Inventory Control Manager to maintain optimal stock levels, analyze trends, and enhance forecasting using AI and advanced Excel. You will lead warehouse staff and partner with Purchasing, Operations, and Production.

The role emphasizes data-driven decision making, ERP data integrity, and continuous improvement in a fast-paced environment.

Qualifications

• Associate's or Bachelor's degree in Supply Chain Management, Business, Operations, Finance, Logistics, or a related field (or equivalent experience).
• Minimum of 2–5 years of inventory planning, inventory control, supply chain, or materials management experience.
• Management Experience – Current staff of (4) employees
• Advanced Microsoft Excel skills, including: PivotTables, XLOOKUP/VLOOKUP, INDEX/MATCHPower Query (preferred), Charts and Dashboards, Data validation and conditional formatting
• Experience using ERP systems (Epicor, SAP, Oracle, Microsoft Dynamics, Infor, or similar – note Epicor is our system and would be a plus).
• Experience utilizing AI tools (such as Microsoft Copilot, Gemini, Claude, ChatGPT, or similar platforms) to improve reporting, forecasting, workflow efficiency, and data analysis.
• Strong analytical and problem‑solving abilities.
• Excellent organizational skills and attention to detail
• Strong written and verbal communication skills.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Monitor and maintain optimal inventory levels to support production and customer demand.
• Analyze inventory data to identify trends, shortages, excess inventory, slow‑moving items, and opportunities for optimization.
• Utilize AI‑powered tools to improve inventory forecasting, demand planning, reporting, and operational efficiency.
• Develop and maintain advanced Excel reports, dashboards, and analytical models using formulas, PivotTables, Power Query, and other advanced features.
• Collaborate with Purchasing, Operations and Production to align inventory strategies with business objectives.
• Investigate inventory discrepancies and partner with warehouse personnel and production managers to resolve variances.
• Monitor inventory accuracy through cycle counts and physical inventory audits.
• Generate inventory performance metrics, including inventory turns, service levels, fill rates, and inventory aging reports.
• Recommend inventory planning improvements based on historical data, market trends, and predictive analytics.
• Assist in implementing inventory control procedures and continuous improvement initiatives.
• Support ERP system data integrity by maintaining accurate inventory records and item master information.
• Prepare management reports and present inventory performance recommendations.

Skills

Advanced Microsoft Excel

ERP systems

AI tools

Analytical abilities

Written and verbal communication

Multitasking

Education

Bachelor's degree in Supply Chain Management or related field

2–5 years inventory planning/control experience

Management experience (4 staff)

Tools

PivotTables

XLOOKUP/VLOOKUP

INDEX/MATCH

Power Query

Power BI

Job description

ABOUT PATTISON ID

Pattison ID is a highly successful, North American company growing organically and through ongoing acquisitions. It is one of the world’s largest sign and physical branding element companies, with manufacturing facilities and operations offices throughout North America, serving customers worldwide.

We believe that outstanding quality, timely delivery, and tailored solutions are the foundation of everything we do. Our culture is built on performance, accountability, and a genuine commitment to nurturing relationships — with our customers, our communities, and each other. We foster an environment where innovation is unleashed, teamwork is proactive, and every employee is empowered to bring their expertise to the work that matters.

Pattison ID operates independently within The Jim Pattison Group, headquartered in Vancouver — one of the largest privately held companies in Canada, with operations spanning the automotive, media, packaging, food sales and distribution, entertainment, and financial industries.

ABOUT THE ROLE

The Inventory Control Manager is responsible for maintaining accurate inventory levels, optimizing inventory performance, and supporting supply chain operations through data-driven planning and analysis. The role includes management of warehouse staff. This role leverages Artificial Intelligence (AI) tools and advanced Microsoft Excel skills to analyze inventory trends, improve forecasting accuracy, automate reporting, and support strategic inventory decisions. The ideal candidate is highly analytical, detail-oriented, and committed to continuous process improvement.

WHAT YOU’LL DO

• Monitor and maintain optimal inventory levels to support production and customer demand.
• Analyze inventory data to identify trends, shortages, excess inventory, slow‑moving items, and opportunities for optimization.
• Utilize AI‑powered tools to improve inventory forecasting, demand planning, reporting, and operational efficiency.
• Develop and maintain advanced Excel reports, dashboards, and analytical models using formulas, PivotTables, Power Query, and other advanced features.
• Collaborate with Purchasing, Operations and Production to align inventory strategies with business objectives.
• Investigate inventory discrepancies and partner with warehouse personnel and production managers to resolve variances.
• Monitor inventory accuracy through cycle counts and physical inventory audits.
• Generate inventory performance metrics, including inventory turns, service levels, fill rates, and inventory aging reports.
• Recommend inventory planning improvements based on historical data, market trends, and predictive analytics.
• Assist in implementing inventory control procedures and continuous improvement initiatives.
• Support ERP system data integrity by maintaining accurate inventory records and item master information.
• Prepare management reports and present inventory performance recommendations.

WHAT YOU’LL NEED TO BE SUCCESSFUL

Required Qualifications

• Associate's or Bachelor's degree in Supply Chain Management, Business, Operations, Finance, Logistics, or a related field (or equivalent experience).
• Minimum of 2–5 years of inventory planning, inventory control, supply chain, or materials management experience.
• Management Experience – Current staff of (4) employees
• Advanced Microsoft Excel skills, including:
  • PivotTables
  • XLOOKUP/VLOOKUP
  • INDEX/MATCHPower Query (preferred)
  • Charts and Dashboards
  • Data validation and conditional formatting
• Experience using ERP systems (Epicor, SAP, Oracle, Microsoft Dynamics, Infor, or similar – note Epicor is our system and would be a plus).
• Experience utilizing AI tools (such as Microsoft Copilot, Gemini, Claude, ChatGPT, or similar platforms) to improve reporting, forecasting, workflow efficiency, and data analysis.
• Strong analytical and problem‑solving abilities.
• Excellent organizational skills and attention to detail
• Strong written and verbal communication skills.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• APICS/ASCM CPIM or CSCP certification.
• Experience with Power BI or other business intelligence tools.
• Knowledge of inventory forecasting methodologies.
• Experience in manufacturing or distribution environments.
• Familiarity with SQL or data visualization software.
• Lean/Six Sigma continuous improvement experience

Knowledge, Skills, and Abilities

• Strong understanding of inventory control principles and supply chain processes.
• Strong interpersonal skills
• Ability to interpret large datasets and transform data into actionable insights.
• Proficiency in AI‑assisted data analysis and process automation.
• Advanced Excel reporting and modeling capabilities.
• Ability to identify process improvement opportunities and recommend solutions.
• Strong collaboration and cross‑functional communication skills.
• High level of accuracy, integrity, and confidentiality.

Physical Requirements

• Ability to sit for extended periods while working at a computer.
• Frequent standing, walking, and occasional lifting of up to 20 pounds.
• Extensive hands on in warehouse or production areas as needed.

Work Environment

• Office environment with regular hands‑on interaction with warehouse and manufacturing personnel.
• Standard business hours with overtime as business needs require.

Success Measures

A successful Inventory Control Manager will:

• Maintain high inventory accuracy.
• Improve inventory turnover while minimizing stockouts.
• Deliver timely and accurate inventory reporting.
• Leverage AI and Excel to automate processes and enhance decision‑making.
• Support continuous improvement initiatives that reduce costs and improve operational efficiency.

WHAT WE OFFER

• 11 paid holidays plus 1 Paid Floating Holiday to recognize a day of personal significance.
• Generous Paid Time Off (PTO) policy.
• Comprehensive health, dental, and vision benefits.
• 401(k) Plan with 100% company match up to 3% of eligible earnings.
• Company‑paid basic life insurance and AD&D coverage.
• Short‑term and long‑term disability coverage.
• Hybrid Work Model (where applicable).
• Opportunities for professional growth and development.
• Collaborative and inclusive work environment.
• Special employee discounts at Ripley’s Believe It or Not, Great Wolf Lodge, and other destinations and services.

Pattison ID is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Accommodations are available upon request for candidates with disabilities throughout the recruitment process.