Data Science 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  
• Paid vacation/holidays/sick time 
• Comprehensive benefits package including 401K, medical, dental, and vision care - Available day one  
• Extensive product and on the job/cross training opportunities with outstanding internal resources 
• Encouraging and collaborative team environment 
• Dedication to safety through our Zero Harm policy 

Check us Out: A Day in the Life of the Building of the Future https://youtu.be/pdZMNrDJviY

What you will do

• Work with the various Commercial partners to ensure proper data collection, cleansing, processing, and accuracy of our transactional data model.
• Partner with global team members to create and evaluate data driven solutions for both leadership and our product business units through various tools.
• Deliver better data driven business insights through building of predictive models and algorithms using ML and DL techniques.

Team and Function:

• Data & Analytics for the Global Products Commercial organization
• We provide a variety of reporting to the individual sales orgs as well as aggregated Global data up to executive level leadership
• We partner with the sales teams, IT, Finance, and other Global functions to help consolidate data across all JCI brands and products

How you will do it

• Our team has migrated to a Snowflake environment that offers direct access to all JCI system data stored on the same platform. This has allowed our team to provide expedited reporting without the need to worry about ETL processes.
• The main D&A focus has been to capture and normalize daily sales/orders for all Global Products ERP data (50+ systems) and combine this with a bevy of other tools like Salesforce, A/R systems, quoting tools, etc.
• With this work, our team can start to provide more predictive analytics surrounding our customers and products that would otherwise not be possible using just financial numbers.
• We are currently working on a predictive forecasting model built off our data that will help the businesses better accurately forecast sales for the coming months, with a goal to get down to specific customers/products for our plants.
• We are also partnering with IT and other functions to build out a full JCI customer and product master catalog that spans all ERP systems that will help feed various JCI tools.
• JCI is a Microsoft company so outside of Snowflake, we mainly specialize in Power BI as a reporting tool, however we have access to many cleansing tools like Informatica, DemandTools, etc to help with data normalization.

Selling Points:

• You are coming into JCI at a time of expansion surrounding Data & Analytics within the company. Predictive analysis is still very fresh to our business and will provide immediate visibility to leadership if proven effective. Our team itself is a central cog in the Global Products organization that has it's hands in not only Commercial, but Finance, HR, S&OP, IT, etc. Through our commitment to building a normalized Global model, our team has been tapped for many various centralized and function specific projects.
• Our Commercial D&A team itself is small but effective. We have experienced team leads who help guide a collection of skilled analysts and scientists on various projects that range from needing data cleansing, mapping, ETL work, visualization, and prediction.
• The prediction piece is where we see the most growth for this role as we have the normalization and mastering under control, however using that data to make smart decisions for our customers, brands, and products is greatly desired. You would be coming in as one of the few people wit