Inventory Control Data Analyst

Johnstone Supply

Lancaster

JOB DETAILS
SALARY
$55,000–$65,000 Per Year
SKILLS
Analysis Skills, Business Analysis, Business Support, Data Analysis, Data Visualization Tools, Decision Support, Dental Insurance, Detail Oriented, Equipment Maintenance/Repair, Facilities and Maintenance, Forecasting, HVAC, Industrial Engineering, Inventory Costs, Inventory Levels, Inventory Management, Inventory Management Software, Life Insurance, Metrics, NetSuite, Oracle, Order/Customer Fulfillment, Pivot Tables, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Product Programs, Profit & Loss, Purchasing/Procurement, Refrigeration, Reporting Dashboards, Revenue Growth, SAP ECC (fka SAP R/3 and SAP ERP), Statistics, Strategic Planning, Supply Chain, Supply Chain Management, Supply Chain Operations, Tableau, Team Player, Trend Analysis, Vision Plan, Warehousing
LOCATION
Lancaster
POSTED
30+ days ago

If you're a highly attentive and observant person who can uncover valuable insights from data and support informed decision-making, then you could be the next full-time Inventory Control Data Analyst at Johnstone Supply!

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. When you join us in Lancaster, PA, you'll receive:

  • Experience-based salary of $55,000 to $65,000 per year
  • Medical, dental, and vision insurance
  • Prescription coverage
  • 401(k) with match
  • Company-paid life insurance
  • Paid holidays
  • Generous PTO
  • Supportive and respectful environment

Grow your career with a team that will respect you, support you, and treat you well!

INVENTORY CONTROL DATA ANALYST QUALIFICATIONS

  • Bachelor's degree in statistics, data analytics, business analytics, supply chain management, industrial engineering, or a similar field
  • 3+ years of inventory, operations, or supply chain analytics experience
  • Advanced Excel proficiency (macros, pivot tables, Power Query, etc.)
  • Data analysis skills, statistical abilities, and an analytical, solution-oriented mindset
  • Inventory management and supply chain knowledge
  • Ability to present data insights in visualization tools like Power BI or Tableau
  • Ability to learn and use inventory management software and an ERP (SAP, Oracle, NetSuite, etc.)

YOUR DAY-TO-DAY AS OUR INVENTORY CONTROL DATA ANALYST

Meticulous attention to detail and excellent analysis skills are crucial in this role, as you'll be reviewing data to identify trends, uncover patterns, and determine the most cost-effective ways to maintain a well-stocked inventory. By reviewing dashboard metrics daily (stock levels, inventory movement, etc.), you'll understand where we're at and identify growth areas. You'll promptly investigate the cause of unusual variances or record discrepancies and swiftly fix the problem.

To keep our databases neat and accurate, you'll review and validate records while cleansing data when appropriate. You'll support business profitability and revenue growth by developing effective inventory forecasting models for strategic replenishment planning. In case of any supply chain issues, you'll work with the warehouse, procurement, and other teams to find alternative solutions. We're always trying to improve, and you'll continuously evaluate and refine our data analysis strategies. You'll refine dashboards, document insights, and prepare reports for leadership to guide data-driven business decisions.

KPIS

  • Inventory turnover and stockout rate
  • Carrying cost of inventory
  • Forecast and inventory accuracy rates
  • Order fulfillment rate

TAKE THE NEXT STEP IN YOUR CAREER WITH US!

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.

Are you ready to make your mark and drive tangible change as our Inventory Control Data Analyst? Fill out our initial application to get started!


Must have the ability to pass a background check

About the Company

J

Johnstone Supply