You can be part of the team that enables significant service improvements for our people.
You're all about the detail and this role will allow you to drive evidence-based decision making to optimise systems and efficiency, not just for the business but for our customers too. It's data and research with impact you can see.
In this role, you'll:
Design, develop, and maintain scalable data pipelines and automated ETL/ELT processes to support analytics and business intelligence needs.
Ensure data integrity, security, and compliance by implementing best practices in governance and adhering to TfNSW standards.
Optimize data workflows and infrastructure for efficiency, scalability, and performance through automation and continuous improvement.
Collaborate with business intelligence teams and stakeholders to translate data requirements into robust technical solutions.
Develop and maintain data models and schemas that enable efficient storage, retrieval, and integration across multiple platforms.
Align solutions with TfNSW’s data strategy, architecture, and security standards in partnership with architecture teams.
Monitor, troubleshoot, and enhance data pipelines to ensure reliability and timely delivery of business-critical data.
Stay current with emerging technologies and trends in data engineering, cloud computing, and big data to drive innovation.
For more information on this position and business unit, view the role description and information pack.
About you
- Proven experience designing and managing scalable ETL/ELT pipelines and data engineering solutions
- Strong proficiency in SQL and Python for data transformation, automation, and integrations
- Hands-on expertise with Azure Data Factory and Azure Databricks (including Spark and Delta Lake)
- Solid experience with Azure SQL, including schema design, query optimization, and performance tuning
- Strong understanding of data modeling, warehousing, and analytics-focused schema design
- Experience with cloud data ecosystems (primarily Azure) and exposure to tools like Spark, Kafka, or Airflow
- Ability to design and implement end-to-end automated workflows using Power Automate, Logic Apps, and related tools
- Knowledge of data governance, security, and compliance practices
- Ability to architect scalable, secure, and maintainable data solutions across platforms
- Strong problem-solving skills with the ability to translate business requirements into technical solutions within Azure platform and work effectively with cross-functional teams.
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
Applications close 11:59 PM Monday, 8th June 2026.
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
