Energy Analyst - Renewables

Energy Vault; Cape Town; On-site; ZAR 300,000 - 600,000; Full time

Job summary

A leading energy company is seeking a Data Analyst to advance their operations in energy trading. This role focuses on managing data accuracy, developing forecasting models, and enhancing reporting processes to streamline energy trading activities. The ideal candidate will have an analytical mindset, strong technical skills, and experience in energy management.

Qualifications

• At least 2 years’ experience in a data-driven role.
• Experience in utilities and energy management is advantageous.
• Familiar with time-series data.

Responsibilities

• Manage and enhance metering data quality.
• Develop forecasting models for energy usage.
• Build dashboards to support stakeholders.

Skills

Analytical thinking

Attention to detail

Communication

Root cause analysis

Education

Undergraduate degree in Engineering, Business Science, Economics, Mathematics, Statistics

Tools

Excel

Python

SQL

Power BI

Tableau

Job description

Introduction

We are seeking a highly analytical and technically proficient Data Analyst to join our growing energy trading operations. This role plays a crucial part in ensuring accurate data flow, forecasting, and reporting across both client consumption and energy generation activities.

Your primary responsibility will be to manage and enhance the quality and accuracy of metering data, while developing forecasting models to predict energy usage. You will work with large, time-sensitive datasets and use your scripting, automation, and BI skills to streamline reporting processes and support client settlements.

This role is embedded within the settlements function, the engine room of our energy trading business,and directly supports the optimisation of energy allocations from generation sources to client sites. As the regulatory and trading landscape continues to evolve, you’ll contribute to building scalable, automated systems that can keep up with the pace of industry change.

Duties & Responsibilities

Data Management & Quality Control

• Monitor incoming datasets from metering systems to ensure accuracy, completeness, and consistency.

• Identify and resolve data gaps or errors using structured problem-solving techniques.

• Collaborate with external metering service providers to troubleshoot issues and improve data flow.

Forecasting & Load Analysis

• Operate and refine forecasting models to predict client energy usage across industries.

• Interpret time-series consumption data to support optimisation of energy distribution.

Data Integration & Automation

• Extract, clean, and integrate data from various metering platforms and internal systems.

• Assist with automating manual data-loading processes through scripting and system enhancements.

Reporting & Business Intelligence

• Build dashboards and generate reports to help internal stakeholders and clients understand their energy profiles.

• Translate technical data into accessible insights that support both client decision-making and business strategy.

Support for Settlements & Reconciliation

• Provide validated data for use in client settlements and energy trading activities.

• Reconcile internal data against utility bills and escalate any discrepancies with supporting analysis.

System Maintenance & Operational Support

• Maintain structured metering hierarchies within energy trading platforms.

• Ensure seamless integration of diverse energy data sources, including diesel generators and embedded generation plants.

Compliance & Process Improvement

• Drive continuous improvement in data workflows and ensure alignment with regulatory requirements and internal standards.

• Support internal teams by helping scale data processes for a growing client base.

Desired Experience & Qualification

• A completed undergraduate degree in Engineering, Business Science, Economics, Mathematics, Statistics, or other quantitative discipline

• At least 2 years’ experience working in a data-driven role

• Exposure to utilities, metering, energy management, or energy trading is highly advantageous

Technical Skills

• Excel: Advanced skills including pivot tables, formula development, and visualisation

• Python: Practical scripting ability (e.g., connecting to APIs, data manipulation, automation)

• SQL: Basic to intermediate knowledge of querying large datasets

• BI Tools: Experience with Power BI, Tableau, or similar platforms

• Familiarity with time-series data and understanding of load profiles across different sectors (e.g., commercial, industrial, healthcare)

Core Competencies

• Strong attention to detail with high levels of accuracy in handling datasets

• Analytical thinker with the ability to identify root causes and resolve complex data issues

• Skilled communicator with the ability to explain technical issues clearly to clients and internal teams

• Proven ability to reconcile large data sets and spot anomalies

• Effective time management and ability to prioritise in a fast-moving operational environment

• Comfortable working independently and collaboratively across cross-functional teams

• Adaptable mindset with a willingness to learn and evolve alongside a changing energy market

What to look forward to