Energy Markets · Data & Statistical Analysis
Energy-market data, turned into reports the room acts on.Nine years across the NEM and WEM.
I'm Carol, Senior Data & Statistical Analyst at the Australian Energy Council. I lead reporting for the Energy 2050 transition project, publish on wholesale pricing and distributed energy, and built the Power BI and SQL machinery behind the Council's benchmarking work with 14 of the country's major generators. Recent published work: a SEIFA equity read on the federal battery rebate, and a PPP-adjusted price comparison across 38 OECD economies.
Nine years of energy-market and retail analysis, written for the rooms that have to move on it: Council boards, media desks, and 14 generator CEOs.
Markets
Stack
Domains
Experience
Energy markets now. Retail data before that. A research bench at the start. Nine years of putting numbers in front of people who have to decide something with them.
2016 — Present
Senior Data & Statistical Analyst · Australian Energy Council
Lead data collection and reporting for the AEC's Energy 2050 Project, the pathway work for Australia's net-zero transition across the NEM and WEM. Built the SQL and Power BI machinery behind the annual Electricity Gas Australia publication, the AEC Solar Report, the Coal National Pollutant Inventory, and the wholesale spot and futures analysis the Council leans on. Set benchmarking metrics with 14 national generators for OH&S and generation performance, and produce the confidential reports that go to boards and media desks. Recent published pieces include a SEIFA equity read on the federal battery rebate and a PPP-adjusted price comparison across 38 OECD economies.
2015 — 2024
Sales Representative & Data Support Analyst · AnimeTown
Started customer-facing, moved into retail data analysis. Analysed purchase behaviour, AUD/JPY exposure, and inventory performance in Tableau and Google Analytics. Two calls actually moved the business. The first: a 25% pre-order deposit model that locked in cashflow through the COVID-era AUD slide and Japan-side supply delays, while comparable importers folded. The second: removing packaging and cutting price 20% took post-lockdown booth density from 50 to 250 figures on shelf, 5× the inventory in the same footprint, with higher sell-through.
2014
Bioinformatics Research Intern · Peter MacCallum Cancer Centre
Used R to filter and summarise genetic data for a sarcoma research project, supported statistical reporting under tight deadlines, and contributed to the research poster Amplicon-based Targeted Sequencing to Identify Inherited Genetic Risk Factors Associated with Onset Sarcomas.
The through-line
Evidence that holds up under scrutiny.
A Board paper on wholesale price volatility. The SEIFA equity read on the federal battery rebate. A PPP-adjusted price comparison across 38 OECD economies. The 25% deposit recommendation during a once-in-a-decade FX shock that kept a retail importer trading while comparable shops folded. Different rooms, same test: can the audience move on it the next morning?
Method
04 stations
Trust the process. Especially when the brief isn’t clear yet.
Most briefs land ambiguous. This is the loop I run.
01
// Frame
Sit with the question before touching the data.
Ambiguous briefs arrive dressed as data requests. I push back until I know what decision is on the table and who owns it.
In practice
Reframed the battery rebate question from "national uptake" to "who the scheme actually reaches, by postcode SEIFA decile".
02
// Reconcile
Reconcile the sources before trusting any of them.
SQL on the wholesale and futures store, AEMO, around 20 member returns, IEA and OECD for the comparator. The sources disagree before you reconcile them, and that part is the job.
In practice
OECD price piece: 38 economies, PPP-adjusted, household and industrial bands reconciled against three publication vintages.
03
// Stress-test
Find the pattern. Then look for the counter-argument.
Power BI and Python for the read, Tableau and Excel/VBA where the audience already works. Before anything leaves the desk I run it against the obvious counter-explanation and a sensitivity check.
In practice
Wholesale price volatility cross-checked against weather, fuel cost, outage windows, and regulatory shift before the Board paper went out.
04
// Translate
Same finding, three registers. One for each room.
One chart the executive reads in ten seconds. One paragraph comms can quote. One method note the next analyst can rebuild.
In practice
A 25% pre-order deposit model that held cashflow through a once-in-a-decade FX shock while comparable importers folded.
Inputs
SQL · AEMO public data · member returns · IEA / OECD · regulatory filings
Output
one chart, one paragraph, one method note — and a decision the room can move on by Monday.
Writing
Published work for the Australian Energy Council on rooftop solar, battery uptake, and how Australian electricity prices actually compare once you control for cost of living.
Australia's Home Battery Surge — A Question of Equity
Postcode-level SEIFA analysis of federal Cheaper Home Batteries Program uptake. Quantifies the disparity between advantaged and disadvantaged areas, with state-by-state breakdowns.
Read on energycouncil.com.auOECD Electricity Price Comparison — How Do We Stack Up?
Nominal vs. cost-of-living-adjusted residential and business electricity prices across 38 OECD countries. Reframes a routine political comparison around a defensible methodology.
Read on energycouncil.com.auAEC Solar Report — Q2 2025
Market snapshot of rooftop solar capacity, battery uptake, LCOE, and payback periods. Includes methodology appendix and sensitivity analyses.
Read on Australian Energy CouncilSkills & Tooling
The stack behind the work: what I reach for first, and the credentials that back it.
BI & Visualisation
Query & Databases
Languages
Spreadsheets
Domain
Certifications
Education
Bachelor of Science (Statistics) — The University of Melbourne, 2012–2014.
Get in touch
Open to Senior Data Analyst roles in energy, utilities, or policy. Melbourne-based, happy to work on-site or remote across Australia.
Email is the fastest way to reach me. I can send dashboards, code samples, and the long versions of the case studies above. Happy to walk through the SEIFA battery work, the OECD price benchmark, or the AnimeTown deposit call in more detail.