Job Description
Job Description
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