Organisation/Entity: Transport For NSW
Job category: Projects
Job location:
Macquarie Park, NSW, AU, 2113
#job-location.job-location-inline { display: inline; }
Job reference number: 107937
Employment type: Permanent Full-Time
Salary range: $137551.0-$154055.0
.buttontext84e7fa5614fe8498 a{ border: 1px solid transparent; } .buttontext84e7fa5614fe8498 a: focus{ border: 1px dashed #0085b3 !important; outline: none !important; }
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 role description 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.
Flexible work options may be available. Learn more via Flexible work options and policy
Apply today
Applications close 11:59 PM Thursday 13 August 2026
For more information about this role, please contact
[email protected].
Aboriginal people and people living with disability are supported throughout the recruitment process and at work, and we encourage you to apply. Visit Supporting Aboriginal People or Supporting People with Disability for more information or speak to your talent team member to arrange any adjustments to how you interact with us.
Learn more about how to apply via Our recruitment process | Transport for NSW
#LI-Hybrid
Job Segment: Analytics, Engineer, Data Analyst, Database, SQL, Management, Engineering, Data, Technology
