Forecasting Analyst - Aftermarket Parts

Johnson Controls•Glendale, AZ

1d•Onsite

About The Position

The Forecasting Analyst analyzes and interprets data to create and maintain consensus forecast plans at multiple levels of aggregation. The analyst uses statistical models and insights from Product Management, Sales, and Marketing to forecast expected sales from Johnson Controls parts distribution centers to indirect and direct customers. The role manages forecast plans totaling several hundred million dollars across multiple business units. The position develops and improves forecasts using statistical methods, demand-planning tools, and market intelligence; evaluates forecast performance and errors; leads demand reviews; and collaborates with cross-functional teams to reach consensus. The analyst also partners with the Analytics team on digital solutions for supply-chain metrics and works with inventory optimization and supply planning colleagues to address demand and supply imbalances, improve customer on-time delivery, and optimize inventory. The role supports transitions for end-of-life and newly introduced parts and identifies opportunities to improve planning processes through automation and system enhancements.

Requirements

Bachelor’s degree in Supply Chain, Statistics, Data Science, Business Analytics, or Mathematics.
Five years of proven experience in data analytics, preferably within supply chain and logistics.
Proven experience in statistical analysis, data modeling and manipulation, and predictive analytics.
Willingness to travel domestically and internationally 20–30% of the time.

Nice To Haves

Advanced degree, such as an MS and/or MBA.
Proficiency with statistical and visualization tools such as Python, R, and Power BI.
APICS CPIM certification.
Proficiency with supply-planning software and advanced analytics tools.
Experience collaborating with multiple sites and business units to achieve business objectives.
Strong verbal and written communication competencies.
Familiarity with the building technologies market.

Responsibilities

Develop accurate and reliable forecasts using statistical forecasting models, demand-planning tools, and market intelligence.
Analyze historical sales data, seasonality, and market trends to identify factors influencing aftermarket demand and improve forecast accuracy.
Monitor forecast accuracy and bias, and provide regular reports and analysis to stakeholders.
Identify root causes of forecast errors and implement corrective actions.
Continuously refine and improve forecasting methodologies.
Establish and lead demand review meetings to develop a consensus forecast.
Collaborate with Sales, Marketing, and Product Management to gather input and develop consensus forecasts.
Collect, analyze, and interpret large datasets to identify patterns, correlations, and trends relevant to aftermarket parts planning.
Partner with the Analytics team to develop digital solutions that provide insight into supply-chain metrics, including customer on-time delivery, forecast accuracy and bias, and fill-loss analysis.
Evaluate and compare gaps between the forecast plan and top-down business objectives.
Work with the Inventory Optimization Analyst and Supply Planning team to resolve complex demand and supply imbalances, improve customer on-time delivery, and optimize inventory levels.
Partner with Product Management on transitions for end-of-life parts and new product introductions.
Develop, maintain, and use forecast performance metrics, including forecast accuracy and bias.
Collaborate with cross-functional teams to streamline forecasting and planning processes.
Identify opportunities for automation and system enhancements to improve forecast accuracy and efficiency.