Job Description
Company Description
This position sits within our Strategy, Growth & Planning Group. The Group is responsible for guiding the sustainable development and growth of Hamilton to meet both current and future needs. This group focuses on strategic land-use planning, boundary alignment, and exploring various planning, funding, and financing models for growth-related projects. Their efforts ensure that Hamilton's physical development aligns with the city's long-term vision and objectives.
Job Description
He angituutanga: The opportunity
Use data to shape Hamilton’s future.
Build dashboards & insights for growth, planning and infrastructure funding. SQL + Power BI + Excel.
Hamilton City Council’s purpose is to improve the wellbeing of Hamiltonians and we’re looking for a Data Reporting Analyst to help turn complex information into meaningful insight that supports growth and long-term planning.
Reporting to the Programme Manager, Analytics, you’ll gather analytics requirements and deliver business intelligence and reporting that supports regulatory needs, urban/spatial planning, and infrastructure funding modelling.
Key responsibilities include:
Support the delivery of the organisation’s Analytics Strategy to achieve effective data analysis, insights, and reporting.
Develop and maintain region-wide operational and analytics reports, data cubes, data models, reporting systems, automation systems, dashboards, and performance metrics.
Adhere to technical and QA processes to address business issues.
Document any technical requirement, solution manual and process.
Assist the development and maintenance of the Councils growth and infrastructure funding models and associated policy development.
Design and delivery of reports and insights that analyse key regulatory, econometric, and planning functions.
Examine, interpret, and communicate results of analytical initiatives to internal and external stakeholders in operational, leadership and elected areas of the organisation.
Work with Digital Services to process analytics requests and develop Growth operational data store.
Manage third party data vendors, data subscriptions and enforce the data quality.
Support economic research and econometrics analysis for modelling purposes.
Support the research, analysis, and preparation of reports of economic trends and insights that can assist in driving economic growth in Hamilton City.
Qualifications
Oo puumanawa me oo wheako | Your skills and experience
Relevant tertiary-level qualification (Data Analytics, Computer Science, Statistics, or Information Systems qualifications preferred).
Minimum 2+ years relevant workforce experience.
A proven background and experience with HCC regulatory system Authority.
A background in Statistics, finance, public policy, urban planning or economics (preferred, but not essential).
Advanced Microsoft Excel skills, with demonstrated capability in complex formulae, pivot tables/charts, and Power Query.
Solid understanding of statistics and data reporting fundamentals.
Competency in SQL and data warehousing concepts, including ETL/ELT processes and Microsoft SQL Server Reporting Services (SSRS).
Strong understanding of relational databases, modern data warehouse architectures, and dimensional modelling.
Competency in data visualisation using Microsoft Power BI (or equivalent), with experience producing and publishing dashboards (e.g. Power BI, Shiny).
Understanding of modern data platforms such as Databricks, Snowflake, and Microsoft Fabric (preferred, but not essential).
Experience using R or Python (or equivalent analytical toolsets).
Experience with machine learning techniques.
Experience with statistical or economic modelling.
Additional Information
He aha te wariu o te utu kaimahi? | What’s the salary?
Circa from $90k - $100k dependent on skills and experience.
Ngaa waahi whakarato painga kei a maatou: What we offer
Flexible by choice; an award-winning flexible working policy.
Opportunities for professional development.
Two Wellbeing days per year.
Free health insurance through Unimed including hospital/surgery grade cover and discounted. membership rates for family members.
Free annual health checks and flu vaccination.
Ability to purchase additional annual leave.
Eye testing/glasses cost reimbursement.
Discounted purchases from local businesses; gym memberships, cafes, dentists, hairdressers and many 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: 29/05/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.
This position sits within our Strategy, Growth & Planning Group. The Group is responsible for guiding the sustainable development and growth of Hamilton to meet both current and future needs. This group focuses on strategic land-use planning, boundary alignment, and exploring various planning, funding, and financing models for growth-related projects. Their efforts ensure that Hamilton's physical development aligns with the city's long-term vision and objectives.
Job Description
He angituutanga: The opportunity
Use data to shape Hamilton’s future.
Build dashboards & insights for growth, planning and infrastructure funding. SQL + Power BI + Excel.
Hamilton City Council’s purpose is to improve the wellbeing of Hamiltonians and we’re looking for a Data Reporting Analyst to help turn complex information into meaningful insight that supports growth and long-term planning.
Reporting to the Programme Manager, Analytics, you’ll gather analytics requirements and deliver business intelligence and reporting that supports regulatory needs, urban/spatial planning, and infrastructure funding modelling.
Key responsibilities include:
Support the delivery of the organisation’s Analytics Strategy to achieve effective data analysis, insights, and reporting.
Develop and maintain region-wide operational and analytics reports, data cubes, data models, reporting systems, automation systems, dashboards, and performance metrics.
Adhere to technical and QA processes to address business issues.
Document any technical requirement, solution manual and process.
Assist the development and maintenance of the Councils growth and infrastructure funding models and associated policy development.
Design and delivery of reports and insights that analyse key regulatory, econometric, and planning functions.
Examine, interpret, and communicate results of analytical initiatives to internal and external stakeholders in operational, leadership and elected areas of the organisation.
Work with Digital Services to process analytics requests and develop Growth operational data store.
Manage third party data vendors, data subscriptions and enforce the data quality.
Support economic research and econometrics analysis for modelling purposes.
Support the research, analysis, and preparation of reports of economic trends and insights that can assist in driving economic growth in Hamilton City.
Qualifications
Oo puumanawa me oo wheako | Your skills and experience
Relevant tertiary-level qualification (Data Analytics, Computer Science, Statistics, or Information Systems qualifications preferred).
Minimum 2+ years relevant workforce experience.
A proven background and experience with HCC regulatory system Authority.
A background in Statistics, finance, public policy, urban planning or economics (preferred, but not essential).
Advanced Microsoft Excel skills, with demonstrated capability in complex formulae, pivot tables/charts, and Power Query.
Solid understanding of statistics and data reporting fundamentals.
Competency in SQL and data warehousing concepts, including ETL/ELT processes and Microsoft SQL Server Reporting Services (SSRS).
Strong understanding of relational databases, modern data warehouse architectures, and dimensional modelling.
Competency in data visualisation using Microsoft Power BI (or equivalent), with experience producing and publishing dashboards (e.g. Power BI, Shiny).
Understanding of modern data platforms such as Databricks, Snowflake, and Microsoft Fabric (preferred, but not essential).
Experience using R or Python (or equivalent analytical toolsets).
Experience with machine learning techniques.
Experience with statistical or economic modelling.
Additional Information
He aha te wariu o te utu kaimahi? | What’s the salary?
Circa from $90k - $100k dependent on skills and experience.
Ngaa waahi whakarato painga kei a maatou: What we offer
Flexible by choice; an award-winning flexible working policy.
Opportunities for professional development.
Two Wellbeing days per year.
Free health insurance through Unimed including hospital/surgery grade cover and discounted. membership rates for family members.
Free annual health checks and flu vaccination.
Ability to purchase additional annual leave.
Eye testing/glasses cost reimbursement.
Discounted purchases from local businesses; gym memberships, cafes, dentists, hairdressers and many 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: 29/05/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.
💡 Quick Summary
Seeking a career-building opportunity? The Data Reporting Analyst position is now open for candidates interested in the Warehouse / Logistics Jobs sector. This role in Hamilton offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Warehouse / Logistics Jobs is a plus.
