Utilities Analyst

Profile Personnel; Stellenbosch; On-site; ZAR 279,000 - 390,600; Full time

Job summary

A utilities management firm is seeking a detail-oriented Utilities Analyst in Stellenbosch to oversee billing accuracy across multiple properties. The role demands strong Excel skills and analytical experience, ensuring accurate reconciliations and monitoring of consumption patterns. Candidates should have a qualification in a related field and between 2 to 5 years of relevant experience in utilities analysis. This is a significant opportunity for someone with a solid analytical mindset to contribute to effective utilities management.

Qualifications

• 2–5 years of experience in utilities analysis, billing reconciliation, or consumption cost recoveries.
• Previous experience working in a Utility Department at a property company advantageous.

Responsibilities

• Perform detailed monthly reconciliations between council bills, meter readings, TPS recoveries, and tenant billings.
• Identify and investigate over-recoveries and under-recoveries.
• Compile and update monthly leakage reports after billing runs.
• Log and track all municipal billing queries per region.
• Review metering data for inconsistencies or irregularities.

Skills

Strong Excel capability

Numerical confidence

Analytical thinking

Education

Qualification in Finance, Accounting, Engineering, or related analytical field

Job description

Role Overview

We are seeking a technically strong and detail-oriented Utilities Analyst to support the Utilities Manager in overseeing utilities billing accuracy, consumption monitoring, recoveries, municipal query resolution, and leakage investigations across a multi-site property portfolio. This is a highly analytical role requiring a deep understanding of how utilities function from a technical, tariff, and calculation perspective. The successful candidate will conduct detailed reconciliations, investigate over- and under-recoveries, analyse municipal charges, and ensure recoveries align with metering data and tenant billing structures. The role requires strong Excel capability, numerical confidence, and the ability to interrogate data thoroughly.

Education & Experience

• Qualification in Finance, Accounting, Engineering, or related analytical field preferred.
• 2–5 years’ experience in utilities analysis, billing reconciliation, or consumption cost recoveries.
• Previous experience working in a Utility Department at a property company advantageous.

Key Responsibilities

Utilities Reconciliations & Deep Dive Analysis

Perform detailed monthly reconciliations between:

• Council bills
• Meter readings
• TPS recoveries
• Tenant billings
• Identify and investigate over-recoveries and under-recoveries.

Analyse charges by type

• kWh
• kVA / demand charges
• Service fees
• Network charges
• Surcharges
• Conduct site-level deep dives into major variances.
• Prepare reconciliation working papers and variance summaries.
• Highlight systemic issues affecting recovery performance.
• Support corrective action planning to improve recovery ratios.

Leakage Monitoring & Reporting

• Compile and update monthly leakage reports after billing runs.
• Identify Top 10 high-risk sites requiring intervention.
• Monitor trends in consumption vs billing vs recoveries.
• Track historical performance to identify recurring problem areas.
• Escalate significant anomalies to the Utilities Manager.

Municipal Queries & Council Liaison

• Log and track all municipal billing queries per region.
• Assist in investigating incorrect billing, tariff misapplications, and meter discrepancies.
• Liaise with council representatives and council runners.
• Support follow-ups on outstanding queries until resolution.
• Verify and reconcile municipal credits once processed.
• Maintain clear documentation of all queries and resolutions.

Metering Oversight & Verification

• Review metering data for inconsistencies or irregularities.
• Identify properties requiring check meters.
• Reconcile council readings against billed consumption.
• Flag faulty meters or abnormal readings.
• Assist with verification of utilities billing disputes.
• Maintain a master metering issue log.

Vacancy & Consumption Monitoring

• Identify vacant units with active consumption.
• Analyse vacancy-related recovery leakage.
• Cross-check vacancy status across systems.
• Flag potential recovery risks caused by incorrect vacancy classification.

Data Management & Spreadsheet Reporting

• Maintain structured reconciliation spreadsheets.
• Build and update Excel models for recovery tracking.
• Prepare supporting schedules for management reporting.
• Assist in automating recurring reconciliation processes where possible.
• Ensure data integrity across all utilities trackers.

Only shortlisted candidates will be contacted. Should you not receive a response within 14 days please consider your application unsuccessful. We will keep your CV on our database for any other relevant roles that may arise.