Data Engineer

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.Key responsibilities include : 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 pipelineTo be successful in this role, 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 environmentWe offer a range of benefits, including : Investment in your professional development and training25% discount on public transport services across AucklandOpportunity 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!

We are an equal opportunities employer and welcome applications from all qualified candidates.

Auckland Transport is committed to diversity and inclusion, and we strive to create a workplace where everyone feels safe, respected, valued and supported.

#J-18808-Ljbffr