Business Intelligence Analyst

This role is based in Auckland or Wellington.

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:

• Collaborating with stakeholders to understand business requirements and translating them into SQL-based Data Marts.

• Developing robust ETL data pipelines using SQL stored procedures to support Data Mart creation and ongoing data refreshes.

• Utilising Kimball Dimensional Modelling techniques, specifically Star Schema, to design and implement data structures that support robust reporting and analytics

• Ensuring the integrity and quality of data within the Data Marts, and implementing best practices for data validation and cleansing

• Utilising Microsoft Power BI to develop and maintain high-quality reports and dashboards, ensuring data accuracy and relevance for business decision-making.

• Working closely with technical and business stakeholders to deliver comprehensive BI solutions.

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.

You will need specific technical skills in:

• Using Microsoft PowerBI, Azure SQL Server, Visual Studio, Analysis Services, Azure Devops, and source control using Git

• Advanced SQL skills: development, maintenance and troubleshooting of SQL Data Mart and ETL stored procedures.

• Kimball Dimensional Modelling: In-depth knowledge of Kimball Dimensional Modelling techniques, particularly Star Schema design. Knowledge of Data Vault modelling is preferable.

• Power BI: Experience with Microsoft Power BI to create and maintain reports and dashboards.

• Analytical Skills: Strong analytical and problem-solving skills to interpret complex data and provide actionable insights.

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.

If this opportunity sounds like you and you want to be part of an organisation with a mission to support Kiwi ingenuity around the world, we'd like to hear from you. For more info about the benefits and culture, visit:

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.

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.