Data Engineer (x2)

• Phase one of a multi-year programme through to November 2026

• Work with cutting edge technology and IT professionals

• Appointing salary range - $117,734 - $146,513

“Be part of a flagship programme transforming data capability”

About Us | Mō mātou    

Identity Data & Analytics (IDnA) is one of the branch's main data analytics teams, bringing together data engineers, analysts and dashboard developers, and data scientists across the full data lifecycle, from sourcing and modelling through to BI, advanced analytics and insight delivery. We deliver data marts, BI products and statistical modelling that shape operational and policy decision-making

Important to note: The two Data Engineer roles are fixed-term supporting the establishment phase of a high-profile multi-year programme, funded through to November 2026. A funding decision in October 2026 will confirm continuation beyond that point. If approved, the programme is expected to run through subsequent phases to around mid-to-late 2028. While future phases are contingent on funding approval, we are committed to retaining talented people throughout the programme lifecycle wherever possible.

The role | Te tūnga   

This is an ideal opportunity for a technically strong Data Engineer / Data Warehouse Developer who enjoys working with complex data and business logic and modern Microsoft data platform practices: 

• Build and maintain data pipelines from structured and semi-structured sources into the data platform and curated data marts, including warehouse tables, views, staging layers and analytical datasets.

• Apply engineering standards to dimensional modelling and reusable data mart design for BI, analytics and reporting.

• Translate business rules and source-system logic into clear, maintainable SQL transformations, stored procedures and scripts.

• Migrate legacy reporting logic, including SAS processes, into modern Microsoft data platform solutions, reconciling outputs across source systems, legacy reports, dashboards and new datasets to build confidence in the data.

• Document pipelines, lineage, transformation logic, business rules, assumptions and known limitations, and apply data quality checks to deliver governed, trusted, reusable data products.

• Work with other data engineers, analysts, data scientists and business stakeholders to ensure datasets are fit for purpose, and contribute to reusable standards and patterns that improve consistency and maintainability across data platform and BI delivery.

What you bring | Nōu te rourou 

You'll bring strong technical capability along with a collaborative approach and passion for delivering high-quality data outcomes. We're looking for someone with:

• Significant experience in data engineering, data warehousing, BI development or a closely related role.

• Strong SQL, including joins, transformation logic, stored procedures or scripts, query testing and performance-aware development.

• Strong grasp of data warehousing concepts: dimensional modelling, data marts, fact tables and dimensions, with experience building or maintaining ETL/ELT pipelines and analytical datasets.

• Experience with Microsoft data platform technologies such as Microsoft Fabric, Power BI, Synapse, Azure Data Factory, SQL Server and Azure DevOps.

• Experience with structured and semi-structured data formats and sources, such as Parquet, JSON, XML and APIs.

• Strong analytical and problem-solving skills, with attention to data quality, reconciliation and edge cases, and the ability to document technical logic, data lineage and business rules clearly.

• Good communication and stakeholder engagement, including explaining technical issues to non-technical audiences, and working collaboratively across engineering, analytics and business teams while taking ownership of assigned work.

• Desirable: interpreting, supporting or migrating legacy SAS EG or SAS Viya reporting logic; Python; exposure to data architecture or modelling; familiarity with agile.

For you | Mōu

At the Department of Internal Affairs, we are committed to offering a collaborative and innovative culture where your perspective and ideas will be welcomed.

To learn more about the diverse, important mahi we do at the Department and see why we're a great place to work check out our website  https://www.dia.govt.nz/

Benefits -  About Internal Affairs - Careers with us - Benefits - dia.govt.nz

To review the full job description for the Data Engineer role please click here

How to apply | Me pēhea te tuku tono

We are unable to accept applications via email. Please click the apply button to submit your application.

We're committed to ensuring our application process is accessible to everyone. Please let us know if there is any support, we can provide to ensure the process is accessible to you. 

Applications for this role close  23 August, 2026 @5pm  Please also note that you must have New Zealand Citizenship to be considered for this role.

For more information on the role please contact Hien Nguyen, Manager Identity Data & Analytics at  hien.nguyen@dia.govt.nz