Data Warehouse Developer at Ministry of Foreign Affairs & Trade, Wellington

The Ministry acts in the world to build a safer, more prosperous and more sustainable future for New Zealanders.

Kia hangai ake e te Manatu he ao-haumaru, ao-tonui, ao-pumau, ki te oranga tonutanga mo Aotearoa whanui.  

Mō mātou - About us

Our people represent New Zealand on and offshore, and in doing so make New Zealanders safer and more prosperous.  By building connections with and influencing other countries and international institutions, we advance New Zealand’s interests and pursue New Zealand's values.  We provide advice to the Government on the implications for New Zealand of what is happening in the world. 

Kōrero mō te tūranga - About the role  

The Data Developer role sits within the Ministry’s Knowledge, Information and Analytics team. The purpose of the role is to support Ministry staff and other stakeholders to use data for insights and decision-making, and have information at their fingertips through leading the creation and curation of an authoritative, single source of truth, that’s able to amalgamate data holdings across the Ministry and external sources. This role is a Ministry technical thought leader for data warehousing. 

You will join a tight-knit and highly skilled team that works closely with stakeholders. There are great opportunities to be involved in highly valued and interesting work that supports Ministry policy development and service delivery.

In a Data Developer role you will:

• Develop, improve and maintain a high-quality and fit-for-purpose data warehouse
• Create and package code and reports to transform and integrate data for the data warehouse
• Provide techinical thought leadership, coaching and support (including supporting data analysts to write SQL code and specifications)
• Develop knowledge of the key datasets which can support the Ministry’s work

The Ministry is responsible for managing the New Zealand Aid Programme. One of the Data Develper roles has a specific focus on aid data and will work closely with Pacific Development Group data analysts.

Mā‎ wai te mahi nei? – Who are we looking for?

• You love data, the more complex the better – understanding it, organising it, and managing it
• You are comfortable working across teams to curate one of the Ministry’s most important data assets
• You have excellent knowledge of best practice and theory in data warehousing, and have significant experience under your belt applying that theory
• You have advanced SQL skills and be an experienced user of the Microsoft suite of analytic products (e.g. SSMS and SSIS). Power BI skills would be an advantage

Ngā hua o te mahi i te Manatū Aorere - Why MFAT?

We are committed to a focus on leadership, talent, training and development, and flexible work options.  Check out our benefits page to find out more about why we love working here.

We are also working to grow the diversity of our workforce and the inclusive nature of our workplace. Click on our diversity and inclusion page to find out more.

Mō mātou - About us

Our people represent New Zealand on and offshore, and in doing so make New Zealanders safer and more prosperous.  By building connections with and influencing other countries and international institutions, we advance New Zealand’s interests and pursue New Zealand's values.  We provide advice to the Government on the implications for New Zealand of what is happening in the world. 

Please note:

This is not a Foreign Policy/diplomatic role.  This is a ‘Corporate’ role (known here as a Specialist role) based in central Wellington, NZ.  

While it is not usual for specialist staff to be ‘posted’ outside of NZ, from time to time a specialist role overseas becomes available at one of our embassies, high commissions, missions or consulates. To be considered for one of these positions you will need to apply and be considered via a competitive recruitment process.

If you have an interest in an MFAT foreign policy career you will be welcome to apply for this either via our graduate recruitment or mid-level foreign policy recruitment campaigns.

Me pēhea te tuku tono - To Apply/Interested?

Apply today with your CV and cover letter.

For a copy of the position description please click here   

For a confidential discussion please email Bryce Cleland

You must be a New Zealand Citizen or Permanent Resident and able to obtain and maintain an appropriate NZ Government Security clearance.

Use this online tool to self-check your eligibility for a Top Secret security clearance. Please note that this tool is not part of the formal security clearance process:

http://www.protectivesecurity.govt.nz/eligibility-tool

Applications close at midnight on 6 February 2023.