Forecasting Analyst - Aftermarket Parts

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

Benefits offered by this job

Competitive benefits package

Job summary

Johnson Controls is seeking a skilled Analyst to join its Milwaukee team. You will analyze data and maintain consensus forecast plans across multiple business units, handling several hundred million dollars in annual demand for aftermarket parts and related products.

You will build accurate forecasts using statistical models, monitor forecast performance, and work with sales, marketing, and product management to align plans with business objectives, while exploring automation opportunities to

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.
• Proficiency in statistical analysis, data modelling and manipulation and predictive analytics.

Responsibilities

• Develop accurate and reliable forecast using statistical forecasting models and demand planning tools.
• Analyze historical sales data, seasonality, and market trends to improve forecast accuracy.
• Monitor forecast accuracy, bias and provide regular reports to stakeholders.
• Identify root causes of forecast errors and implement corrective actions.
• Lead demand review meetings to develop consensus forecast.
• Collaborate with sales, marketing and product management to gather inputs and develop consensus forecast.

Skills

Statistical analysis

Data modelling

Predictive analytics

Education

Bachelor's degree

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 market data.)

This position includes a competitive benefits package.

The posted salary range reflects the target compensation for this role.

However, we recognize that exceptional candidates may bring unique skills and experiences that exceed the typical profile.

To support an efficient and fair hiring process, we may use technology assisted tools, including artificial intelligence (AI), to help identify and evaluate candidates. All hiring decisions are ultimately made by human reviewers.

For details, please visit the About Us tab on the Johnson Controls Careers site at http