Business Intelligence Analyst at New Zealand Trade And Enterprise
Auckland City, Auckland, New Zealand -
Full Time


Start Date

Immediate

Expiry Date

05 Apr, 25

Salary

0.0

Posted On

26 Mar, 25

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Analytical Skills, Sql Server, Git, Visual Studio, Stored Procedures, Maintenance, Data Marts, Dashboards, Power Bi, Microsoft Power Bi, Analysis Services

Industry

Information Technology/IT

Description
  • 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
Responsibilities

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