HVAC Inventory Data Analyst - Travel Required

Johnstone Supply; Lancaster (Lancaster County); On-site; USD 55,000 - 65,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Prescription coverage

401(k) with match

Company-paid life insurance

Paid holidays

Generous PTO

Supportive environment

Job summary

Johnstone Supply's Lancaster, PA team is seeking an experienced HVAC Inventory Data Analyst who travels. This full-time role focuses on forecasting inventory needs and optimizing stock levels to support profitability.

You will analyze inventory data, identify patterns, validate records, and plan replenishments while partnering with operations, procurement, and warehousing to reduce carrying costs. Strong Excel skills, experience with Power BI or Tableau, and familiarity with SAP, Oracle, or

Qualifications

• Bachelor's degree in statistics, data analytics, business analytics, supply chain management, or industrial engineering
• 3+ years of experience in inventory, operations, or supply chain analytics
• HVAC experience preferred
• Advanced Excel proficiency, with 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 ERP systems (SAP/Oracle/NetSuite)

Responsibilities

• Forecast inventory needs to maintain optimal stock levels and support profitability
• Analyze inventory data to identify patterns and improvement opportunities
• Validate data, monitor records, and plan replenishment orders
• Investigate discrepancies and perform root cause analysis
• Develop strategies to optimize inventory management procedures and reduce carrying costs
• Track KPIs to measure performance and refine inventory strategies

Skills

Analytical thinking

Data analysis

Excel advanced

Forecasting

Problem solving

Communication

Education

Bachelor's degree in statistics/data analytics/supply chain/industrial engineering

Tools

Power BI

Tableau

Excel macros/pivot/Power Query

SAP

Oracle

NetSuite

Job description

Analytical problem solver needed at Johnstone Supply!

Our Lancaster, PA team is hiring an experienced HVAC Inventory Data Analyst - Travel Required to join us full-time and enhance our inventory management strategies.

Depending on experience, you'll earn $55,000 to $65,000 per year.

You'll also enjoy generous benefits, such as:

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

If this sounds like the right position for you, keep reading.

WHAT WE NEED FROM OUR HVAC 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
• HVAC Experience preferred
• 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

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!

ABOUT OUR COMPANY:

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.

Must have the ability to pass a background check