Responsibilities: Design, development and maintenance of data assetsTechnical point of contact for the delivery of reliable, reusable data assetsUse ETL and Big Data techniques to build out end-to-end data pipelineAuckland Transport (AT) is on a mission to transform Auckland into a vibrant city that moves, so that Aucklanders can connect with the people and places they love.
Be part of Auckland's exciting future and development.
From transport infrastructure to customer-focused solutions, we're creating seamless journeys across our city that enable businesses and Aucklanders to thrive.
We have an exciting opportunity for Data Engineers 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 platformsQuickly 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 builtUse ETL and Big Data techniques to build out end-to-end data pipelineQualifications: 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 solutionsPrevious experience with reporting applications and related tools, Power BI and SSaS would be advantageous.Strong communications and interpersonal skillsExperience working in an Agile or iterative environmentAt 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.
Benefits: Investment in your professional development and trainingOpportunity for greater leadership and accountabilityModern CBD (Wynyard Quarter) waterfront-based officePaid parental and partner leaveStudy assistanceHealth and Wellbeing benefitsProfessional membershipsAT Connect groups such as Mana ka Maori, Women@AT, and many more!Come join us in shaping the future of transport in Auckland - apply today!
If you would like to be part of our supportive and dynamic team and grow your career, then we would love to hear from you.
Applications close 12th January 2025.
Please note that our offices will be closed for our annual end of year shut down.
You may experience a delay in hearing from us across this time; we will be in touch after we return to work between 6th & 13th Jan 2025. We tiaki all those who use transport in Tamaki Makaurau.
#J-18808-Ljbffr