Job Description

You’re agile, keen and open to meaningful work and opportunities that come your way.

You bring structure, mitigation and education to our organisation. Our records and datasets are vast and varied. This is your opportunity to safeguard critical infrastructure, order and protect sensitive data, and defend against emerging cyber threats. You'll be part of an expert team who protect against thousands of threats every day.

In this role, you'll:

• Design, build and maintain secure, scalable Reporting & Analytics products that support Cyber Insights & Analytics.

• Develop and optimise data ingestion, modelling and transformation processes to ensure high-quality, governed and trusted data for reporting and decision-making.

• Create semantic models and executive-ready dashboards that deliver clear, actionable insights for Cyber, Operational and Executive stakeholders.

• Work closely with Cyber governance, operational and technical SMEs to translate data needs into practical, fit-for-purpose reporting solutions.

• Troubleshoot ingestion, modelling and quality issues across Azure SQL, ADF and Power BI to ensure reliability, performance and compliance.

• Contribute to CI&A reporting uplift by improving standards, documentation, metadata practices and self-service analytics capability.

This is a Hybrid role in Macquarie Park

Please view the and Information Pack for more information.

About you

You are a data-driven professional with a passion for transforming complex Cyber and operational information into clear, actionable insights.

- You thrive in environments where accuracy, governance and analytical rigour matter, and you bring a strong sense of ownership to the Reporting and Analytics products you deliver.

- You’re comfortable working across technical and business domains, engaging with stakeholders at all levels, and contributing to a culture that values trusted data, secure practices and continuous improvement.

- You stay abreast with developments in Data & AI landscape and are ready to apply modern, cutting-edge approaches to analytical challenges.

Skills & Experience

Significant experience in business intelligence, data warehousing/Analytics engineering, with a track record of delivering enterprise-scale Reporting & Analytics solutions

Extensive hands-on expertise with Executive ready Reports with Power BI (Dax, M code) and strong proficiency in Azure SQL for data modelling, performance tuning, and data ingestion troubleshooting

Demonstrated experience designing, implementing, and maintaining:

- Enterprise data warehouses, data marts, and dimensional models (star/snowflake schemas, facts & dimensions)

- ETL/ELT pipelines and data integration for modern metadata frameworks ensuring reliable, accurate, and timely data availability

- Semantic models and self-service analytics foundations that support governed, trusted Power BI Reporting providing actionable insights

Who we are

Transport for NSW provides a safe, integrated, and efficient transport system. We connect people, communities and industry every day.

Join us

Our workforce is as diverse as the community we serve. If you’d like further information on our inclusion and diversity initiatives, visit Transport careers