Senior Business Analyst (hybrid)

About Johnson Controls   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.   Visit  johnsoncontrols.com  for more information and follow @Johnsoncontrols on social platforms.

Johnson Controls is hiring! We are seeking a highly analytical Senior Business Analyst who enjoys building structure from complexity. The ideal candidate is equally comfortable working with large datasets, developing Power BI dashboards, creating executive scorecards, and improving business processes through automation. You will possess the business acumen to understand what matters most to leadership and the technical skills to transform disparate data sources into meaningful insights that drive better decision-making across the organization, and you should also be highly analytical and a self-starter who enjoys solving complex business problems, working with large datasets, and translating data into concise, executive-level insights.   The Senior Business Analyst, Fire Suppression PMO, is responsible for managing, analyzing, and transforming business and portfolio data into actionable insights that support decision-making across the organization. This role serves as the primary owner of PMO scorecards, performance metrics, dashboards, and executive reporting processes.   Working closely with Program Management, Engineering, Operations, Finance, Procurement, and functional leaders, the Business Analyst will consolidate data from multiple systems and sources to develop accurate, timely, and meaningful performance reporting. The successful candidate will leverage advanced Excel, Power BI, and analytical skills to streamline reporting processes, improve data visibility, and create scalable business intelligence solutions.   This is a hybrid position that requires you to be onsite 3 days per week. Candidates must be commuting distance to Cranston, RI, or able to relocate. Various relocation packages are available. Candidates must be US citizens and/or permanent residents, as sponsorship is not available for this position.   How you will do it Business Analytics & Reporting   Own the monthly PMO scorecard process, ensuring timely, accurate, and consistent reporting of key performance metrics.   Collect, validate, consolidate, and analyze data from multiple business systems and reporting sources.   Develop, maintain, and enhance executive scorecards, dashboards, and business performance reports.   Perform trend analysis and identify business insights, risks, opportunities, and performance improvement areas.   Create clear and compelling visualizations that effectively communicate business performance to leadership.   Ensure data integrity and consistency across all PMO and organizational reporting.   Produce recurring and ad hoc management reports supporting strategic decision-making.   Present findings and recommendations to management and cross-functional stakeholders.     Data Management & Business Intelligence   Develop and maintain Power BI dashboards and reporting solutions.   Utilize advanced Excel tools including Pivot Tables, Power Query, data models, and complex formulas to support reporting and analysis.   Consolidate information from multiple sources including Excel workbooks, Access databases, Planview, ERP systems, Power BI reports, and other business applications.