Forecasting Analyst - Aftermarket Parts

Johnson Controls; Glendale (CA); On-site; USD 88,000 - 121,000; Full time

Job summary

Johnson Controls seeks an experienced Analyst to drive consensus forecasts for aftermarket parts across multiple business units. You will develop forecasts using statistical models, analyze sales data and market trends, and partner with Sales, Marketing, and Product Management to build a reliable demand plan valued in hundreds of millions of dollars.

The role requires a bachelor’s degree in a related field and 5+ years in data analytics within supply chain/logistics.

Qualifications

• Bachelor’s degree in Supply chain, Statistics, Data Science, Business Analytics, or Mathematics.
• Proven experience in data analytics within supply chain/logistics (5+ years).
• Proficiency in Python, R, and Power BI for modeling and visualization.
• APICS CPIM certification is a plus.

Responsibilities

• Develop accurate forecasts using statistical models, demand planning tools, and market intelligence.
• Analyze historical sales, seasonality, and trends to improve forecast accuracy.
• Monitor forecast performance and report to stakeholders; identify root causes of errors.
• Collaborate with cross-functional teams to gather inputs and build consensus forecasts.
• Lead demand review meetings and drive automation to improve forecasting processes.
• Partner with Product Management to transition parts (end of life and new).
• Analyze large datasets to extract insights for aftermarket parts planning.
• Support inventory optimization and supply planning to balance demand with capacity.

Skills

Python

R

Power BI

Education

Bachelor's degree in a related field (Supply chain/Statistics/Data Science/Business Analytics/Mathematics)

MS or MBA (preferred)

Job description

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.

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 https://jobs.johnsoncontrols.com/about-us Johnson Controls International plc. is an equal employment opportunity and affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, genetic information, sexual orientation, gender identity, status as a qualified individual with a disability or any other characteristic protected by law.

To view more information about your equal opportunity and non-discrimination rights as a candidate, visit EEO is the Law.

If you are an individual with a disability and you require an accommodation during the application process, please visit here.

Johnson Controls: Enhancing the Intelligence of Buildings Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.