at New Zealand Transport Agency, Wellington
Mō tēnei tūranga mahi | About this role
Be a Data Warehouse expert while aligning data strategies and architecture
We are a close knit and committed team of specialists
Wellington or Auckland
Come and join the enterprise data warehouse team in shaping the data foundation at Waka Kotahi!
Te Whiwhinga mahi| The opportunity
Waka Kotahi sees data as a key building block to delivering on the agency's strategic objectives. The purpose of this role is to work closely with our data teams to develop a data environment that enables fast and high-quality outputs.
The enterprise data warehouse team plays a fundamental role in shaping the data foundation of the agency and the NZ transport sector at large. We are a close-knit entity empowered to determine the digital configuration of a data platform using our expertise.
The Data Engineer will have ownership over procuring, curating and documenting the data needs of our teams. This role will consider how we optimise the flows of data for analytical and business purposes, whilst ensuring it aligns to our longer-term data strategies and overall architecture.
If you enjoy working in a team, have influencing, problem solving and make a difference to make a difference by your Agile thinking, then this is the role for you.
Ko koe tēnei| About you
To be successful in this role, you will bring:
3 or more years of data engineering ETL experience, preferably in a complex organisation, with exposure to product sets such as WhereScape RED, SSIS, T-SQL, Azure is needed (SQL and Synapse). R/Python and ASW experience desirable but not essential.
A good understanding of data engineering concepts, including previous experience analysing, defining and structuring complex business rules/logic.
Understanding of ETL testing frameworks
Experience with requirements gathering and data analysis, with the ability to translate business needs into technical solutions.
Capability of building trusting relationship with the business to shape best data practice.
Experience in data modelling and data warehouse design.
Understanding of what is necessary to develop high quality data products (Data Factory, Power BI, etc.).
You will demonstrate knowledge of, or a willingness to gain an understanding of Te Ao Māori and promote tikanga and Te Reo Māori. You will also have knowledge of, or a willingness to gain an appreciation of te Tiriti o Waitangi (the Treaty of Waitangi) as it applies in the public sector.
Ko wai mātou| About us
Te Aukaha | Digital strengthens Waka Kotahi through supporting our people and delivering future-focussed solutions. We enable digital change and provide quality data, information and security services.
Along with our other benefits we also have new Waka Kotahi Life, Income Protection and Critical Illness Insurance scheme available for permanent employees.
To be considered for this position you must have a legal right to live and work in New Zealand.
Waka Kotahi is an equal opportunity employer (EOE). At the Agency we recognise the importance of diversity and inclusion and are committed to providing a working environment that embraces these values. Please let us know if you need any support or have any access requirements that will help you through the recruitment process.
Please note that we may begin shortlisting as we receive applications. We encourage early applications as we may withdraw the advertising at any time.