Analyst Reporting
Date: 15 Sept 2025
Location: Wellington, NZ
Company: Ministry of Social Development
About us
The Ministry of Social Development is a people-centred organisation. We’re in communities across the motu, working with partners to help New Zealanders be safe, strong and independent.
We provide social policy and advice to government and assistance, including income, employment and housing support to people of all ages, families, whānau and communities.
As a Te Tiriti o Waitangi partner we are committed to supporting and enabling Māori, whānau, hapū, Iwi and communities to realise their own potential and aspirations.
Our people are as diverse as the communities we serve. We care about the wellbeing and success of our people and provide a supportive and inclusive working environment where people can thrive and be who they are.
Analyst Reporting
• 12 months Fixed term/Secondment opportunity
• Wellington based
• Salary range: $90,743- $109,980
We’re looking for an Analyst – Reporting to join our team at MSD.
Mō te tūnga / About the role
This role is all about turning data into useful insights. You’ll help our operational, policy, and management teams – and the wider public – understand what’s happening and why. You’ll work closely with people across MSD, including senior leaders and the Minister’s office, to support decisions that affect New Zealanders every day.
To do well in this role, you’ll need strong technical and analytical skills, a good understanding of MSD (or the ability to learn quickly), and great communication and relationship skills. You’ll be confident working with data, picking out the important bits, and sharing them in a way that makes sense to others.
Mōu – Ngā Pūkenga me ngā Wheako / Skills and experience
We’re looking for someone who’s confident working with data and can turn complex information into clear insights. You’ll be comfortable working with others, asking the right questions, and helping shape solutions that meet real needs.
You will need:
• Advanced SQL skills – able to write complex queries to extract, transform and analyse data.
• Experience with Snowflake SQL – including stored procedures, user-defined functions (UDFs), and Snowflake-specific features.
• Strong understanding of dimensional modelling – including star schemas, facts, dimensions, grain, and surrogate keys.
• Intermediate Python skills – for scripting, automation and data wrangling.
• Great communication and collaboration skills – able to work with business teams, understand their needs, and translate them into technical solutions.
Relevant additional skills and experience:
• Familiarity with ETL tools like Informatica.
• Experience with Azure DevOps and Git – including version control and branching.
• Exposure to SAS or legacy code migration.
• Understanding of metadata management and data governance.
• Ability to contribute to process improvement and help build documentation standards.
We welcome your application and look forward to learning more about what you can bring to the team.
Position Description
Salary range: $90,743.00 - $109,980.00
How to apply
To apply, click the 'Apply Now' button to upload your CV, cover letter and complete the online application form.
Note: Your cover letter will be a key part of our assessment process, so please highlight how your experience relates to the key responsibilities listed in the position description.
All applications must be made online. If this is not possible or if you have any queries, please contact us at jobs@msd.govt.nz
Internal MSD Employees – please apply through your myHR portal at work. This will ensure that your myHR employee profile is visible as internal candidate.
Closing date: Wednesday 24th September, 2025.
Joining us
Joining MSD means being part of a whānau that celebrates the diversity each individual represents. We show manaaki, we care about the wellbeing and success of people and want everyone to thrive, and be who they are in a supportive and inclusive working environment. We work together to make a difference for communities while doing the right thing with integrity. We are a Treaty partner committed to strengthening relationships with Māori, Hapū, Iwi and communities to realise their own potential and aspirations.
If you have any support or access requirements, we encourage you to tell us when you apply so we can assist you through the recruitment process.
MSD has a COVID-19 vaccination policy that encourages, but does not require, employees to be fully vaccinated for COVID-19 and its variants, unless the role is identified as requiring vaccination at the time.
