Senior Business Analyst (hybrid)

YDU JC Air Cond & Ref Inc.- Dubai; Cranston (RI); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Relocation packages

Bonus plan

Benefits package

Job summary

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

The role is hybrid with on-site days in Cranston, RI, and relocation options are available. The ideal candidate has 5+ years in analytics, strong Excel and Power BI skills, and experience handling data from multiple systems to drive continuous improvement.

Qualifications

• 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
• Lean Six Sigma, PMP, or related certifications

Responsibilities

• Own the monthly PMO scorecard process with timely, accurate reporting
• Develop and maintain PMO dashboards and executive scorecards
• Consolidate data from multiple sources to support management decisions
• Identify trends, risks, and opportunities for performance improvement
• Collaborate with Program Management, Engineering, Finance and Operations to standardize reporting

Skills

Analytical skills

Power BI

Excel

Data analytics

PMO analytics

Cross-functional collaboration

Education

Bachelor's degree in Business, Finance, Data Analytics, Information Systems, Engineering, or related field

Tools

Planview

ERP systems

Power Platform

Microsoft Access

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. 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
• Preferred 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.

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