Logo of Huzzle

Home

Matches

Explore

Manage

Data Analyst Intern / Power BI developer

image

Johnson Controls

17d ago

  • Internship
    Full-time
    Off-cycle Internship
  • Data
  • Boca Raton

AI generated summary

  • You should be pursuing a Data Science degree, have SQL knowledge, and skills in Power BI. Strong analytical skills, effective communication, and proficiency in MS Office are essential.
  • You will provide actionable insights through key-metric reporting, enhance KPIs, integrate metrics with PowerBI and Excel, and ensure operational metrics are accurate in ServiceMax.

Requirements

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

Responsibilities

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

FAQs

What is the title of the internship position?

The title of the internship position is Data Analyst Intern / Power BI developer.

What are the core responsibilities of the Data Analyst Intern?

The core responsibilities include providing actionable insights and reporting on key metrics for the Sensormatic Global Operations Leadership team, transforming current KPIs to a higher standard, integrating metrics into Power BI and other business intelligence tools, and ensuring accurate reporting on operational metrics.

What qualifications are needed for this internship?

Candidates should be pursuing a degree in Data Science or have equivalent experience, possess expertise in MS Office, have completed coursework in SQL, and ideally have some knowledge of business intelligence tools like Power BI.

Is fluency in Spanish required for this position?

Fluency in Spanish is beneficial but not required.

What software tools should applicants be familiar with?

Applicants should be familiar with MS Office and ideally have experience with business intelligence tools like Power BI, as well as coursework in SQL.

What type of reporting is expected from the Data Analyst Intern?

The data analyst intern is expected to create and publish accurate, concise, and quality enterprise-level reports using tools like Power BI and Excel.

Are there opportunities for growth within the company?

Yes, there are global advancement opportunities offered within the company.

What benefits are provided to the Data Analyst Intern?

The benefits include competitive starting pay, paid training, comprehensive health insurance, a 401(k) savings plan with company match, and various wellness programs.

Will the intern have any responsibilities related to CRM tools?

Yes, the intern will be responsible for ensuring all required operational metrics are available in the ServiceMax CRM tool or integrated with Power BI and other BI tools.

What are the soft skills required for this position?

Required soft skills include strong analytical and problem-solving skills, effective communication skills, organizational skills, time management skills, and the ability to work cooperatively with others.

Do applicants need to have direct experience with PHP and database management?

While direct experience is not mandatory, completing coursework in PHP, MySQL, Oracle, MSSQL, and related database management concepts is desirable.

What criteria will be used to judge success in this role?

Success in this role will be judged on the timeliness and accuracy of reporting, proficiency with business intelligence tools, and feedback from related teams.

image

Johnson Controls

Government
Industry
10,001+
Employees
1885
Founded Year

Mission & Purpose

At Johnson Controls (NYSE:JCI) we transform the environments where people live, work, learn and play. As the global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. With a history of more than 135 years of innovation, Johnson Controls delivers the blueprint of the future for industries such as healthcare, schools, data centers, airports, stadiums, manufacturing and beyond through its comprehensive digital offering OpenBlue. With a global team of 100,000 experts in more than 150 countries, Johnson Controls offers the world`s largest portfolio of building technology, software as well as service solutions with some of the most trusted names in the industry.