Business Intelligence Consultant (Senior)

The Company
Located in the sunny Hawkes Bay, this company is a well-established large manufacturer running a stable and successful operation. The company are known to be hardworking, and a team approach is a must. This company has a focus on sustainability, continuous improvement, and using high tech software and equipment to achieve efficiency gains.

People within the company are valued and developed and I have personally heard good feedback from people I have placed there in similar roles.

Current and Future Context
Over the last three years, a new data warehouse has been implemented. This is taking in source data feeds from their production systems and putting those into data models for straight replications. Then they are publishing Microsoft Power BI dashboard reports or people with excel or query tools can access the data models by connecting to the data warehouse itself. It is a Microsoft SQL Server database with SQL server replications.

The next couple of years will continue this trajectory of using smart data to inform Business Intelligence across the company. A major part of this will be the implementation of a new SAP 4/Hana ERP system and the associated tools that go with this, e.g., Embedded Analytics and SAP Cloud Platform. The company will continue to grow as a result of this.

The Role
This is a 12-month maternity leave cover position.

You will be a Senior Business Intelligence Consultant working on business intelligence projects. On the tools side your focus will be data analysis and visualisation and on the consulting side you will be working with internal clients, and this is a real key focus for this role.

You will be part of the Business Intelligence and Finance Team delivering enterprise integration, data warehousing, and business intelligence solutions.

Your internal clients will be a mixture of financial management accountants, Business Intelligence and Improvement Analysts, and managers across the various divisions of the business

We are after an all-rounder with good business acumen. We really want someone who before even going to the tools, firstly goes and makes sure they get a really clear understanding of what the requirements and desired outcomes are, what value the internal client is actually wanting to have from the data, and how people will actually consume it. Someone who can have the right discussions to extract all of the relevant information but also be able to challenge people and get the right result, not just what is first asked for.

You will understand transactional processes in business systems e.g., between ERP, Finance Systems, PLC’s and SCADA on Plant Machinery, and Stock Inventory Management etc. You will use this knowledge to create the right reporting and dashboards for financial, operational, and strategic solutions.

Technical Experience

  • Business Consulting on BI Solutions
  • Data Visualization Tools: Microsoft Power BI, Tableau, Cognos, Qlik or similar.
  • Microsoft SQL Database Design: SQL Server BI tools including SSIS, SSAS – Multi Dimensional and/or Tabular Models and SSRS, SSAS, DTS
  • Migration from Excel Spreadsheets: SSRS to DataMart’s customised development of dashboards and reports in Power BI visualisations/analysis tools
  • MDX and DAX Exposure
  • Dimensional Modelling: (Dimensions, Fact, ETL, Datamart /Data Warehouse concepts
  • Support, documentation, and training support around SSAS Tabular Models and Power BI.
  • Office 365 Deployment knowledge using Power BI Workspaces/SharePoint Online

Why Apply?
Progressive Company: This is a company who want to become one of the leading manufacturing companies in terms of both product and technology in the next few years, so nothing is off the table in terms of the tools you could work with.

Remuneration: Your work will be well compensated for with a competitive salary, Kiwisaver, and a few other benefits which all add up.

Location: the Hawkes Bay is a region that continues to grow, and not just grapes, but that too. My 22 degrees mid-winter holiday there certainly made me appreciate this sun-soaked coastal area, with its relaxed vibe, and relatively trafficless experience.

How to Apply
Technical Recruitment Solutions has been a trusted recruitment specialist for industry since 1996.

To apply for this position please click on the relevant button, alternatively, for a confidential inquiry contact David Milmine by email (david@trs.co.nz) or phone (04 595 4102).

Note: If this vacancy is not exactly what you are seeking, then please contact me in confidence to discuss your individual requirements.

All our jobs are listed at www.trs.co.nz

Due to current NZ border restrictions, we can only accept applications from people in NZ or returning NZ Citizens and Residents.