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 Auckland 

Who are we:

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 you!  

What you'll be doing: 

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 limited 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 analytics 

- Ensuring the integrity and quality of data within the Data Marts, and implementing best practices for data validation and cleansing  

- Utilising Microsoft Power BI to develop and maintain high-quality reports and dashboards, ensuring data accuracy and relevance for business decision-making. 

- Working closely with technical and business stakeholders to deliver comprehensive BI solutions. 

What you'll need to be successful:

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 skills in:  

- Using Microsoft PowerBI, Azure SQL Server, Visual Studio, Analysis Services, Azure Devops, and ETL code merging using Git 

- SQL-based Data Marts: Development, maintenance and deployment including designing and implementing ETL stored procedures. 

- Kimball Dimensional Modelling: In-depth knowledge of Kimball Dimensional Modelling techniques, particularly Star Schema design. 

- Power BI: Experience with Microsoft Power BI to create and maintain reports and dashboards. 

- Analytical Skills: Strong analytical and problem-solving skills to interpret complex data and provide actionable insights. 

Why you'll love working here: 

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:

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 cover letter showcasing your relevant experience now!

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.

Applications close at 9am on Friday 4th April (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 Acquisition team.