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.
What you will do
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.
Identify opportunities to automate data collection, aggregation, and reporting processes.
Support development of standardized data structures and reporting methodologies.
Serve as a subject matter expert for PMO reporting, business metrics, and data visualization.
Process Improvement
Evaluate existing reporting tools and processes and recommend improvements.
Lead initiatives to simplify, standardize, and automate reporting activities.
Partner with stakeholders to improve data quality, accessibility, and reporting efficiency.
Develop scalable solutions that reduce manual effort and improve organizational visibility.
Support continuous improvement initiatives through data analysis and performance measurement.
Cross-Functional Collaboration
Work closely with Program Managers, Engineering, Finance, Operations, Supply Chain, and leadership teams to understand reporting requirements and business needs.
Facilitate alignment around key performance indicators, business metrics, and reporting standards.
Support leadership reviews through preparation of data-driven presentations and performance summaries.
Qualifications
Required
Bachelor's Degree in Business, Finance, Data Analytics, Information Systems, Engineering, or a related field
5+ years of experience in Business Analytics, Data Analytics, Business Intelligence, PMO Analytics, Financial Analysis, or a related role
Advanced Microsoft Excel skills
Pivot Tables
Power Query
Complex formulas
Data modeling
Dashboard creation
Advanced Power BI experience, including dashboard and report development
Experience working with large and complex datasets from multiple business systems
Strong business acumen and ability to translate data into actionable insights
Candidates must be US citizens and/or permanent residents, as sponsorship is not available for this position
Preferred
Experience in a manufacturing, engineering, product development, or operations environment
Experience with Planview, ERP systems, Power Platform tools, or Microsoft Access databases
Familiarity with project portfolio management and PMO processes
Experience supporting Value Analysis/Value Engineering (VAVE) initiatives or cost-reduction programs
Experience developing automated reporting and business intelligence solutions
Lean Six Sigma, PMP, or related certifications
HIRING SALARY RANGE: $120,000 - 150,000 (Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data.) This role offers a competitive Bonus plan that will take into account individual, group, and corporate performance. 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. If you believe your background warrants consideration beyond the stated range, we encourage you to apply. 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
#LI-ONSITE
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.
Skills Required
- Bachelor's degree in Business, Finance, Data Analytics, Information Systems, Engineering, or a related field
- 5+ years of experience in Business Analytics, Data Analytics, Business Intelligence, PMO Analytics, Financial Analysis, or a related role
- Advanced Microsoft Excel skills
- Pivot Tables
- Power Query
- Complex formulas
- Data modeling
- Dashboard creation
- Advanced Power BI experience, including dashboard and report development
- Experience working with large and complex datasets from multiple business systems
- Strong business acumen and ability to translate data into actionable insights
- US citizenship and/or permanent residency; visa sponsorship is unavailable
- Experience in a manufacturing, engineering, product development, or operations environment
- Experience with Planview, ERP systems, Power Platform tools, or Microsoft Access databases
- Familiarity with project portfolio management and PMO processes
- Experience supporting Value Analysis/Value Engineering initiatives or cost-reduction programs
- Experience developing automated reporting and business intelligence solutions
- Lean Six Sigma, PMP, or related certifications
Johnson Controls Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Johnson Controls and has not been reviewed or approved by Johnson Controls.
-
Retirement Support — Retirement support is positioned as a meaningful part of the package through employer 401(k) matching, repeatedly framed as a strong pillar of the overall rewards mix. The matching contribution is described with specific match levels in multiple places, reinforcing perceived value for long-term saving.
-
Leave & Time Off Breadth — Time off is presented as comparatively robust, with multiple paid holiday categories, vacation time, and sick time described as generous or “amazing” in places. Paid time off breadth appears to be a consistent contributor to total rewards attractiveness beyond base pay.
-
Flexible Benefits — Benefits are described as broad and customizable, spanning standard medical/dental/vision plus optional add-ons like pet insurance, identity protection, and legal support. Tuition reimbursement is repeatedly highlighted as a high-value option supporting professional development.
Johnson Controls Insights
What We Do
At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission. Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.
