Senior Business Analyst (hybrid)

Johnson Controls; Cranston (RI); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive benefits package

Bonus plan

Job summary

Johnson Controls is seeking a Senior Business Analyst to transform data into actionable insights. You will own PMO scorecards, dashboards, and performance reporting, collaborating with cross-functional teams to improve data visibility and decision-making.

The role requires advanced Excel and Power BI skills, experience with large datasets, and the ability to automate reporting processes. Hybrid onsite work to Cranston, RI area.

Qualifications

• Bachelor's degree in a related field and 5+ years in analytics/BI/PMO analytics or finance.
• Experience building and maintaining PMO scorecards and executive dashboards.

Responsibilities

• Own the PMO monthly scorecard process with timely, accurate reporting.
• Develop and maintain Power BI dashboards and executive reports.
• Lead data consolidation from multiple systems to improve reporting efficiency.
• Identify data quality issues and automate reporting processes.
• Collaborate with PMO, Engineering, Finance, Operations and leadership to define metrics.

Skills

Advanced Excel

Power BI

Data modeling

Dashboard creation

Pivot Tables

Power Query

Complex formulas

Strong business acumen

Large datasets

Education

Bachelor's Degree in Business/Finance/Data Analytics/IS/Engineering

Tools

Planview

ERP systems

Microsoft Access

Power Platform tools

Job description

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.

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 socialplatforms.

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