• Design, development and maintenance of data assets
• Technical point of contact for the delivery of reliable, reusable data assets
• Use ETL and Big Data techniques to build out end-to-end data pipeline

Te Whiwhinga mahi | The opportunity

We have an opportunity for a Data Engineer to join our team. This role will be responsible for the design, development and maintenance of data assets to support our colleagues across Auckland Transport as well as our Council partners.

You will be participating in the design and development of an enterprise data warehouse platform built on the Microsoft SQL Server. You will be the technical point of contact for the delivery of reliable, reusable data assets. This is a challenging role working on the development of sustainable, scalable solutions.

This includes:

• Development and automation of sustainable data sets, utilising different data sources and platforms
• Quickly and effectively solving complex and interesting problems arising from high volume, high speed transactional processing and large-scale data warehouse design.
• Liaise and consult with key colleagues to ensure correct and / or curated datasets are built
• Use ETL and Big Data techniques to build out end-to-end data pipeline

Ko koe tēnei | About you

You will bring with you 3+ years hands on experience in Data Warehousing, preferably using SQL Server and Wherescape RED. Alongside this you will also have:

• Proven experience in data and dimensional modelling design and development of data schemas using Kimball methodology.
• Proven track record in designing, developing and implementing innovative data integration and data warehouse solutions
• Previous experience with reporting applications and related tools, Power BI and SSaS would be advantageous.
• Strong communications and interpersonal skills
• Experience working in an Agile or iterative environment

Ko mātou tēnei | Our Organisation

At AT, we embrace inclusion and fully support building a diverse workplace where people come first and we feel safe, respected, valued and supported, inclusive of our differences. Our values are more than just words - they are integral to everything we do. Manaakitanga - We care, Tiakitanga - Safe with us, Whanaungatanga - We connect, Auahatanga - Better, bolder, together.

In addition, we also offer:

• Investment in your professional development and training
• 25% discount on public transport services across Auckland
• Opportunity for greater leadership and accountability
• Modern CBD (Wynyard Quarter) waterfront-based office
• Paid parental and partner leave
• Study assistance
• Health and Wellbeing benefits
• Professional memberships
• AT Connect groups such as Mana ka Māori, Women@AT, and many more!

Tono mai ināianei! | Apply Now!

Come join us in in shaping the future of transport in Auckland - apply today! If this sounds like your new next leadership role then we'd love to hear from you. Applications close 23rd March 2026.

For further information or a confidential chat, please contact Rennie Sharma [email protected]

Ka tiaki mātou i te hunga katoa ka eke waka i Tāmaki Makaurau. We tiaki all those who use transport in Tāmaki Makaurau.

#LI-RS1