Sr. Business Intelligence Analyst

Johnson Controls, Inc.; Milwaukee (WI); On-site; USD 85,000 - 120,000; Full time

Job summary

Johnson Controls, Inc. is seeking a Business Analyst IV to support design and development of BI solutions, data engineering, and analytics products. You will work with Power BI, writing DAX and SQL queries, to deliver dashboards, scorecards, and forecasting models across the organization.

You will gather requirements from stakeholders, collaborate in an Agile environment, and ensure data quality while building scalable analytics that enable better decisions and measurable business outcomes.

Qualifications

• 3+ years in a business/ data/reporting analyst role.
• Experience with Power BI dashboard development.
• Experience with DAX, Power Query/M, and SQL.
• Experience with Snowflake or cloud databases.
• Exposure to Microsoft analytics stack (SQL Server, SSAS Tabular, Power BI, DAX, SQL).
• Experience using AI tools to enhance BI development.

Responsibilities

• Develop knowledge of data domains to support BI solutions within Power BI.
• Build relationships with internal customers to understand needs.
• Collaborate with senior teammates on modeling and BI best practices.
• Communicate effectively within an Agile team.
• Support design of BI tools and products for analytics team.
• Maintain quality and accuracy in deliverables.
• Create scorecards and dashboards for KPIs.
• Perform ad-hoc exploratory data analysis.
• Assist in gathering requirements via interviews and workshops.
• Support statistical analysis and data models linked to operations.
• Identify data quality issues and enforce data standards.

Skills

Data analysis

Stakeholder communication

Agile methodologies

Team collaboration

Exploratory data analysis

Tools

Power BI

DAX

Power Query/M

SQL

Snowflake

SSAS Tabular

Job description

About Us

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 you will do

The Business Analyst IV will support the design and development of business intelligence, data engineering, and analytic solutions, tools, and products. This person will bring solid working knowledge of analytics, the Power BI platform, and BI best practices, and will contribute to complex, enterprise projects under the guidance of senior team members.

As a Business Analyst IV on the team, you will participate in data discovery, dashboard development, and analytics delivery across the organization. In this role, you will support multiple phases of the solution lifecycle and work closely with other teams, departments, and stakeholders.

The Business Analyst IV will contribute to 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 comfortable building their own visualizations using DAX and Power BI, and writing SQL queries to pull their own data.

How you will do it

• Develop working knowledge of data domains in order to support the business with data solutions and BI best practices, utilizing Power BI.
• Build relationships to understand the needs of internal customers across business domains to help provide insights that support decisions.
• Collaborate with and learn from senior teammates on analytical modeling, BI best practices, and methodologies.
• Communicate and collaborate effectively with teammates and business partners in an Agile work methodology.
• Support the design and development of tools and products that bring analytic methods and models to the analytics team and customers.
• Maintain a strong focus on quality, accuracy, and customer experience.
• Contribute to scalable deliverables such as scorecards and dashboards using Power BI and other data visualization tools for organizational metrics and KPIs.
• Perform ad-hoc exploratory data analysis.
• Assist in gathering business requirements from stakeholders through interviews, document analysis, and user story workshops.
• Support statistical analysis, analytical data models, and decision models that relate operational activities to results.
• Understand data standards and help identify data abnormalities, supporting data quality across delivered solutions.

What we look for

Required

• Minimum 3 years of experience in a related business analyst or data/reporting analyst role.
• Working knowledge of Power BI dashboard development.
• Experience with DAX, Power Query/M, and SQL language.
• Experience with Snowflake or other cloud database platforms.
• Exposure to the Microsoft analytics stack (SQL Server, SSAS Tabular, Power BI, Power Query, DAX, SQL and T-SQL).
• Experience utilizing AI tools such as Microsoft Copilot, Github Copilot, and Claude to enhance BI development and delivery.
• Candidates must be a U.S. citizen or possess valid authorization to work in the United States without current or future sponsorship.