Business Intelligence Analyst II – Remote, US

Key Skills

Java Programming, Leadership, Python Programming, SQL, PowerBI, Alteryx, Powerpoint

Job Description

At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers, and manufacturing.

Johnson Controls is developing the next generation of smart and connected. Through a full range of systems and digital solutions, we make buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable.

What you will do

As a Business Intelligence Analyst within the Johnson Controls Global Products Planning organization, you will be responsible for diving deep into large, fragmented, and complex data sets that span our entire supply chain. This position will require a creative problem solver who isn’t afraid to get down into the details and build out digital solutions to unlock productivity within our business. You will build tools to consolidate, analyze, and drive strategic decision making across our supply chain. The Business Intelligence Analyst will be responsible for working with many different stakeholders to understand the problem, identify the solution, and execute on bringing the solution to life.

How you will do it

• Own your projects by crafting project plans, monitering progress, and presenting project updates to stakeholders and senior leadership.
• Build, develop and maintain data models, automated reports, and dashboards that align to strategic performance metrics.
• Craft and develop digital solutions that drive insights into major supply chain metrics such as, On-time Delivery, Days Inventory on Hand, Inventory Health, and Forecast Accuracy.
• Connect with technical teams to identify data tables and schemas needed for analysis.
• Solid understanding of ERPs, MRPs, and Planning databases will be needed to determine how to prep and blend data from different systems.
• Identify and drive process improvement opportunities with digital solutions to increase operational efficiency.
• Apply business intelligence tools to communicate findings and solutions to the problems you are trying to solve.
• Participate in ad-hoc projects as needed

What we look for
Required:

• Bachelor’s degree in Supply Chain, Finance, Data Analytics, Data Science, Computer Science, Information Technology, or related field.
• Experience in crafting complex SQL queries to prep and blend data
• Solid understanding of BI tools such as Alteryx and Power BI
• Demonstrable ability to critically think and creatively problem solve
• Outstanding Microsoft Excel and PowerPoint skills
• Experience using the Microsoft Apps such as Sharepoint, Power Automate, Power Apps, Lists, etc.
• Experience connecting directly to multiple databases to extract, prep, and blend large datasets
• Strong interpersonal, written, and oral communication skills.
• Experience connecting directly to multiple databases to extract, prep, and blend large datasets
• Travel up to 25%

Preferred:

• Experience working in Data Analytics

Where legally permissible, if hired, candidate is required to be fully vaccinated against Covid-19 no later than his/her start date, unless candidate has a valid medical condition or sincerely held religious belief precluding he/she from receiving the vaccine.