Data Engineer

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 - $117734 - $146513

Be part of a flagship programme transforming data capability

About Us Mō mātou

Identity Data & Analytics (IDnA) is one of the branchs 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 Tetūnga

This is an ideal opportunity for a technically strong Data Engineer / Data Warehouse Developer who enjoys working with complex dataandbusiness 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

Youll bring strong technical capability along with a collaborative approach and passion for delivering high-quality data outcomes. Were 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 were a great place to work check out our website -About Internal Affairs - Careers with us - Benefits -

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.

Werecommitted to ensuring our application process is accessible to everyone. Please let us know if there is anysupport we can provide to ensure the process is accessible to you.

Applications for this role close23 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