Business Intern, Business Analytics

Johnson Controls; Singapore; On-site; SGD 13,000 - 27,000; Full time

Job summary

Johnson Controls in Singapore is seeking a driven intern to support APAC Service Growth initiatives. You will design and implement Power BI dashboards, perform data modeling, and help forecast revenue and capacity by analyzing market dynamics.

You will use SQL and DAX for data extraction and modeling, and Python or R for data analysis, collaborating with cross-functional teams to translate business requirements into insightful visuals and reports.

Qualifications

• Pursuing a degree in business, engineering, or data science & analytics from a reputable educational institution.
• Able to commit to a full-time internship for 6 months preferred
• Proficient in Microsoft Power BI, Data Modeling & Visualization, Microsoft Excel, Word, PowerPoint
• Familiarity with programming languages such as Python or R for data analysis and manipulation, enhancing the capability to work with complex datasets.
• Analytical Thinking: Ability to apply analytical thinking to dissect complex data and extract meaningful insights relevant to business objectives.
• Detail-Oriented: Keen attention to detail to ensure the accuracy and effectiveness of data visualizations and reports.
• Effective Communication: Strong communication skills to articulate data insights and analysis to both technical and non-technical team members.
• Having practical skills with Salesforce platform would be a plus Johnson Controls: Enhancing the Intelligence of Buildings

Responsibilities

• Design & implementation of impactful BI dashboards using PowerBI to analyze market activities and extract leading indicators, providing critical insights that support strategic decision making & enable proactive responses to market dynamics.
• Implement simulation models to analyze various aspects of business operations such as seasonal trends, regional & sub-regional dynamics to identify proactive actions, enable accurate revenue forecasting & operational capacity planning.
• Utilize DAX (Data Analysis Expressions) for creating measures and understanding of data modeling concepts, data integration methods to consolidate data from various sources into PowerBI, ensuring data accuracy and reliability.
• Utilize SQL for data extraction, transformation, and loading (ETL) processes, with the ability to perform queries and manage data effectively.
• Interpret business requirements and convert them into insightful visualizations and reports
• Support in the execution of Program Management plan, including enabling cadence planning, impact capturing & problem solving.

Skills

Power BI

Data modeling

SQL

Python

R

Excel

PowerPoint

Salesforce

Education

Pursuing degree in business, engineering, or data science & analytics

Tools

DAX

Salesforce

Job description

Who we are:

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education.

For more than 140 years, Johnson Controls has delivered performance where it really matters.

Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

What you will do:

The position reports to the Senior Director, Services Growth & Programs, APAC and is a key contributing member who will provide exceptional support to program manage various APAC Service growth initiatives and platforms, track, analyze and communicate the performance to our internal and external stakeholders.

How you will do it:

Design & implementation of impactful BI dashboards using PowerBI to analyze market activities and extract leading indicators, providing critical insights that support strategic decision making & enable proactive responses to market dynamics.

Implement simulation models to analyze various aspects of business operations such as seasonal trends, regional & sub-regional dynamics to identify proactive actions, enable accurate revenue forecasting & operational capacity planning.

Utilize DAX (Data Analysis Expressions) for creating measures and understanding of data modeling concepts, data integration methods to consolidate data from various sources into PowerBI, ensuring data accuracy and reliability.

Utilize SQL for data extraction, transformation, and loading (ETL) processes, with the ability to perform queries and manage data effectively.

Data Analysis and Visualization:

Interpret business requirements and convert them into insightful visualizations and reports

Support in the execution of Program Management plan, including enabling cadence planning, impact capturing & problem solving.

What we look for:

Pursuing a degree in business, engineering, or data science & analytics from a reputable educational institution

Able to commit to a full-time internship for 6 months preferred

Proficient in Microsoft Power BI, Data Modeling & Visualization, Microsoft Excel, Word, PowerPoint

Familiarity with programming languages such as Python or R for data analysis and manipulation, enhancing the capability to work with complex datasets.

Analytical Thinking: Ability to apply analytical thinking to dissect complex data and extract meaningful insights relevant to business objectives.

Detail-Oriented: Keen attention to detail to ensure the accuracy and effectiveness of data visualizations and reports.

Effective Communication: Strong communication skills to articulate data insights and analysis to both technical and non-technical team members.

Having practical skills with Salesforce platform would be a plus Johnson Controls: Enhancing the Intelligence of Buildings

Your buildings have a purpose.

They are places for people to live or work.

Facilities for learning or healing.

Venues for entertainment and shopping.

Sites for the specialized storage of tangible goods or mission-critical data.

Your buildings have a huge variety of functions; they are central to your mission.

This is where Johnson Controls comes in, helping drive the outcomes that matter most.

Through a full range of systems and digital solutions, we make your buildings smarter.

A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable.

Most important, smarter buildings let you focus more intensely on your unique mission.

Better for your people.

Better for your bottom line.

Better for the planet.

At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since.

Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.