Junior Data Analyst

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.

He angituutanga: The opportunity

Reporting to the Analytics Programme Manager, as the Junior Data Analyst in the Commercial & Analytics Unit you will be responsible for supporting the execution and delivery of the analytics and modelling programme of work for the Strategy, Growth & Planning Group.

Your primary focus will be gathering analytics requirements, delivering on the group’s business intelligence requirements and assisting with infrastructure funding modelling.

• Support the delivery of the organisation’s Analytics Strategy to achieve effective data analysis, insights, and reporting.
• Develop and maintain dashboards, reporting systems, data models, data cubes, automation systems, and performance metrics.
• Design and delivery of reports and insights that analyse key regulatory, econometric, and planning functions. This includes developing written reports, interactive dashboards, and oral presentations.
• Adhere to technical and QA processes to address business issues.
• Assist the development and maintenance of the Councils infrastructure funding models and associated policy development.
• Develop and support regional growth monitoring tools to assist regional spatial planning and reporting requirements.
• Develop and implement R and/or Python script for data and statistics modelling purposes.
• Develop and maintain machine learning and AI models.
• Document any technical requirement, solution manual and process.
• Steward and improve key council datasets with a goal of becoming a subject matter expert

Oo puumanawa me oo wheako | Your skills and experience

• A proven track record of thinking differently, acting with integrity, working together, and making it happen.
• Professional, hardworking, willing to learn, innovative and motivated.
• The ability to work under pressure and meet deadlines.
• Relevant tertiary-level qualification (Statistics, Data Analytics, Computer Science, or Information Systems qualifications preferred).
• Relevant project participation experience (preferred).
• Strong communication and data storytelling capabilities, both in verbal and writing.
• Excellent teamwork skills with strong ability to work collaboratively with people from different professional background.
• A high level of initiative, inquisitiveness, and creativity that can be applied to the work programme.
• Confident presenting and explaining technical concepts to a range of audiences, including subject matter experts and non-technical stakeholders
• Articulate – speaks and writes clearly and confidently.
• Trustworthy with confidential information and can exercise appropriate discretion.
• Advanced Microsoft Excel skills. Can demonstrate capabilities with complex formulae, pivot charts, and PowerQuery (essential).
• Great understanding of statistics modelling and data reporting fundamentals (essential).
• Experience in SQL and database fundamentals (essential).
• Experience producing and publishing dashboards (eg.PowerBI/Shiny) (essential).
• Experience with R or Python toolsets (or equivalent) (essential).
• Experience with machine learning (preferred).
• A background in analytics, statistics, computer science, public policy, urban or environmental planning (preferred).

He aha te wariu o te utu kaimahi? | What’s the salary?

Circa from $72k to $90k 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: 17/03/2025

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.