Intern, Data Analytics

JYS Johnson Controls (S) Pte Ltd; Singapore; On-site; SGD 17,000 - 23,000; Full time

Job summary

Johnson Controls, Inc. is offering a full-time 6-month internship in Singapore to support APAC service growth initiatives. You will help program manage projects, build ML-powered simulations, and develop BI dashboards to forecast revenue and optimize capacity planning.

The role requires hands-on experience with Power BI, SQL, Python or R, and strong communication skills to share insights with stakeholders. Salesforce and Snowflake familiarity are a plus.

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, Power Query, SQL, Microsoft Excel, Word, PowerPoint.
• Familiarity with programming languages such as Python or R for Exploratory Data Analysis and ML Predictive Analytics, using these tools for modelling and to deliver deeper insights.
• 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.
• Familiarity with Snowflake as a cloud data warehouse for storing, processing and analyzing large datasets is preferred.

Responsibilities

• Build and deploy simulation models powered by Machine Learning tools to analyze business operations and forecast revenue.
• Design and implement BI dashboards using Power BI with DAX measures for critical insights.
• Utilize SQL and Power Query for ETL and data modelling from multiple sources for visualization.
• Interpret business requirements and convert them into insightful visualizations and reports.
• Support execution of Program Management plan, cadence planning, impact capturing & problem solving.

Skills

Power BI

Power Query

SQL

Excel

Word

PowerPoint

Python

R

Analytical thinking

Detail-oriented

Communication

Salesforce familiarity

Snowflake familiarity

Education

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

Tools

MS Power BI

SQL

Python

R

Job description

What you will do:

The position reports to the Director, L&M Services, 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:

Harness a combination of Python/R and SQL to build and deploy simulation models powered by Machine Learning tools to analyze business operations, identify regional trends to drive proactive actions, enable accurate revenue forecasting & support operational capacity planning. Design & implementation of impactful BI dashboards using PowerBI to analyze market activities and extract leading indicators, utilizing DAX (Data Analysis Expressions) for creating measures providing critical insights that support strategic decision making & enable proactive responses to market dynamics, while also ensuring data accuracy and reliability. Utilize SQL and Power Query for data extraction, transformation, and loading (ETL) processes, with the ability to perform data modelling from multiple sources for ease of visualization.

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, Power Query, SQL, Microsoft Excel, Word, PowerPoint.
• Familiarity with programming languages such as Python or R for Exploratory Data Analysis and ML Predictive Analytics, using these tools for modelling and to deliver deeper insights.
• 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.
• Familiarity with Snowflake as a cloud data warehouse for storing, processing and analyzing large datasets is preferred.

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.