Senior Data and Business Intelligence Analyst

Oranga Tamariki; Wellington, Auckland; Hybrid; NZD 126,000 - 139,000; Full time

Job summary

Oranga Tamariki, Ministry for Children seeks a Senior Data & Business Intelligence Analyst to turn information into insights that drive decisions for tamariki, rangatahi and whānau. You will design data models and develop interactive Power BI dashboards from multiple data sources, translating findings for technical and non-technical audiences.

The role focuses on KPIs, deep-dive analysis, and delivering practical data solutions in collaboration with business and technology teams.

Qualifications

• 4+ years relevant experience in data analysis, insights or reporting.
• A relevant tertiary qualification or certification in data analysis, insights or reporting is highly desirable.

Responsibilities

• Developing Power BI dashboards and reports using DAX, data modelling and visualization best practice.
• Extracting, integrating and analysing data from multiple sources.
• Translating business requirements into technical reporting and data solutions.
• Establishing meaningful metrics and KPIs and undertaking deep-dive analysis.
• Working with business and technology teams to deliver practical, data-driven solutions.

Skills

Power BI

DAX

Data modelling

Data visualization

Power Apps

Power Automate

Excel

Data governance

Master data management

Stakeholder communication

Education

Tertiary qualification in data analysis

Tools

Power BI

Power Apps

Power Automate

Excel

Job description

Senior Data and Business Intelligence Analyst

• Wellington-based at the National Office on The Terrace


• Permanent, full-time opportunity


• Utilise your experience to turn information into insights that drive real decisions for Aotearoa New Zealand’s tamariki, rangatahi and whānau

Mō te tūnga | About the role

This is an opportunity to apply your technical expertise to complex, organisation-wide challenges.

As our Senior Data & Business Intelligence Analyst, you’ll work with data from multiple and sometimes unrelated sources, designing data models and developing interactive Power BI dashboards and reporting solutions that give leaders meaningful insight into organisational performance. You’ll undertake deep-dive analysis, identify trends and opportunities, and translate complex findings into clear recommendations for technical and non-technical audiences.

Key areas of focus include:

• Developing Power BI dashboards and reports, using DAX, data modelling and visualisation best practice


• Utilising your understanding of Power Apps and Power Automate is desirable


• Extracting, integrating and analysing data from multiple sources


• Translating business requirements into technical reporting and data solutions


• Establishing meaningful metrics and KPIs and undertaking deep-dive analysis


• Working with business and technology teams to deliver practical, data-driven solutions

The role sits within Tamariki and Whānau Services group and reports to the Manager Business Optimisation. You’ll work across functions and with senior leaders, business owners, regional teams, EPMO and technology colleagues, giving you the opportunity to influence how data and technology are used across a complex national organisation.

You’ll be an experienced analyst with the technical depth to build solutions and the ability to communicate your insights clearly.

Ideally, you’ll bring:

• Strong Power BI expertise, including DAX, data modelling and data visualisation


• Experience extracting and integrating data from disparate sources


• Strong analytical, problem-solving and data modelling capability


• Experience with Power Apps and Power Automate is desirable


• Advanced Excel skills and experience with process or workflow tools


• Exposure to data governance or master data management


• The ability to translate complex technical information for non-technical and senior stakeholders


• Experience working in transformation, process improvement or change environments.

A relevant tertiary qualification or certification in data analysis, insights or reporting is highly desirable, alongside 4+ years’ relevant experience.

Oranga Tamariki, Ministry for Children has a commitment to putting tamariki and rangatahi at the heart of what we do.

In our work, we aim to demonstrate these values:

• We put Tamariki first


• We believe Aroha is vital


• We respect the Mana of people


• We are Tika and Pono


• We value Whakapapa


• We recognise that Oranga is a journey

We are committed to ensuring that New Zealand is the best place in the world to be a child.

We are also committed to ensuring Oranga Tamariki partners with hapū, iwi and Māori organisations to find appropriate solutions for tamariki in need.

Nōu te rourou | What's in it for you

Oranga Tamariki offer a step-based remuneration package, that offers progression annually for experience through tenure. Annual remuneration for this position starts between $125,926 and $139,459 dependent on experience.

We also offer a vibrant and supportive team, flexible work options and a genuine commitment to wellbeing. We offer significant training and professional development so that you can thrive and grow. We welcome diversity and are committed to working in an inclusive and respectful way. This is your opportunity to apply your skills and experience to the wellbeing of tamariki and rangatahi.

Applications for this role close at midnight on Thursday 22 October 2026

If you are interested in any of our vacancies, please ensure that you make yourself familiar with our code of conduct as it sets out our expectations for our kaimahi and requires you to present at work free from the influences of both drugs and alcohol.

Location(s) Wellington, Lower Hutt, Upper Hutt, Porirua, Paraparaumu, Wellington