Business Intelligence Analyst

• We have created a diverse and collaborative environment that inspires lifelong learning opportunities.

• We offer hybrid working that enables work life balance + 5 Weeks Annual Leave

• We are focused on holistic wellbeing to support you to be your best self

This role can be based in either Wellington or Aucklan

**d

Who are we - Ko Te Taurapa Tūhono tēn**

ei

Te Taurapa Tūhono | New Zealand Trade and Enterprise (NZTE) connects New Zealand export businesses with opportunities to grow and go global. Their success is our success. We also connect investors with New Zealand investment opportunities across companies, sectors, and regions. If you are innovative with a can-do attitude and adventurous, then this might be the opportunity for y

**ou

What you'll be doing - Te whakama**

here

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 limite

• d to:

Collaborating with stakeholders to understand business requirements and translating them into SQL-based Data
- Marts.Utilising Kimball Dimensional Modelling techniques, specifically Star Schema, to design and implement data structures that support robust reporting and ana
- lyticsEnsuring the integrity and quality of data within the Data Marts, and implementing best practices for data validation and cle
- ansingUtilising Microsoft Power BI to develop and maintain high-quality reports and dashboards, ensuring data accuracy and relevance for business decision-m
- aking.Working closely with technical and business stakeholders to deliver comprehensive BI solu

**tions.

What you'll need to be successful - Ō P**

ūkenga

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 design and implement data structures using Kimball Dimensional Modelling techniques that support robust and flexible reporting that are optimised for performance and ease

of use.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 sk

• ills in:

Using Microsoft PowerBI, Azure SQL Server, Visual Studio, Analysis Services, Azure Devops, and ETL code merging
- using GitSQL-based Data Marts: Development, maintenance and deployment including designing and implementing ETL stored pr
- ocedures.Kimball Dimensional Modelling: In-depth knowledge of Kimball Dimensional Modelling techniques, particularly Star Schem
- a design.Power BI: Experience with Microsoft Power BI to create and maintain reports and da
- shboards.Analytical Skills: Strong analytical and problem-solving skills to interpret complex data and provide actionable

**insights.

Why you'll love working here - Nau mai ki Te Taura**

pa Tūhono

NZTE is a truly global organisation where we work across different time zones and offer flexibility because of this. We know that life isn't all about work so we will give you the right technology to allow you to work anywhere and balance your time. On top of this, we also offer 5 weeks annual leave so you can have that extra time in the year to enjoy what you

**love doing

What's next - T**

e ara ki tua

Have a read of the position
description (Business Intelligence
Analyst - PD), and if you are interested in joining a company that is all about growing New Zealand, apply with a CV and cove

r letter nowIf you have any issues uploading your CV and cover letter, please apply by sending directly to: tas

**

Applications close 9pm Sunday 26th J**

*anuary (NZST).

Please note: You must have the legal right to work in New Zealand 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 though; 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 A*

cquisition team.