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/sicktime -15 days of vacation first year

• Comprehensive benefits package including 401K, medical, dental, and vision care -Available day one

• Extensive product and on the job/cross training opportunitiesWith outstanding resources

• Encouraging and collaborative team environment

• Dedication to safety through our Zero Harm policy

• Check us Out: A Day in a Life at Johnson Controls:

What you will do:

The BI Analyst (remote) will be responsible for designing 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, 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.

The BI 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 solutions. This person should be able to create their own visualizations using DAX, Power BI, and be able to write SQL/T-SQL queries to pull their own data.
How you will do it:

• Become a data SME in order 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.

• Provide coaching and guidance on analytical modeling, data science best practices and methodologies to internal teams.

• Design and develop tools and products that bring advanced analytic methodologies and models to both analytics team and customers.

• focused on quality 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 analysis.

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

• Perform statistical analysis, build predictive 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.

Qualifications - External

What we look for:

• Minimum 5 years of experience in related business analyst or data/reporting analyst roles.

• Excellent skill level in SQL, PL/SQL.

• In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, Power BI, Power Query, DAX, SQL and T-SQL).

• Advanced knowledge Power BI.

• Proficient in DAX, M language.

• Experience in Extraction, and Transformation and Loading (SSIS).

• Experience in Tabular/OLAP Model (Microsoft SSAS).

• In-depth experience with Associated Development Tools - DevOps, Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS.

• Knowledge of working with database client tools such as Toad.

• Knowledge of Data Mining, Clustering & Statistical Modelling (preferred).

• Experience with Azure Machine Learning (AML). Understanding of Azure and its data services.

• R programming & Python.

• Database Design. Excellent skill level in relational database required. Oracle, MS SQL Server knowledge.

• Proficient in Microsoft Office Suite and O365.

• Superior documentation and organizational skills. Must be detail oriented.

• Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources

• 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.

• Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to exceed expectations.