Ministry of Foreign Affairs & Trade Looking for Data Developer at Wellington Central, Wellington Full Time

Company description:

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.

Job description:

• Use your data skills to make a difference in the world
• Create and curate the Ministry’s new enterprise data warehouse
• Join the team in an exciting time as more data is acquired into the new data warehouse

The Ministry of Foreign Affairs and Trade is looking for a Data Developer to join our new Data and Analytics Services team.

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 boutique tight-knit, highly skilled team that works closely with stakeholders. There are great opportunities to be involved in interesting work.

Our work is valued as it supports key Ministry policy development and service delivery.

In this role you will:

• Develop, improve and maintain a high-quality and fit-for-purpose data warehouse
• Create and package code and reports for the data warehouse
• Coach and support data analysts, including Pacific Development Group data analysts, to write SQL code and specifications

The appointment range for this role is $95,555 (85%) to $129,281 (115%) total remuneration including employer contribution to kiwisaver – negotiable depending on experience.

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 [email protected]

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 17 November 2022.