Portfolio Reporting Analyst

Sydney Water; Sydney; Hybrid; AUD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive Compensation

Continuous Professional Growth

24/7 Wellbeing Support

Discounted Private Health Insurance

Family First

Fitness Passport

Novated Leasing

Job summary

Sydney Water is seeking a Portfolio Reporting Analyst to deliver actionable insights through advanced dashboard reporting that informs the financial and strategic management of projects and portfolios.

You will develop, maintain and improve high-quality Power BI and SAP Analytics Cloud reports, enabling enterprise portfolio reporting and informed investment decisions. This role is based in Parramatta with hybrid working arrangements.

Qualifications

• Advanced Power BI and SAC reporting experience.
• Tertiary qualification in Accounting, Economics, Business or related discipline.
• Extensive PMO experience in a large, complex organisation.
• Experience analysing program and portfolio performance.
• Strong knowledge of capital investment and benefits management.
• Strong stakeholder advisory capabilities.
• Ability to translate data into trends and board reporting.
• Excellent communication and organisational skills with large datasets.
• Commercial mindset with strong stakeholder engagement.
• Experience in infrastructure program environment preferred.

Responsibilities

• Lead design, development and maintenance of Power BI dashboards for enterprise portfolio reporting.
• Manage day-to-day portfolio reporting activities and identify efficiency improvements.
• Maintain reporting streams across pipeline management and Enterprise Portfolio Dependencies.
• Act as SME in advanced dashboard reporting using Power BI and SAC.
• Review data integration and integrity across reporting platforms with stakeholders.
• Drive automation and improve dashboard usability.
• Support the broader Business PMO with reporting maturity initiatives.

Skills

PMO experience

Stakeholder engagement

Data analysis

Education

Accounting/Economics/Business degree or related

Tools

Power BI

SAP Analytics Cloud

Job description

• Deliver enterprise portfolio reporting and insights that support strategic investment decision making
• Permanent opportunity based in Parramatta with hybrid working arrangements
• Lead the development of Power BI and SAP Analytics Cloud (SAC) reporting solutions across Sydney Water's portfolio

• Deliver enterprise portfolio reporting and insights that support strategic investment decision making
• Permanent opportunity based in Parramatta with hybrid working arrangements
• Lead the development of Power BI and SAP Analytics Cloud (SAC) reporting solutions across Sydney Water's portfolio

About us

At Sydney Water, we’re passionate about making a difference to the lives of our customers and communities, and our employees. We have a proud heritage and a progressive future, providing world class drinking water and beautiful waterways from the mountains to the sea. Our people and their jobs are as diverse as the communities we serve.

About the role

As a Portfolio Reporting Analyst, you will play a key role in delivering actionable insights through advanced dashboard reporting that directly informs the financial and strategic management of Sydney Water's projects, programs, and portfolios. This work is central to ensuring effective use of funds, benefits realisation, and well-informed investment decision-making.
A core responsibility of this role is to develop, maintain, and continuously improve high-quality reports and dashboards in Power BI and SAP Analytics Cloud (SAC). Experience with SAC is essential to support enterprise portfolio reporting, integration, and advanced analytics.

Key responsibilities include

• Lead the design, development, and ongoing maintenance of Power BI dashboards that provide timely, accurate, and insightful enterprise portfolio reporting.
• Support the management of day‑to‑day portfolio reporting activities while identifying opportunities to streamline processes and improve efficiency.
• Maintain reporting streams across assigned areas, including pipeline management (Business Cases and Candidates) and Enterprise Portfolio Dependencies.
• Act as a subject matter expert in advanced dashboard reporting, leveraging Power BI and SAP Analytics Cloud to enhance reporting capabilities and portfolio insights.
• Review, analyse, and ensure data integration and integrity across reporting platforms, working closely with Corporate, Finance, and EPMO stakeholders to align with enterprise standards.
• Drive continuous improvement by identifying opportunities to automate reporting, improve data quality, and optimise dashboard usability.
• Support the broader Business PMO team by contributing to initiatives that uplift reporting maturity and business effectiveness.

About You

We are looking for someone who brings strong technical capability and a passion for transforming complex portfolio data into clear, meaningful insights that support decision-making at all levels of the organisation.

To be successful in this role, you will bring

• Advanced experience with Power BI and SAP Analytics Cloud (SAC) is essential
• Relevant tertiary qualifications in Accounting, Economics, Business, or a related discipline, or equivalent experience.
• Extensive experience working within a PMO in a large, complex organisation, preferably within an asset‑intensive and/or regulated environment.
• Demonstrated experience analysing program and portfolio performance.
• Strong knowledge of capital investment and benefits management.
• Proven ability to establish and maintain trusted stakeholder relationships, particularly in an advisory capacity.
• Experience translating large volumes of raw data into meaningful trends, insights, and Board‑level reporting.
• Strong analytical skills with the ability to synthesise information from multiple data sources into clear and actionable insights.
• Demonstrated ability to identify trends, issues, and root causes through detailed analysis.Excellent organisational skills, strong numerical capability, and experience working with large and complex datasets.
• A commercial mindset combined with excellent communication and stakeholder engagement skills.
• Experience working within an infrastructure program environment or portfolio/program management office will be highly regarded.

Why Sydney Water?

• Make a Real Impact: Your work keeps Sydney’s water flowing and our environment protected.
• Work with the Best: Join a team that values safety, innovation, and looking out for each other.
• Grow Your Career: Access training, development, and opportunities to advance.
• Be Part of Something Bigger: Help deliver essential services to millions and safeguard Sydney’s future.

Please see the Position Description for the role’s full accountabilities.

You must be an Australian Citizen or Permanent Resident at the time of submitting your application to be considered for this role. Please note as part of the application process, you will be asked to undergo background checks which includes employment reference checks, a criminal history check and a medical assessment either online or in person.

Please advise if you require any adjustments to actively participate in the application and recruitment process. Please contact [e-mail] for any further information.

Dive into Our Great Benefits!

• Competitive Compensation: We’ll ensure that your skills and contributions are valued and rewarded appropriately.
• Continuous Professional Growth: We will invest in your career with leadership and development programs to propel your success.
• 24/7 Wellbeing Support: Access for you and your family to free and confidential mental health and general health support through our EAP portal.
• Discounted Private Health Insurance: Unlock affordable access to top‑tier health coverage with our discounted insurance plans.
• Family First: Prioritise your family with up to 18 weeks of fully paid parental leave and a generous childcare allowance.
• Fitness Passport: Achieve your physical fitness goals using our Fitness Passport, granting you access to a multitude of gyms and pools across NSW.
• Novated Leasing: Get in the driver's seat of your financial future with our novated lease options.

As part of the application process, Sydney Water will be collecting your personal information to assess your suitability for the role. Your personal information may also be used to establish a Dayforce talent profile.

Your personal information will be collected in accordance with Dayforce’s Terms and Privacy Policy and Sydney Water’s Privacy Collection Statement– recruitment. Please note as part of the application process, you will be asked to undergo background checks which include a criminal history check.