Business Intelligence Tech Lead

This role is based in Auckland or Wellington.

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.

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.

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.

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 

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.