Principal Business Intell. Analyst, Power BI

Principal Business Intelligence Analyst

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.

What we offer

• Competitive salary and bonus plan
• Paid vacation/holidays/sick time - 15 days of vacation first year
• Comprehensive benefits package including 401K, medical, dental, and vision care - Available day one
• Encouraging and collaborative team environment
• Dedication to safety through our Zero Harm policy
• JCI Employee discount programs (The Loop by Perk Spot)

The Principal Business Intelligence Analyst will be responsible for designing and developing holistic business intelligence, data engineering and analytic solutions, tools, and products. This person will be a leader and critical thinker in their space bringing knowledge of analytics, the Power BI platform, and BI best practices. This person will have experience working on complex, enterprise projects and act as an advisor, consultant, and partner to the business.

As a Principal Business Intelligence Analyst on the team, you will be on the forefront of solutioning, hands-on data discovery, and unifying analytics across the organization. In this role, you will be involved in and lead throughout the life cycle of a solution and engage with other teams, departments, and stakeholders.

The Principal Business Intelligence Analyst will handle complex projects utilizing multiple tools and technologies to deliver quality products such as ad-hoc data discovery requests, dashboards and scorecards, forecasting models and automated reporting solutions. This person should be able to create their own visualizations using DAX, Power BI, and be able to write SQL queries to pull their own data.

How you will do it

• Become a data Subject Matter Expert in order to advise the business on data solutions and best practices utilizing your technical BI expertise in Power BI.
• Build relationships to understand the needs of our customers in a variety of business domains to provide deep insights and business decisions.
• As a leader on the team, provide coaching and guidance on analytical modeling, BI best practices and methodologies to internal teammates.
• Communicate and collaborate effectively with teammates and business partners in an Agile work methodology.
• Design and develop tools and products that bring advanced analytic methodologies and models to both analytics team and customers.
• A strong focus on quality, accuracy, and customer experience.
• Create scalable deliverable solutions such as scorecards and dashboards using Power BI and other data visualization tools for various organizational metrics and KPIs.
• Perform ad-hoc exploratory data analysis.
• Elicit business requirements from Subject Matter Experts using interviews, document analysis and user story workshops.
• Perform statistical analysis, build analytical data models, and formulate decision models that relate operational activities to results; to drive value stream enhancement and continuous improvement.
• Understand data standards and identify data abnormalities. Instill data quality in all solutions delivered.

What we look for Required

• Minimum 5 years of experience in related business analyst or data/reporting analyst roles.
• Expert knowledge Power BI dashboard development
• Advanced experience in DAX, Power Query/M, and SQL language.
• Advanced experience with Snowflake or other cloud database
• In-depth experience with Microsoft analytics stack (SQL Server, SSAS Tabular, Power BI, Power Query, DAX, SQL and T-SQL).
• Experience with utilizing AI tools such as Microsoft Copilot, Github Copilot, and Claude to enhance BI development and delivery
• Experience in Extraction, and Transformation and Loading (SSIS).
• Experience in Tabular/OLAP Model (Microsoft SSAS).

HIRING SALARY RANGE: $100,000 - $135,000 (Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, location and alignment with market data.) This role offers a competitive Bonus plan that will take into account individual, group, and corporate performance. 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. This position includes a competitive benefits package. For details, please visit the About Us tab on the Johnson Controls Careers site.

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.