Data Analyst Intern / Power BI developer

We are one team, dedicated to working collaboratively to create the purposeful solutions that propel the world forward. We hope you will join our diverse team of top people – you bring your talent, and we’ll give you the space and opportunities to grow and succeed.  We are committed to make a difference. 

What we offer: 

• Competitive Starting Pay 

• Paid Training 

• Global Advancement Opportunities 

• Company Vehicle (as applicable) 

• Referral Bonuses 

• Comprehensive Benefits 

• Medical/Dental/Vision insurance 

• Health Savings Account (HAS) 

• Life Insurance 

• 401(k) savings plan with company match 

• Short-Term and Long-Term Disability 

• Employee Assistance Program 

• Wellness Program 

• And More!  

What You’ll Do:

The Analyst is a role focused on providing actionable insights and key-metric reporting for Sensormatic Global Operations Leadership team. This role is part of a group supporting our larger Sensormatic family to provide reporting on operational metrics. In addition to simply running existing metrics, this individual will be responsible for transforming the current list of KPIs to a higher standard and to ensure accuracy. The role will also be involved with integrating the current metrics into the PowerBI, Excel or other business intelligence tools. As the organization utilizes the ServiceMax CRM tool, this individual will be responsible for ensuring all required Ops metrics are available either within the system itself or integrated with PowerBI, or other BI tools inside and outside the cloud data environment. Success in this role will be judged on timeliness and accuracy of reporting, proficiency with business intelligence tools, and feedback from related teams.

What You Need:

• Pursuing degree in Data Science (or equivalent experience) and fluency in the English language.
• Fluency is Spanish (Reading, writing, and speaking) is beneficial but not required.
• Expertise in MS Office and other software tools.
• Coursework in SQL.
• Interest in learning Salesforce data analysis and extraction.
• Ability to communicate ideas effective.
• Strong analytical and problem-solving skills.
• Experience using business intelligence tools such as PowerBI to create and publish accurate, concise and quality enterprise level reporting.
• Knowledge of data base structure and design.
• Ability to learn statistical forecasting methods and ability to interpret data trends through analysis.
• Ability to interact with business stakeholders to gather their business requirements and translate them into functional requirements for the data engineers to build reports in Google Cloud environment.
• Ability to build reports and dashboards to track performance in inventory optimization across field operations.
• Strong organizational and time management skills
• Exercise good judgment, including when to seek input from your supervisor(s)/ team members.
• Willingness to learn new systems and processes.
• Work cooperatively with others.

Completed or Pursuing coursework in the following:

• PHP, MySQL, Oracle, MSSQL skills.
• PHP Apps using Oracle databases MSSQL & MySQL.

Reporting:

• Excel
• SQL knowledge
• PowerB

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.