Financial Insights Analyst
Hamilton City Council · 1001-5000 employees
What the role involves
- Preparing financial reports
- Analyzing data
- Developing dashboards
What they ask for
10+ years experience developing reports and dashboards with Power BI and Excel; bachelor's degree in finance, accounting, economics, business, data analytics or equivalent; strong analytical and stakeholder skills.
- 10+ yrs experience
- Bachelor's degree
About the job
Company Description:At Hamilton City Council, our people are united by a shared purpose: helping make Hamilton the best place to live, work, and play. As one of New Zealand's largest city councils, we're proud to serve a growing and vibrant community while delivering services and projects that improve the wellbeing of Hamiltonians every day.
You'll join a team that values collaboration, innovation, and community impact. Together, we're on track to being one of New Zealand's leading community-focused councils, where everyone matters and every contribution helps shape the future of our city.
If you're looking for meaningful work, a supportive team, and the opportunity to make a real difference in your community, you'll find it here.
Job Description:He angituutanga: The opportunity
Help turn financial data into meaningful insights that support better decisions for Hamilton.
About the opportunity:
We are looking for a Financial Insights Analyst to join our Finance and Enabling Services group.
In this role, you will support the delivery of clear, accurate and timely financial and performance reporting. You will help prepare reports, dashboards and analysis that explain organisational performance, identify key trends and drivers, and support informed decision-making across Council.
Working alongside the Senior Financial Insights Analyst, Financial Reporting and Insights Manager and the wider Finance team, you will contribute to a more consistent and integrated view of financial and non-financial performance.
This is a great opportunity for someone who enjoys working with data, improving reporting processes and translating complex financial information into clear, practical insights.
What you will be doing:
In this varied role, you will:
- Assist with preparing regular financial and performance reports for internal and external stakeholders.
- Prepare and analyse financial and non-financial data and combine into clear, integrated reporting.
- Help identify trends, variances and the key drivers of organisational performance.
- Support the development and maintenance of dashboards and reporting tools using Power BI and Excel.
- Contribute to the automation and continuous improvement of reporting processes.
- Work with Finance Business Partners and other teams to gather information and respond to reporting queries.
What you will bring:
You will be an analytical and detail-focused finance professional who takes pride in producing accurate, high-quality work.
You’ll be a great fit if you have:
- Practical experience building engaging and insightful Power BI reports and dashboards
- Strong capability in Power Query and DAX (SQL experience will be a bonus)
- Strong analytical capability and experience working with complex datasets and finance models
- Intermediate to advanced Microsoft Excel skills
- A continuous improvement mindset and curiosity for solving problems
- Confidence working independently and taking ownership of your work
Qualifications:Oo puumanawa me oo wheako | Your skills and experience
- 10+ Years experience developing reports, dashboards and insights using tools such as Power BI and Excel.
- A bachelor’s degree in finance, accounting, economics, business, data analytics or an equivalent discipline.
- Experience in financial analysis, performance reporting, decision support, business case development or a related discipline within a large or complex organisation.
- The ability to analyse financial and non-financial information and identify the information that matters most.
- Strong organisational, communication and stakeholder relationship skills.
- A positive and proactive approach, with a willingness to learn and continue developing your analytical and reporting capability.
- A high level of integrity, professionalism and commitment to accuracy.
- Experience in a capital-intensive, infrastructure, local government or similarly complex environment would be an advantage.
Additional Information:He aha te wariu o te utu kaimahi? | What’s the salary?
Circa $116,000 dependent on skills and experience.
Ngaa waahi whakarato painga kei a maatou: What we offer
We invest in our people, their wellbeing, and their future. That's why we offer a range of benefits designed to support you both inside and outside of work, including:
- We support flexible ways of working that balance individual wellbeing, team and business needs. And great outcomes for our community.
- We support professional development and opportunities to grow your career.
- Two wellbeing days each year to focus on what matters most to you (after one year of service).
- Fully funded Unimed health insurance, including hospital and surgical cover, with discounted rates for family members.
- Free annual health checks and flu vaccinations.
- The option to purchase additional annual leave for greater flexibility.
- Eye care support, including reimbursement towards eye testing and prescription glasses.
- Access to a wide range of local discounts, including gyms, cafes, healthcare providers, retail stores, and more.
Me Tono Inaaianei!: Apply Now!
- View the position description.
- Click apply
- Complete your application.
If you wish to include a cover letter with your application, please combine this in the same file as your resume and upload as a PDF file. Alternatively, you can use the 'Write a message to the Hiring Team' text box.
Applications close on the: 23/11/2026
Note: We will be shortlisting as we receive applications.
Council is committed to honouring the principles of Te Tiriti o Waitangi/Treaty of Waitangi through its relationship with Kiingitanga, Waikato Tainui, mana whenua and maataa waka within Hamilton Kirikiriroa.
All candidates will be notified of the outcome on their application via email. Short-listed candidates will be required to complete an interview process, reference checks and a criminal check. Further background checking will be required when relevant to the role. View more information about these checks, our commitment to the Privacy act and details for international applicants by clicking here
It is important to us that we support you throughout our selection process (interview and assessments). If you have any access needs during this process, let us know in advance so we can make sure these are met.
As a council, we believe in creating a welcoming environment where everyone feels valued and belongs. We value inclusiveness (Kotahitanga) – we respect and value the unique perspectives, experiences, and talents that everyone brings.
This role is being sourced directly. If/where Hamilton City Council requires the support of a recruitment agency, we will seek this support from our panel of selected agencies. Hamilton City Council will not be responsible for, and will not pay, any commissions, fees or other payments related to unsolicited contact.
Applying for this job
What to show on your CV
- The ad asks for 10 years of experience or more. Make your dates and job titles easy to check, most recent first.
- It asks for this qualification: Bachelor's degree. Name yours exactly as it's awarded, with the year you finished.
- It names Power BI, Microsoft Excel, Power Query, DAX and SQL. Use the same words on your CV for the ones you've used, so a search finds them.
Our guides to the New Zealand CV format, cover letters and interview questions cover the rest.