Build your best future with the Johnson Controls teamAs a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard – your next great opportunity is just a few clicks away!What we offerCompetitive salary Paid vacation/holidays/sick time -15 days of vacation first yearComprehensive benefits package including 401K, medical, dental, and vision care -Available day oneExtensive product and on the job/cross training opportunitiesWith outstanding resourcesEncouraging and collaborative team environmentDedication to safety through our Zero Harm policyCheck us Out:A Day in a Life at Johnson Controls:What you will doWe are looking for an exceptionally skilled and detail-oriented Inventory Controls Analyst to join our dynamic team at Johnson Controls. This pivotal role transcends typical data analysis; it requires a professional who can decipher complex inventory data and convey clear, impactful narratives that pinpoint critical issues and reveal opportunities for improvement. The ideal candidate will utilize advanced analytical tools such as Power BI and Excel to generate comprehensive reports, engage effectively with stakeholders, and drive significant enhancements in our inventory management processes. Proficiency in ERP/MRP systems, particularly SAP, is essential to guarantee precise inventory oversight, optimize operations, and facilitate data-informed decision-making.How you will do itInventory Analysis & Reporting:- Design, develop, and maintain interactive dashboards and insightful reports in Power BI to meticulously track key inventory metrics, including accuracy, blocked stock, discrepancies, and associated costs.- Employ advanced Excel techniques to dissect data, producing impactful reporting outcomes through trend analysis, detailed graphical representations, and accurate forecasting.ERP/MRP System Management:- Utilize SAP to meticulously monitor inventory transactions, assess stock levels, and confirm order accuracy.- Detect and analyze discrepancies between system records and physical inventory through comprehensive root cause analyses, implementing corrective measures as necessary.- Collaborate in enhancing EWRP/MRP systems by articulating requirements and rigorously testing system updates pertinent to inventory controls.Process Improvement:- Assess existing inventory control processes critically, proposing strategic improvements to enhance accuracy, efficiency, and compliance with Johnson Controls standards.- Partner with cross-functional teams (supply chain, production, finance) to adopt and implement industry best practices in inventory control management.Cycle Counting and Audit Support:- Leverage trending data to advocate for cycle counting initiatives that address investigative findings, ensuring inventory records are reconciled efficiently.- Support the audit process by providing in-depth data analysis and insightful reports to auditors, facilitating a smooth audit experience.What we look for- Bachelor’s degree in supply chain management, business administration, data analytics, or a related field, or equivalent practical experience.- Minimum of 3 years of experience in inventory control, data analysis within a production or manufacturing environment, or a related field.- Extensive hands-on experience with ERP/MRP systems, particularly SAP, is essential.- Proven track record in developing and analyzing dashboards and reports in Power BI.- Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, and macros.- Familiarity with inventory forecasting and demand planning tools is highly desirable.- Exceptional analytical and problem-solving skills with acute attention to detail.- Excellent written and verbal communication skills, enabling effective interaction with diverse stakeholders.- Proven ability to manage multiple tasks and priorities in a fast-paced environment while maintaining high-quality standards.Preferred:- APICS CPIM or CSCP certification- Familiarity with Lean/Continuous Improvement methodologies in Inventory Management is a plus.