Junior Data Analyst

Zeal HR; Bellville; On-site; ZAR 250 000 - 350 000; Full time

Job summary

A leading company in the energy solutions industry is seeking a Junior Data Analyst in Bellville, Cape Town. The role involves utilizing existing tools for reporting and assisting in the development of new analytical tools. Candidates should have a Bachelor's degree in Engineering or a related field and a passion for data analysis. Responsibilities include supporting reporting programs, conducting ad-hoc analysis, and collaborating with senior analysts.

Qualifications

• At least 1 year experience in Engineering or Analyst fields.
• Strong logical and systematic thinking.
• Highly skilled in Microsoft Excel.

Responsibilities

• Support reporting and analysis for client/s using Power BI and Excel.
• Find data quality issues and actionable insights.
• Develop and maintain reporting tools with guidance.

Skills

Data Analysis

BI Visualisations

Attention to Detail

Logical Thinking

Education

Bachelor's degree in Engineering, Science or similar

Tools

Microsoft Excel

Google BigQuery

Python

R

Matlab

Power BI

Tableau

Job description

An exciting opportunity available within the energy solutions industry for a Junior Data Analyst, based in Bellville, Cape Town. The Analyst is expected to use existing tools and models for this reporting, as well as assist in the development of new tools. It would be advantageous to have a degree in engineering or a data analytics field.

RESPONSIBILITIES:

• Support the Utilities Management Program reporting and analysis for a client/s, including
• Using existing Power BI, Excel, BigQuery and other tools for data cleaning, report generation and analysis
• Finding data quality issues, trends, actionable insights and project opportunities within the data
• Ad-hoc analysis across a broad range of data and topics (e.g., energy and water profiles, billing and tariffs, baselines and benchmarks, temperatures, intensities, budgeting, estimating and forecasting consumptions/costs etc.) with guidance from senior analysts
• Support the development and maintenance of our software Platform with guidance from senior analysts, including
• Development and maintenance of both internal and external reporting tools
• Self-learning and research into platform and sustainability topics (e.g., load shedding, water scarcity, new BI functionalities, ESG standards etc.)
• Effective communication, including
• Attending client meetings, and responding to client emails/calls
• Work closely with other Data Analysts and Developers

REQUIREMENTS:

• Bachelor's degree in an Engineering, Science or similar discipline (e.g., mechanical, electrical, statistics etc.).
• At least 1 year experience in Engineering or Analyst fields.
• A passion for data analysis, with strong logical and systematic thinking.
• Interest and skill in BI visualizations and aesthetic design of technical data.
• Ability to work within tight deadlines in a high-pressure environment.
• Attention to detail with high level of accuracy and quality assurance.
• Ability to learn through senior mentorship as well as self-learning.
• Highly skilled in Microsoft Excel.
• Experience with large datasets, data cleaning, aggregation, and the automation of repetitive data processing pipelines using software tools.
• Experience in working with databases and specifically Google BigQuery.
• Experience with using software for data processing (e.g., Python, R, Matlab).
• Experience with BI tools (e.g., Power BI, Tableau).
• Understanding of electrical concepts and drawings.
• Exposure to the Energy Management or Sustainably industries.

Desired Skills:

• Data Analyst
• Engineering
• BI Visualisations
• BigQuery