Business Intelligence Analyst

Build your best future with the Johnson Controls team 

As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet.  Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard – your next great opportunity is just a few clicks away! 

What we offer: 

• Competitive salary and bonus plan

• Paid vacation/holidays/sick time 

• Comprehensive benefits package including 401K, medical, dental, and vision care 

• On the job/cross training opportunities 

• Encouraging and collaborative team environment 

• Dedication to safety through our Zero Harm policy 

• Check us out!: https://youtu.be/pdZMNrDJviY

What you will do:

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

As a BI 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 are expected to be involved throughout the life cycle of a solution and engage with other teams, departments, and stakeholders.  

How will you do it:

• Become a data SME to advise the business on data solutions and best practices  

• Build relationships to understand the needs of our customers in a variety of business domains to provide deep insights and business decisions

• Create scalable deliverable solutions such as scorecards and dashboards using Power BI and other data visualization tools for various organizational metrics and KPIs

• Develop, implement and optimize Snowflake (SQL) queries and Power BI Dashboards

• Meet with stakeholders to align requirements, communicate progress and deadlines

• Understand data standards and identify data abnormalities. Instill data quality in all solutions delivered

• Elicit business requirements from Subject Matter Experts using interviews, document analysis and user story workshops

• Provides support for existing applications and processes

• Perform statistical analysis, build predictive models, and formulate decision models that relate operational activities to results; to drive value stream enhancement and continuous improvement

What we look for:

• Bachelor’s degree in computer science, Business Management/Administration, Information Technology, or an equivalent discipline

• Fluent English

• 3+ years of experience in a similar role

• Maximize senior leader engagement with and benefits from data-driven insights

• Experience pulling data into BI tools from one or more database technologies (Azure, Snowflake, SQL Server), data warehouse, enterprise gateway and working experience with large data sets

• Demonstrated proficiency defining custom dimensions, writing DAX queries, creating advanced UI/UX in Power BI reports, and tuning performance for a best user experience and adoption

• Experience with AI-driven, low-code solutions and insights; Microsoft Co-Pilot, Snowflake Cortex, Azure AI/ML experience a plus

• Ability to work independently, prioritize tasks and handle multiple projects simultaneously

• Ability to supervise a small team of resources working on one or more Projects/Enhancements

• Willingness to meet challenges, hardworking & able to work under pressure

• Recommend and own improvements to analytics, ability to move fast and be responsive to changing business needs

• Strong problem-solving skills, ability to simplify complex business problems, and excellent communication with non-technical stakeholders

• Proven implementation of creative technology solutions that advanced the business

• Excellent written and oral English communication skills

• Strong written and verbal skills for communication of technical solutions

Experience With The Following Tools:

• Strong knowledge skills of SQL (Snowflake)

• Power BI (Dax)

• Power Apps / Microsoft Flows

• Knowledge of AI, low-code tools; Microsoft Co-Pilot, Snowflake Cortex, Azure AI/ML experience a plus

• Knowledge of R, Python, DAX, JavaScript, or related programming languages a plus

• Must possess and demonstrate excellent verbal, written, and interpersonal communications skills

• Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and organize time effectively

 HIRING SALARY RANGE: $100,000 - $133,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 at https://jobs.johnsoncontrols.com/about-us

#LI-Hybrid

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.