Permanent
Utilities Analyst
Stellenbosch, Western Cape
unknown
About this role
Employer: Michelle Cloete Consulting Pty Ltd
This role is overseeing utilities billing accuracy, consumption monitoring, recoveries, municipal query resolution, and leakage investigations across a multi-site property portfolio.
Key Responsibilities
Utilities Reconciliations & Deep Dive Analysis
•Perform detailed monthly reconciliations between:
o Council bills
o Meter readings
o TPS recoveries
o 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.