Business Intelligence Tech Lead

6 days ago

Auckland City, New Zealand New Zealand Trade and Enterprise Full time

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

**What’s next**

For more information, please read the position description.

This is an NZ Level 16 role.

_

  • Business Intelligence

    5 days ago

    Auckland CBD, New Zealand Ricoh New Zealand Ltd Full time

    Love turning data into smart decisions? Passionate about automation and insights? Join Ricoh and help shape the future of the print industry.About the RoleWe're after a sharp Business Intelligence & Automation Analyst to lead Ricoh's data strategy. You'll drive BI initiatives, build analytics solutions, and support smarter decision-making across the...

  • Business Intelligence Tech Lead

    7 days ago

    Auckland CBD, New Zealand New Zealand Trade & Enterprise Full time NZ$120,000 - NZ$180,000 per year

    This role is based in Auckland or Wellington.Who we areTe 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 doingAs our Technical BI Lead, you'll play a pivotal role in delivering high-quality Business Intelligence...

  • Lead Intelligence Analyst

    2 weeks ago

    Auckland City, New Zealand New Zealand Government Full time

    New Zealand Police is working with the community to make New Zealanders be safe and feel safe. With over 13,000 staff, we provide policing services 24 hours a day, every day. We operate by land, sea and air, manage over 860,000 emergency calls a year and are always actively preventing crime and crashes. We’re working towards specific goals and targets...

  • Lead Intelligence Analyst

    2 weeks ago

    Wellington City, New Zealand New Zealand Government Full time

    New Zealand Police is working with the community to make New Zealanders be safe and feel safe. With over 13,000 staff, we provide policing services 24 hours a day, every day. We operate by land, sea and air, manage over 860,000 emergency calls a year and are always actively preventing crime and crashes. We’re working towards specific goals and targets...

  • Business Intelligence Specialist

    7 days ago

    Auckland, Auckland, New Zealand Ampstek Full time NZ$80,000 - NZ$120,000 per year

    Hi All,Greetings from Ampstek,Actively Hiring for Business Intelligence and Data Analytics.Role: Business Intelligence and Data Analytics.Location: AucklandDuration: 6 Months Contract + ExtensionJob DescriptionStrong experience in migrating reports from legacy platforms (e.g., Tableau et.,) to Power BI6+ years of experience in Business Intelligence and Data...

  • Principal Business Intelligence Developer

    2 days ago

    Wellington City, New Zealand New Zealand Government Full time

    Be responsible for establishing best BI practices, - Lead enterprise BI development. - Salary range: $125,000 to $148,000 - Flexible working available - Wellington based role/CBD location. If you're looking for your "why," then come and join us at the TEC. We truly believe in the transformational benefits of education and training, and as a result we invest...

  • Lead Intelligence Analyst Tnoc

    2 weeks ago

    Wellington City, New Zealand New Zealand Police Full time

    **Lead Intelligence Analyst Transnational Organised Crime (TNOC)** - **Based in Wellington**: - **2-year fixed term secondment**: - **Applicants must reside in Wellington** **About us** The Transnational Organised Crime (TNOC) Strategy brings together 20 government agencies to tackle TNOC by setting out a framework for a coordinated, whole-of-system...

  • Business Intelligence

    1 week ago

    Auckland City, New Zealand Lightspeed Commerce Full time

    **Hi there! Thanks for stopping by**: Are you actively looking for a new opportunity? Or just checking the market? Wellyou might just be in the right place! We're looking for a Business Intelligence & Analytics Manager to join our team. The purpose of this role will be to lead and set direction for Lightspeed's Business Intelligence function which monitors...

  • Pega Architect – Banking Domain

    7 days ago

    Auckland, Auckland, New Zealand Tech Mahindra Full time NZ$120,000 - NZ$180,000 per year

    About Us:At Tech Mahindra(Tech Mahindra | Connected World, Connected Experiences), we live the philosophy of connected world and connected experiences. We thrive on change that is powered by the intelligent symphony of technology and humans designing meaningful and sustainable experiences. Consumer 'experiences' are driving and disrupting industries like...

  • Solution Architect

    2 weeks ago

    Auckland City, New Zealand Tech Mahindra Full time

    **Job title/Position**:Solution Architect** Tech Mahindra offers innovative and customer-centric digital experiences, enabling enterprises, associates, and the society to Rise. We are a USD 5.1 billion organization with 145,000+ professionals across 90 countries helping almost 1200 global customers, including Fortune 500 companies. At Tech Mahindra, we live...