Data Analyst

At JCI, we are committed to becoming the global leader in smart, healthy, and sustainable buildings. Our mission is to redefine building performance to better serve people, places, and the planet. We invite you to join our winning team and build your best future with us! Our diverse teams have the opportunity to support a wide range of industries worldwide, and we are dedicated to your professional development through impactful projects and continuous learning. Enjoy our supportive work environment focused on enhancing your physical, financial, and emotional wellbeing.
 
What We Offer
Competitive salary and bonus
Paid vacation/holidays/sick time
Comprehensive benefits package including 401K, medical, dental, and vision care starting day one!
Developmental opportunities
Encouraging and collaborative team environment
Dedication to safety through our Zero Harm policy

A Day in the Life - Engineering: http://www.youtube.com/watch?v=ZtUwSd41LgM&t=136s

**This position is not eligible for visa sponsorship

What you will do

You will be responsible for developing automated tools/templates to improve the efficiency and quality of plant operations in a timely manner. You will perform in-depth analysis of problem statements and provide solutions through an automated approach. You will identify areas of improvement with engineering, quality, and operations leadership.

How you will do it

• Work with Engineering team members from various domains to understand the automation requirements. 

• Ensure the user-friendly graphics of the generated tools/templates. 

• Prepare logs for each tool for future correction and development purposes. 

• Prepare standard operating procedures for all developed reports. 

• Prepare guidelines for the usage of the developed tool. 

• Get prompt feedback from users and resolve all reported bugs. 

• Identify all manual efforts and automate them to improve productivity. 

• Work on Power BI to create visually impactful dashboards and reports. 

• Design Power Automate workflows to extract Power BI data to shared locations and automate email notifications. 

• Use VBA scripting to schedule tasks and automate repetitive processes efficiently. 

• Develop solutions for integrating data across MS Excel, SharePoint, and other platforms. 

• Provide training sessions for end-users to maximize tool usability. 

• Optimize Power Query processes for faster execution times and enhanced tool performance. 

• Explore opportunities for integrating AI-based solutions like ChatGPT API (or similar technologies) for advanced data analysis within Excel environments. 

• Develop tools and provide training for team members 

• Opportunity to leverage data science knowledge in solving issues 

• Support engineering team members to complete their continuous improvement ideas in case automation is needed 

• Collaborate with automation community/experts/forums to get the solution for complex situations without disclosing organizational confidential data 

What we look for

Required

• Bachelor’s / Master’s degree in Computer Science 

• Min 3+ years of experience in Power BI tool development 

• Experience in paginated reports (Report Builder) 

• Proficiency in SQL queries, report generation, and Power Query 

• Should be able to handle large data/datasets 

• Excellent skills in MS Excel, VBA development, MS PowerPoint, and SharePoint 

#LI-Onsite

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.