The Electricity Division provides policy advice to the Australian Government on matters that support electricity markets to deliver beneficial outcomes for consumers. We support the Minister to drive national electricity market reforms and implement government policies that promote affordable, secure and reliable electricity supply. The Electricity Markets Branch provides advice across wholesale and retail electricity markets to promote reliability, security and affordability. The branch delivers analysis and policy advice to support market reform, investment and the effective operation of the National Electricity Market (NEM). The Market Insights (MI) team provides data-driven analysis and market intelligence to support the Department's oversight of Australia's electricity markets during the energy transition. The team monitors wholesale and retail market outcomes, generator performance, outages, prices, and emerging risks, translating complex datasets into clear insights for senior executives, ministers, and policy teams. MI plays a critical role in ensuring policy advice is grounded in robust evidence, timely analysis, and a deep understanding of National Electricity Market dynamics. For more information about us please visit our website . The key duties of the position include As an EL1 Data Analyst (Power BI) in the Market Insights team, you will lead the delivery of high-quality data analytics and reporting to support the Department's monitoring of electricity market outcomes and the energy transition. Your key duties and responsibilities will include: Designing, developing, and maintaining advanced Power BI data models, dashboards, and reports that provide timely insights on wholesale and retail electricity market performance, including prices, outages, generation, and emerging risks. Leading complex data transformation and ETL processes using Power Query (M), including merging and appending large datasets, building reusable custom functions, and parameterising queries to support scalable and efficient reporting. Optimising Power BI models and reports for performance and reliability, including managing query folding, reducing model size, improving DAX performance, and diagnosing issues using performance analysis tools. Applying best-practice data visualisation and user-experience design principles to produce intuitive, interactive dashboards that effectively communicate insights to senior executives, ministers, and policy teams. Working closely with policy, regulatory, and technical stakeholders across the Electricity Markets Branch and the broader Department to translate analytical findings into clear, policy-relevant insights. Supporting market monitoring and ad-hoc analysis in response to emerging issues, time-critical requests, and briefing requirements, including contributions to ministerial briefs and executive updates. Providing technical leadership within the team, including mentoring APS-level staff, setting analytical standards, and supporting capability uplift in Power BI, data modelling, and analytics practices. Ensuring analytical outputs are robust, well-documented, and aligned with departmental governance, data quality, and security requirements. This role requires a strong blend of technical expertise, analytical judgement, and leadership capability, with a focus on delivering high-impact insights that support national electricity market policy and decision-making. For detailed information about the job-specific capabilities for this role, please view the Job Description which can be downloaded from our website - the Apply Now link will take you there.
