Principal Business Intell. Analyst, Power BI

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)

Check us Out: A Day in the Life of the Building of the Future you will do

ThePrincipal Business Intelligence Analystwill be responsible for designingand developingholistic business intelligence data engineering and analytic solutions tools and products. This person will be a leader and critical thinker in theirspacebringing knowledge of analyticsthePower BIplatformandBIbest practices. This person will have experienceworking on complex enterprise projects and act as an advisor consultant and partnerto the business.

As aPrincipal Business Intelligence Analyston the team you will be on the forefront of solutioning hands-on data discovery and unifying analytics across the this roleyouwillbe involvedin and leadthroughout the life cycle of a solution and engage with other teams departments and stakeholders.

ThePrincipal Business Intelligence Analystwill 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 automatedreportingsolutions. This person should be able to create their own visualizations using DAX Power BI and be able to write SQLqueries to pull their own data.

Howyou willdo it

• Become a dataSubject Matter Expertin order toadvise the business on data solutions and best practicesutilizing 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 modelingBIbest 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 strongfocus on quality accuracyand 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 exploratorydataanalysis.
• Elicit business requirements from Subject Matter Experts using interviews document analysis and user story workshops.
• Perform statistical analysis buildanalytical datamodels 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

• Minimum5years of experience in related business analyst or data/reporting analyst roles.
• Expert knowledge Power BIdashboard development
• Advancedexperiencein DAXPower Query/M and SQLlanguage.
• Advanced experience with Snowflakeor other cloud database
• In-depth experience with Microsoft analyticsstack (SQL Server SSAS Tabular Power BI Power Query DAX SQL and T-SQL).
• Experiencewith utilizing AI tools such as Microsoft CopilotGithubCopilot and Claude to enhance BI development and delivery
• Experience in Extraction and Transformation and Loading (SSIS).
• Experience in Tabular/OLAP Model (Microsoft SSAS).
• Candidates must be a U.S. citizen or possess valid authorization to work in the United States without current or future sponsorship

HIRING SALARY RANGE: $100000 - $135000 (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 at 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.