Principal Business Intell. Analyst, Power BI

What You Will Do

The Principal Business Intelligence Analyst will be responsible for designing and developing holistic business intelligence, data engineering, and analytic solutions, tools, and products. This role will involve leading complex enterprise projects, serving as an advisor, consultant, and partner to the business, and unifying analytics across the organization.

• 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.
• Create visualizations using DAX, Power BI, and write SQL queries to pull data.
• Develop tools and products that bring advanced analytic methodologies and models to both the analytics team and customers.

Become a data subject‑matter expert, advise the business on data solutions and best practices, build relationships, provide coaching on analytical modeling, and communicate effectively in an Agile environment.

• Design and develop scalable deliverable solutions such as scorecards and dashboards using Power BI and other data visualization tools.
• Perform ad‑hoc exploratory data analysis and statistical analysis, building analytical data models to drive value stream enhancement and continuous improvement.
• Identify data abnormalities and instill data quality in all solutions delivered.

• Minimum 5 years of experience in related business analyst or data/reporting analyst roles.
• Expert knowledge of Power BI dashboard development.
• Advanced experience in DAX, Power Query, and SQL.
• 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 AI tools such as Microsoft Copilot, Git Hub Copilot, and Claude to enhance BI development and delivery.
• Experience in Extraction, Transformation and Loading (SSIS) and Tabular/OLAP Model (Microsoft SSAS).
• U.S. citizen or possess valid authorization to work in the United States without current or future sponsorship.

Hiring Salary Range: $100,000 - $135,000. This role offers a competitive bonus plan and a comprehensive benefits package.

Johnson Controls International plc. is an equal‑employment‑opportunity and affirmative action employer. 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. For more information about your equal‑opportunity and non‑discrimination rights, visit EEO is the Law.

For disability accommodations during the application process, see the relevant information on the Johnson Controls Careers site.

All hiring decisions are ultimately made by human reviewers. We may use technology‑assisted tools, including AI, to assist in identifying and evaluating candidates.