Insights Analyst (Fixed Term)

Napier City Council; Napier; On-site; NZD 101,000 - 112,000; Full time

Benefits offered by this job

Employee Assistance Program (OCP)

Quarterly values awards + Social club

Free flu vaccinations (annual)

Ka Awatea Cultural Wānanga + NCC KapaH

Te Reo Māori language classes

Flexible work arrangements

Job summary

Napier City Council is seeking an experienced Insights Analyst to join the Data & Digital team for an 18-month fixed term. You will work with cross-functional teams to clarify questions, gather data, and translate findings into practical recommendations for service delivery, people analytics, asset management and performance.

The role emphasizes SQL, Power BI and governance, with opportunities to shape data culture and deliver dashboards, models and reports that support leaders in Napier.

Qualifications

• Five years or more experience in analytics, BI, insights, or related role delivering data and reporting solutions.
• Strong SQL skills and experience extracting, transforming and modelling data from multiple systems.
• Hands-on Power BI capability, including DAX, semantic models and dashboard development.
• Experience gathering requirements and delivering analytical or business improvement projects from start to finish.
• Ability to build trusted relationships, explain findings to different audiences and influence decisions.
• Relevant degree or equivalent experience with sound data validation and governance practices.

Responsibilities

• Clarify business needs, define requirements and identify where data can support better decisions.
• Extract, transform and model data from multiple systems using SQL.
• Develop Power BI dashboards, semantic models and reports.
• Analyse performance, trends and risks, translating findings into practical recommendations for leaders.
• Scope and deliver analytical and business improvement projects, managing priorities and outcomes.
• Strengthen data quality, documentation and reporting practices.

Skills

SQL

Power BI

Business analysis

Data modelling

Education

Bachelor's degree or equivalent experience

Tools

DAX

Job description

Good analysis starts with understanding the question that needs answering. At Napier City Council, we’re looking for an experienced Insights Analyst who can work with teams to clarify what they need to know, investigate the data and turn findings into practical recommendations. From service delivery and people analytics to asset management and organisational performance, your work will help leaders understand what’s happening, where improvements are needed and how to respond.

Joining our Data & Digital team for 18 months, you’ll take work from the initial business question through to a completed reporting or improvement solution. Reporting to the Data & Insights Lead, you’ll bring together data from multiple systems, develop meaningful performance measures and build reliable datasets and Power BI reporting. Alongside this, you’ll identify opportunities to improve the systems and processes behind the information, helping teams build confidence in the data they use.

We’re looking for someone who brings proven SQL, Power BI and business analysis experience, with the judgement to ask the right questions and the confidence to take ownership of delivery. In return, you’ll have the opportunity to apply your expertise across a broad range of Council activities, delivering useful solutions during the appointment and leaving reporting and processes that teams can continue to use.

Te Āheinga The Opportunity

In this role, you will:

• Work with teams to clarify business needs, define requirements and identify where data can support better decisions.
• Extract, transform and model data from multiple systems using SQL, creating reliable foundations for analysis.
• Develop Power BI dashboards, semantic models and reports that make complex information clear and useful.
• Analyse performance, trends and risks, translating findings into practical recommendations for leaders.
• Scope and deliver analytical and business improvement projects, managing priorities and agreed outcomes.
• Strengthen data quality, documentation and reporting practices, addressing underlying issues and improving processes.

He kōrero mōhou About You

You’re comfortable working through an unclear request, asking useful questions and recommending an approach. You bring the technical depth to build the solution yourself and the communication skills to explain what it means. With an established track record, you’ll be ready to take ownership of delivery as you learn our systems and priorities.

You will bring:

• At least five years’ experience in analytics, business intelligence, insights, business analysis or a related role, delivering practical data and reporting solutions.
• Strong SQL skills and experience extracting, transforming and modelling data from multiple systems.
• Hands-on Power BI capability, including DAX, semantic models and dashboard development.
• Experience gathering requirements, scoping work and delivering analytical or business improvement projects from start to finish.
• The ability to build trusted relationships, explain findings to different audiences and influence decisions through clear recommendations.
• A relevant degree or equivalent experience, supported by sound data validation, documentation and governance practices.

Experience with local government, enterprise systems or cloud analytics platforms would be useful.

Ngā painga mōhou What we Offer

• Employee Assistance Program (OCP)
• Quarterly values awards + Social club
• Free flu vaccinations (annual)
• Ka Awatea Cultural Wānanga + NCC Kapa Haka
• Te Reo Māori language classes
• Flexible work arrangements

If you enjoy getting close to the business, solving technical problems and seeing your analysis put to use, we’d like to hear from you.

This is a 18 month fixed term opportunity, working 40 hours per week, Monday-Friday. You will be based in Napier.

The annual salary package for this role is $100,511 - $112,336 (including KiwiSaver), with the final offer depending on your skills and experience.

We will be interviewing applications as we receive them and may close the role when we have found the right person.

He kōrero mō Te Kaunihera o Ahuriri - About NCC

At Napier City Council, we are proud to be an equal opportunity employer that values diversity. We welcome applicants from all backgrounds and work to make our hiring process fair and accessible. If you need any support or adjustments during your application or interview, let us know—we’re happy to help!

Our success is grounded in strong partnerships with Mana Whenua and Iwi, supported by our Māori Partnerships team, Te Waka Rangapū, which builds cultural capability through education and training.

Before you join, you’ll need to complete pre-employment checks (including criminal background checks, with some roles requiring health screening and drug & alcohol testing). As an NCC employee, you may also be called on to support Civil Defence emergencies when our community needs us most.

Please visit Napier City Council Careers website to see full job description

Job Description - Insights Analyst | Fixed Term - 18 Months