Senior Data and BI Analyst

Discover a career with purpose at MBIE
- Data and BI Analyst focused role using SQL, SSRS and Power BI
- Step up role for a Data Analyst or BI Analyst with growth opportunities within the organisation
- Work closely with Data Engineers
- Opportunity to work in Energy and Resources sector
- Permanent full-time opportunity, based in Wellington
- Salary range $115,585 to $138,028 plus KiwiSaver and Wellness Benefit

**Tēnei tūranga - About the Role**:
The purpose of the Senior Data and BI Analyst role is to unlock the value in data held by the Energy & Resource Markets (ERM) branch in support of the regulatory functions of NZ Petroleum and Minerals. The Senior Data and BI Analyst is responsible for operational reporting and data analytics functions, including:

- Taking a lead and maintaining regulatory data (including the catalogue of in-house developed reports), engaging across ERM operational teams to understand their business drivers and processes and in turn their reporting and analytics needs.
- Leading and performing the analysis, design, delivery of reporting functions within the Petroleum and Minerals Regulatory System including business intelligence dashboards.
- Identifying opportunities for innovation in reporting and analytics capability by keeping abreast with developments within the IT industry and other parts of MBIE.
- Collaborating with our partners in MBIE’s Digital, Data & Insights group for the design, implementation and ongoing provision and continual improvement of data marts, reporting dashboards and business intelligence services.

About Energy and Resource Markets
The Energy and Resource Markets group provides policy and regulatory advice on energy markets, strategic advice, operational regulation, compliance services and external sector leadership to ensure that New Zealand’s oil, gas, mineral and coal resources are effectively managed.

Ngā pukenga me ngā wheako e hiahiatia ana - Skills and Experience Required

**To be successful in this role you will need the following**:

- Demonstrated experience working with Business Intelligence and analytical principles, methodologies and conventions along with a demonstrated commitment to developing and maintaining specialist skills and knowledge in the area.
- Highly developed analytical and conceptual thinking ability.
- Advanced (or intermediate) knowledge and experience in using reporting and BI tools like MS SQL Server Reporting Services (SSRS), MS Power BI. Strong technical skills including advanced SQL.
- Significant experience in data quality management, data visualisation and data governance framework.
- Ability to translate information and analysis into outputs which are readily interpreted by operational areas.
- Demonstrated ability to gather, manipulate, analyse data, and generate appropriate reports in a timely manner.
- Strong understanding of transactional and reporting databases and Data warehouses.
- Excellent written presentation skills. The ability to synthesise business, policy and technical issues and present them in with simplicity and clarity that can be understood by a range of audiences.

**Ētahi kōrero mō MBIE - About MBIE**:
MBIE's goal is to create a resilient and high-performing economy that delivers real and ongoing quality of life for all New Zealanders.
We do this by working with others to create an environment that supports businesses to be more productive and internationally competitive, enables all New Zealanders to participate in the economy through improved job opportunities and by working to ensure quality housing is more affordable.

People are at the heart of our mahi, our way of working is guided by our values which shape our behaviours.
- Mahi Tahi - Better Together
- Māia - Bold and brave
- Pae Kahurangi - Build our Future
- Pono Me Te Tika - Own It

Our aspirations are echoed in our Māori identity - Hīkina Whakatutuki - which broadly means ‘lifting to make successful'.
MBIE recognises the partnership founded under Te Tiriti o Waitangi between Māori and the Crown and is committed to giving effect to Te Tiriti o Waitangi. We will do this through enduring, meaningful and effective partnerships with iwi, Māori, other Māori groups/organisations and the Crown, as this is critical to enable economic and social development, both for Māori and for wider Aotearoa New Zealand. We are committed to continuing to partner with iwi in order to find new sustainable solutions to address long standing systemic and cross-cutting issues facing Māori and wider Aotearoa New Zealand and we are also committed to identifying opportunities for iwi to lead and creating an enabling environment for iwi to leverage these opportunities.

E mōhio ana a Hīkina Whakatutuki i puea ake te kōtuinga I waenganui i a ngāi Māori me te Karauna i Te Tiriti o Waitangi, ā, kei te whai ia ki te whakaū ake i Te Tiriti o Waitangi. Mā te whai kiko o ngā kōtuinga ahungaroa o ngāi wi, o ngāi Māori, me ētahi atu rō