Forecasting Analyst - Aftermarket Parts

Johnson Controls, Inc.; Milwaukee (WI); On-site; USD 88,000 - 121,000; Full time

Job summary

Johnson Controls, Inc. seeks a data-driven Analyst to own forecast planning and demand analysis across multiple product lines. You will build and maintain consensus forecast plans, using statistical models and market intelligence to drive accuracy and alignment with business goals.

The role collaborates with Sales, Marketing and Product Management, analyzes large datasets, tracks forecast performance, and leads review meetings. Domestic and international travel is expected (20-30%).

Qualifications

• Bachelor’s degree in Supply chain, Statistics, Data Science, Business Analytics, or Mathematics.
• 5 years of proven experience in data analytics preferably within Supply chain and logistics.
• Proven experience in statistical analysis, data modelling and manipulation and predictive analytics.
• Willingness to travel both domestic and internationally (20-30%) to develop firsthand understanding of sites and the wider organizational challenges.

Responsibilities

• Develop accurate and reliable forecast by utilizing statistical forecasting models, demand planning tools and market intelligence.
• Analyze historical sales data, seasonality, market trends to identify key factors influencing aftermarket demand and improve forecast accuracy.
• Monitor forecast accuracy, forecast 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 consensus forecast.
• Collaborate with cross functional teams, including sales, marketing, and product management to gather inputs and develop consensus forecast.
• Collect, analyze, and interpret large datasets. Identify patterns, correlations, and trends to extract meaningful insight for aftermarket parts planning.
• Partner with Analytics team to develop digital solutions that drive insight into major supply chain metrics such as Customer On-time delivery, Forecast accuracy and bias, fill loss analysis.
• Evaluate, compare and define gaps in forecast plan against top-down business objectives.
• Work closely with Inventory optimization analyst and Supply planning team to resolve complex demand/supply imbalance while improving customer OTD and optimizing inventory levels.
• Partner with Product Management to successfully transition parts, both end of life and new product introduction.
• Develop, maintain, and leverage Forecast performance metrics including forecast accuracy, forecast 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.

Skills

Forecasting

Data analysis

Statistics

Python

R

Power BI

Education

Bachelor's degree in Supply chain, Statistics, Data Science, Business Analytics, or Mathematics

Tools

Python

R

Power BI

Job description

About Us

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education.

For more than 140 years, Johnson Controls has delivered performance where it really matters. Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

Become part of a culture that celebrates your achievements and encourages your voice and ideas. Your next great opportunity for advancement is right at your fingertips! Take the initiative to explore your potential and embark on an exciting career journey with Johnson Controls.

What you will do:

The Analyst will play a vital role in analyzing and interpreting data to create and maintain the consensus forecast plan at multiple levels of aggregation, using statistical models, and leveraging insights from Product Management, Sales, and Marketing. The consensus forecast plan includes expected sales from JCI parts distribution centers to indirect and direct customers. This role is responsible to manage forecast plan of several hundred million dollars across multiple business units.

How you will do it:

• Develop accurate and reliable forecast by utilizing statistical forecasting models, demand planning tools and market intelligence.
• Analyze historical sales data, seasonality, market trends to identify key factors influencing aftermarket demand and improve forecast accuracy.
• Monitor forecast accuracy, forecast 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 consensus forecast.
• Collaborate with cross functional teams, including sales, marketing, and product management to gather inputs and develop consensus forecast.
• Collect, analyze, and interpret large datasets. Identify patterns, correlations, and trends to extract meaningful insight for aftermarket parts planning.
• Partner with Analytics team to develop digital solutions that drive insight into major supply chain metrics such as Customer On-time delivery, Forecast accuracy and bias, fill loss analysis.
• Evaluate, compare and define gaps in forecast plan against top-down business objectives.
• Work closely with Inventory optimization analyst and Supply planning team to resolve complex demand/supply imbalance while improving customer OTD and optimizing inventory levels.
• Partner with Product Management to successfully transition parts, both end of life and new product introduction.
• Develop, maintain, and leverage Forecast performance metrics including forecast accuracy, forecast 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.

What we look for:

• Bachelor’s degree in Supply chain, Statistics, Data Science, Business Analytics, or Mathematics.
• 5 years of proven experience in data analytics preferably within Supply chain and logistics.
• Proven experience in statistical analysis, data modelling and manipulation and predictive analytics.
• Willingness to travel both domestic and internationally (20-30%) to develop firsthand understanding of sites and the wider organizational challenges.

Preferred:

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

HIRING SALARY RANGE: $88,000- 121,00(Salary to be determined by the education, experience,knowledge, skills, and abilities of the applicant, internal equity, and alignment with marketdata.) This position includes a competitive benefits package. The posted salary range reflectsthe target compensation for this role. However, we recognize that exceptional candidatesmay bring unique skills and experiences that exceed the typical profile. If you believe yourbackground warrants consideration beyond the stated range, we encourage you to apply. Tosupport an efficient and fair hiring process, we may use technology assisted tools, includingartificial intelligence (AI), to help identify and evaluate candidates. All hiring decisions areultimately made by human reviewers. For details, please visit the About Us tab on theJohnson Controls Careers site at https://jobs.johnsoncontrols.com/about-us