Data Engineer

Transport for NSW; Sydney; On-site; AUD 142,000 - 159,000; Full time

Job summary

Transport for NSW, based in Sydney, is seeking a hands-on Data Engineer to design, develop and maintain data pipelines and cloud infrastructure that support reporting, analytics and decision-making across large infrastructure programs.

You will work with Azure Data Factory and Databricks, build reliable data models, ensure data quality, and contribute to CI/CD and platform maintenance, enabling trusted data for asset performance and project delivery.

Qualifications

• Hands on experience with Azure Data Factory (ADF) and Databricks.
• Strong programming and scripting skills in SQL and Python.
• Demonstrated experience in designing databases and developing data models.
• Experience in data cleansing, transformation, and pipeline management.
• Experience supporting DevOps and CI/CD platforms and practices.

Responsibilities

• Join the Metro Data Ecosystem team and help build and maintain the data platform that underpins reporting, analytics, and decision-making.
• Design, develop, test, and support data pipelines, data models, and cloud-based infrastructure.
• Ensure data is reliable, secure, and ready for analysis across the full data engineering lifecycle.
• Work with Azure Data Factory and Databricks, maintaining a trusted data platform as a single source of truth.

Skills

Azure Data Factory

Databricks

SQL

Python

Data modeling

CI/CD

Data quality

Tools

Azure Data Factory

Databricks

Job description

Organisation/Entity: Transport For NSW

Job category: Information & Communication Technology

Job location: Macquarie Park, NSW, AU, 2113

Job reference number: 110571

Employment type: Permanent Full-Time

Salary range: $141678.0-$158677.0

You see the big picture, you've always worked on a grand scale, and now you're ready to re-focus on grand impact.

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:

Join the Metro Data Ecosystem team and help build and maintain the data platform that underpins reporting, analytics, and decision-making across one of NSW's largest infrastructure programs.

You will design, develop, test, and support data pipelines, data models, and cloud-based infrastructure that ensure data is reliable, secure, and ready for analysis. Working across the full data engineering lifecycle, you will be involved in data integration, transformation, automation, CI/CD processes, platform maintenance, and troubleshooting. You'll gain broad exposure to modern data technologies, including Azure Data Factory and Databricks, while helping maintain a trusted data platform that serves as a single source of truth for critical business and project information.

The work you do will directly support better decisions on asset performance, project delivery, and operational outcomes, helping deliver greater value for customers and the people of NSW.

For more information on this position and business unit, view the role description and information pack.

About You

You are a hands-on Data Engineer with experience building and supporting data solutions in a cloud-based environment. You enjoy solving complex problems, have a strong focus on data quality and reliability, and take pride in delivering scalable and secure solutions.

To be successful in this role, you will bring:

• Hands on experience with Azure Data Factory (ADF) and Databricks.
• Strong programming and scripting skills in SQL and Python.
• Demonstrated experience in designing databases and developing data models.
• Experience in data cleansing, transformation, and pipeline management.
• Experience supporting DevOps and CI/CD platforms and practices.
• The ability to troubleshoot technical issues and maintain platform performance.
• Strong collaboration and communication skills, with a commitment to continuous improvement.

Most importantly, you'll be passionate about using data to support informed decision-making and delivering outcomes that make a meaningful impact across Sydney Metro and Transport for NSW.

Who We Are

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

Sydney Metro delivers Australia's biggest public transport project and first driverless railway. We engage with our customers and community, and contribute to vibrant and attractive places through station design, interchanges and precincts.

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, Wednesday 4th November 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.

Job Segment: Database, Web Design, SQL, Engineer, Technology, Research, Creative, Engineering