Business Intelligence Analyst

Benefits

• We have created a diverse and collaborative environment that inspires lifelong learning opportunities.
• We offer hybrid working that enables work life balance + 5 Weeks Annual Leave.
• We are focused on holistic wellbeing to support you to be your best self.

Who we are

Te Taurapa Tūhono | New Zealand Trade and Enterprise (NZTE) has a clear purpose – to grow companies internationally, bigger, better and faster, for the good of New Zealand.

What you’ll be doing

This role is key to enabling NZTE's business objectives by leveraging company data to drive business solutions through designing and developing SQL‑based Data Marts, and dashboards, tools and reports that drive value from the organisation's information. This includes but is not limited to :

What you’ll need to be successful

This role will suit someone who has proven experience in successfully translating business requirements into efficient and scalable SQL‑based Data Marts that meet stakeholder expectations in terms of functionality and performance. The role requires someone who can develop ETL pipelines using SQL stored procedures and design data structures using Kimball Dimensional Modelling techniques that support robust and flexible reporting.

Being able to design and deploy quality dashboards, tools and reports that drive value from the organisation's information is a must. You will also need to be highly computer literate and experienced working in a Data Warehouse environment and experience in one or more current Business Intelligence applications, preferably the Microsoft stack.

Technical Skills

Why you’ll love working here

NZTE offers flexible work arrangements (three days in the office), a dynamic environment, and the chance to build valuable business networks with a talented, diverse team. Our collaborative approach supports delivering greater value to customers; this is your opportunity to make an impact.

What’s next

For more information, please read the position description (Business Intelligence Analyst - PD).

If this sounds like you, please apply immediately with your cover letter and CV as we are reviewing and progressing applicants as they come in.

We encourage early applications, as we may close the advert at any time without notice. We will close the advert at the latest by 26 November 2025 at 9am.

This is an NZ Level 16 role.

Please note the recruitment process includes a technical assessment where candidates design and implement a data model, ETL pipeline and Power BI report for a dataset provided by NZTE.

The legal right to live and work in NZ is required to apply for this role.

Equal Opportunity Statement

We believe New Zealand is good for the world. New Zealand Trade and Enterprise (NZTE) is an equal opportunity employer. At NZTE it is all about our people and we seek diversity of thought; we welcome and encourage you to apply regardless of ethnicity, gender, religion, age, sexual orientation, gender identity, neurodiversity or disability. If we need to make specific accommodations in any part of the interview process, please note this in your application or discuss with the Talent Acquisition Partner.

#J-18808-Ljbffr