Business Intelligence Tech Lead

Business Intelligence Tech Lead – New Zealand Trade and Enterprise

Position based in Auckland or Wellington.

Who we are

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

What you’ll be doing

As our Technical BI Lead, you’ll play a pivotal role in delivering high‑quality Business Intelligence solutions that empower NZTE to make data‑informed decisions. You’ll lead two BI Analysts in the technical development and maintenance of scalable, reliable BI assets that align with NZTE’s data strategy.

Your responsibilities will include :

• Leading technical delivery of BI solutions, ensuring best practices in data modelling, performance optimisation, and Power BI reporting.
• Translating business requirements into efficient, scalable SQL‑based Data Marts.
• Developing robust ETL data pipelines using SQL stored procedures to support Data Mart creation and ongoing data refreshes.
• Applying deep expertise in SQL, Power BI, Azure SQL Server, Azure Data Factory, Synapse, and Analysis Services.
• Designing and implementing data structures using Kimball Dimensional Modelling techniques.
• Ensuring data quality and integrity through robust validation and cleansing practices.
• Collaborating with Data Engineers, Enterprise Systems Engineers, and business stakeholders to deliver comprehensive BI solutions.
• Providing hands‑on technical leadership and mentorship to BI Analysts.
• Evaluating and implementing emerging technologies such as Microsoft Fabric to future‑proof NZTE’s BI environment.

What you’ll need to be successful

Benefits and culture

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

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 :

We encourage early applications, as we may close the advert at any time without notice. The advert will close at the latest by 19 November 2025 at 9 am . This is an NZ Level 16 role.

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.

Seniority level : Mid‑Senior level

Employment type : Full‑time

Job function : Information Technology, Management, Project Management

#J-18808-Ljbffr