Reporting & Solutions Analyst

A098 AGL Energy Limited; Melbourne; On-site; AUD 90,000 - 130,000; Full time

Job summary

AGL Energy Limited is seeking a Reporting & Solutions Analyst within its Asset Services division to transform business needs into actionable reporting. The role emphasizes delivering insightful metrics through Power BI, SQL, and semantic data models, while exploring automation and AI opportunities to increase efficiency.

You will collaborate with stakeholders across operations to ensure reliable, scalable analytics, leveraging platforms like SEEQ, Aveva Pi, and cloud analytics tools.

Qualifications

• Experience with Power BI report development and performance optimization.
• Experience with SQL, DAX, and Power Query for data transformation.
• Knowledge of dimensional modelling and star schemas.
• Experience with Microsoft Fabric, Databricks, and cloud analytics platforms.
• Experience in energy/utilities sector is advantageous.
• Tertiary qualification in IT/CS/Data Analytics/Engineering is highly regarded.

Responsibilities

• Translate business requirements into reporting outputs using Power BI and SQL.
• Develop and maintain data assets and semantic models.
• Automate reporting processes and explore AI opportunities.
• Ensure timely delivery of internal and external reports.
• Collaborate with stakeholders across Asset Services.

Skills

Power BI

SQL

DAX

Power Query

Dimensional modelling

Databricks

Microsoft Fabric

Data warehousing

Stakeholder engagement

Education

Tertiary qualifications in IT/CS/Data Analytics/Engineering

Tools

SEEQ

Aveva Pi

Microsoft Fabric

Databricks

Power Platform

Job description

We've been proudly Aussie since 1837, always finding new ways to innovate in energy and essential services. Now, we're moving towards a sustainable future through electrification and investing in renewable energy—and we’d like you to join us. Whether you're on-site, in the office, or somewhere in between, you'll find opportunities to grow your career here. You'll work with a team that's passionate about powering Australian lives, in a culture that values inclusivity, respect, and learning. Help us create a cleaner energy future, and we’ll back you every step of the way as you build your career.

Join the change. Electrify your future.

About the role

An exciting new opportunity has become available for a Reporting & Solutions Analyst to join our Asset Services division.

The Performance and Reporting team provides actionable insights and business reporting through digital solutions covering operational performance, availability, reliability, and compliance amongst many other metrics enabling decision‑making across AGL’s diverse energy assets.

Key responsibilities

You will work closely with stakeholders translating business requirements into meaningful reporting outcomes, developing trusted and documented data assets and models, identifying opportunities to improve efficiency through automation and emerging technologies packaged in a client-focused structured service offering.

In addition to the above, you will:

• Design, deliver, and maintain reporting solutions using Power BI, DAX, and SQL together with AGL’s technology stack including SEEQ and Aveva Pi.
• Develop and maintain semantic models, reusable datasets, KPI frameworks, and other reporting assets.
• Manage the scheduled delivery of internal and external reporting requirements.
• Identify and implement opportunities to leverage AI, Microsoft Fabric, Databricks, Power Platform, automation, and emerging technologies.
• Ensure Asset Intelligence continues to be the trusted performance data provider through consistent delivery of high quality and reliable analytics to stakeholders.

About you

You are an experienced Reporting Analyst who had previous exposure working with datasets within a large & complex company. Your stakeholder engagement skills & willingness to learn will set you up for success in this role.

You will also demonstrate:

• Strong experience in Power BI, including report development, deployment, performance optimisation, and report lifecycle management.
• SQL, DAX, and Power Query skills for data transformation, analysis, and reporting solution development.
• Demonstrated knowledge of data modelling principles including dimensional modelling, star schema design, and semantic layer architecture.
• Experience working with Microsoft Fabric, Databricks, data warehouse, and modern cloud‑based analytics platforms.
• Experience in the energy, utilities, or power generation sectors is highly regarded.
• Tertiary qualifications in Information Technology, Computer Science, Data Analytics, Engineering, or a related discipline are highly regarded.

Inclusion at AGL

At AGL, we value diversity and welcome applicants from various backgrounds, including Aboriginal and/or Torres Strait Islander peoples, individuals with disabilities, culturally diverse individuals, and members of the LGBTQ+ community. AGL is dedicated to maintaining a diverse workforce and encourages applicants to share their lived experiences.

We offer reasonable adjustments throughout the recruitment process and respect the privacy of those who choose not to disclose. To learn more visit: www.agl.com.au/careers

AGL is proud to be a WORK180 Endorsed Employer for All Women.

At AGL, we use some AI‑enabled tools to support recruitment administration. All hiring decisions are made by hiring leaders and Talent Solutions professionals, with human oversight throughout.

Our pre‑employment screening process includes a Nationally Coordinated Criminal History Check and a medical assessment if necessary.

The information provided as part of your application to AGL will be managed in accordance with the AGL Privacy Policy.

AGL does not accept agency submissions unless approval has been granted by a member of the Talent Solutions team. Candidates submitted by an agency without approval will not be considered by AGL.