Business Intelligence Tech Lead

New Zealand Trade and Enterprise; Auckland, Wellington; Hybrid; NZD 90,000 - 120,000; Full time

Job summary

A leading government agency in New Zealand seeks a Technical BI Lead in Auckland or Wellington. The role involves leading BI Analysts, delivering high-quality Business Intelligence solutions, and ensuring best practices in data modelling and reporting. Ideal candidates have advanced SQL and Power BI skills, with at least four years of experience in Business Intelligence. The position offers flexible work arrangements and a dynamic work environment.

Benefits

Flexible work arrangements

Dynamic environment

Valuable business networks

Qualifications

• At least four years of relevant technical experience in Business Intelligence.
• Strong communication and stakeholder engagement capabilities.
• A self-directed, adaptable approach with a commitment to continuous improvement.

Responsibilities

• Leading technical delivery of BI solutions.
• Translating business requirements into SQL-based Data Marts.
• Developing robust ETL data pipelines using SQL stored procedures.

Skills

Advanced SQL skills

Power BI expertise

ETL data pipeline development

Kimball Dimensional Modelling

Stakeholder engagement

Git familiarity

Azure SQL Server

Azure DevOps

Tools

Visual Studio

Azure Synapse Analytics

Azure Purview

Job description

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

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

To thrive in this role, you’ll bring:

• At least four years of relevant technical experience in Business Intelligence, ideally within the Microsoft stack.
• Advanced SQL skills and deep experience with Power BI.
• Experience in developing ETL data pipelines using SQL stored procedures or other tools.
• Strong knowledge of Kimball Dimensional Modelling, particularly Star Schema design. Knowledge of Data Vault modelling is preferable.
• Familiarity with source control tools such as Git is highly desirable.
• Experience with Visual Studio, Azure DevOps, Azure Synapse Analytics and Azure Purview is an advantage.
• Excellent solution design and analytical skills.
• Strong communication and stakeholder engagement capabilities.
• A self‑directed, adaptable approach with a commitment to continuous improvement.

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: https://www.nzte.govt.nz/page/life-at-nzte

What’s next

For more information, please read the position description.

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 19 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.