Inventory Data Analyst

About Johnstone Supply

Johnstone Supply is a one-stop shop with a variety of options in unitary and specialty equipment, repair and replacement parts, and maintenance supplies for residential, light commercial, refrigeration, and facilities maintenance. We offer the products, programs, and services that help contractors of all sizes succeed. We're committed to being our customers' HVAC/R resource from start to finish.

With a friendly, fun, and team-oriented environment, our employees know that they are not just a number. We value their hard work and show it through our bonuses, competitive pay, and great benefits.

What We Need From Our Inventory Data Analyst:

• Bachelor's degree in a field like statistics, data analytics, business analytics, supply chain management, or industrial engineering
• 3+ years of experience in inventory, operations, or supply chain analytics
• Advanced Excel proficiency, with knowledge of macros, pivot tables, and Power Query
• Exceptional data analysis skills and comfort with statistics
• Analytical problem-solving abilities
• Working knowledge of inventory management and supply chain methodologies
• Ability to use visualization tools (Power BI, Tableau, etc.) to present data insights
• Comfort using inventory management software and an ERP system like SAP, Oracle, or NetSuite
• Must have the ability to pass a background check

Key Performance Indicators:

• Inventory turnover
• Stockout and order fulfillment rates
• Carrying cost of inventory
• Forecasting and inventory accuracy

What Your Day Is Like:

In collaboration with internal operations, procurement, and warehouse teams, our Inventory Data Analyst is responsible for forecasting inventory needs to maintain optimal stock levels and support company profitability. You'll closely analyze inventory data to identify patterns and areas for improvement. Through effective data analysis, you'll provide valuable insights to management and support accurate demand forecasting.

You'll monitor inventory records, validate data, and strategically plan replenishment orders. If you identify any record discrepancies, you'll investigate and perform root cause analysis of the issue. You'll develop strategies for continually optimizing our inventory management procedures and systems, find ways to reduce carrying costs and stockouts, and track metrics to measure your performance. Your analytical mindset will help refine our inventory strategies and support daily efficiency!

Benefits:

• Medical, dental, and vision insurance
• Prescription coverage
• 401(k) with match
• Company-paid life insurance
• Paid holidays
• Generous PTO
• Supportive and respectful environment