Reporting & Solutions Analyst

AGL; Melbourne; Hybrid; AUD 110,000 - 150,000; Full time

Job summary

AGL is seeking an experienced Reporting & Solutions Analyst to join our Asset Services division. You will translate business requirements into meaningful reporting outcomes, design data assets, and automate reporting using Power BI, SQL and related tools.

You will build semantic models, KPI frameworks, and scalable data assets while collaborating with stakeholders to improve efficiency and ensure high-quality analytics across energy assets.

Qualifications

• Experience as a Reporting Analyst in a large, complex organisation.
• Stakeholder engagement and translating business needs into reports.
• Strong technical proficiency with Power BI, SQL and data modelling.

Responsibilities

• Design, deliver, and maintain reporting solutions using Power BI, DAX, and SQL with SEEQ and Aveva Pi.
• Develop and maintain semantic models, reusable datasets, KPI frameworks and reporting assets.
• Manage the scheduled delivery of internal and external reporting requirements.
• Identify opportunities to leverage AI, Microsoft Fabric, Databricks, Power Platform and automation.
• Ensure Asset Intelligence delivers high quality and reliable analytics to stakeholders.

Skills

Power BI

SQL

DAX

Power Query

Data modeling

Semantic layer

KPI frameworks

Automation

Education

Bachelor's degree in Information Technology

Bachelor's degree in Computer Science

Data Analytics

Engineering

Tools

SEEQ

Aveva Pi

Databricks

Microsoft Fabric

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.

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.