Senior Data & Automation Analyst

Nelson City Council; Nelson; Hybrid; NZD 120,000 - 170,000; Full time

Benefits offered by this job

Wellbeing leave

Health insurance (fully subsidised)

Hybrid working arrangements

Generous leave provisions

Learning and professional development

Job summary

Nelson City Council is seeking a Senior Data and Automation Analyst to lead the design and delivery of modern data platforms, integrations and automation solutions that enable smarter decision-making for Whakatū Nelson. You will work at the intersection of strategy and technology to create secure, scalable and future-focused solutions with real community impact.

You’ll lead complex projects, mentor colleagues and contribute to technology roadmaps while ensuring data governance, privacy and

Qualifications

• Extensive experience in data engineering and analytics platforms.
• Experience delivering enterprise-scale data and automation solutions.
• ITIL Foundation or Microsoft certifications would be an advantage.

Responsibilities

• Design and maintain scalable enterprise data platforms using Azure, Fabric, databases, data warehouses and data lakes.
• Lead the development of data integration and automation solutions using ETL/ELT pipelines and Power Platform.
• Provide technical leadership and governance across data quality, security, performance and lifecycle practices.
• Administer and optimise enterprise databases, including SQL Server, Azure SQL and MySQL.
• Establish resilient monitoring, alerting, backup and disaster-recovery practices.
• Lead complex technical projects, mentor colleagues and contribute to roadmaps, standards and policies.
• Promote data governance, privacy and cybersecurity while supporting audit requirements.

Skills

Senior data engineering

Database administration

Enterprise integration

Analytics platforms

Education

Tertiary degree in IT or related

Tools

Microsoft SQL Server

Azure SQL services

MySQL

Power BI

Power Apps

Power Automate

Azure Data Factory

Azure Fabric

Job description

Help shape Nelson’s future. Lead with expertise. Make a difference. We’re looking for an experienced senior data and automation analyst to provide technical leadership and build secure, reliable enterprise solutions.

Shaping our future | Kōmiria te anamata

Shaping Our Future was built with the ideas and experience of our own people. Staff input shaped our Operating Model, and that model now guides our new structure: organised around our customers, clearer about who does what, and investing in the capability we need for the future. Part of that vision is a workplace where people feel they belong and have room to grow. If you’re looking to develop your career, use your skills in a new way, or help shape how we serve Whakatū Nelson, we encourage you to apply.

About the role | Kō tēnei tūranga mahi

Help shape how data and technology support better outcomes for our community. As our Senior Data and Automation Analyst, you'll lead the design and delivery of modern data platforms, integrations and automation solutions that drive smarter decision-making across Council. Working at the intersection of strategy and technology, you'll create secure, scalable and future-focused solutions that make a real impact for Whakatū Nelson.

You will:

• Design and maintain scalable enterprise data platforms using Microsoft Azure, Microsoft Fabric, enterprise databases, data warehouses and data lakes.
• Lead the development of data integration and automation solutions using ETL and ELT pipelines, integration technologies and Microsoft Power Platform.
• Provide technical leadership and governance across data quality, security, performance, architecture and solution lifecycle practices.
• Administer and optimise enterprise databases, including Microsoft SQL Server, Azure SQL services and MySQL.
• Establish resilient monitoring, alerting, error-handling, backup and disaster-recovery practices.
• Lead complex technical projects, mentor colleagues and contribute to technology roadmaps, standards, policies and procedures.
• Promote effective data governance, quality and stewardship while supporting privacy, information management, cybersecurity and audit requirements.

About you | Ko ngā pūmanawa ō

You’ll be an experienced data and automation professional with advanced technical expertise, sound judgement and a proven ability to lead complex enterprise solutions. You can work effectively across Council, collaborating with business stakeholders, vendors and external partners while keeping both strategic outcomes and technical detail in view.

You’ll bring:

• Senior experience in data engineering, database administration, enterprise integration, analytics platforms or related technical roles.
• A relevant tertiary degree in information technology, computer science, data engineering, information systems or a related discipline, or equivalent experience.
• Advanced knowledge of Microsoft SQL Server, Azure SQL services and MySQL, including administration, security, performance tuning, query optimisation, backup and recovery.
• Expert-level SQL skills and knowledge of data warehousing, data modelling, ETL and ELT development, data lakes, API integrations, metadata and data lineage.
• Advanced knowledge of Microsoft Azure Data Services, Microsoft Fabric, Azure Data Factory, Azure Logic Apps, Azure Functions, Power BI, Power Apps and Power Automate.
• Proven experience delivering enterprise-scale data and automation solutions and supporting cloud-based data platforms.
• Knowledge of data warehousing, data modelling, ETL and ELT development, data lake architectures, API integrations, data migration, master data management, metadata and lineage management.
• Experience managing complex integrations across multiple business applications.
• Demonstrated success leading technical projects and mentoring technical staff.
• ITIL Foundation, database administration or relevant Microsoft certifications would be an advantage.

What we offer | Ko ngā painga mōu

• Wellbeing leave, platforms and initiatives
• A fully subsidised health insurance scheme
• A flexible workplace including hybrid working arrangements to support work-life balance
• Generous leave provisions
• Learning and professional development opportunities
• Access to various employee benefits and discounts
• Opportunities to contribute to meaningful projects that shape our community's wellbeing and future
• Mountains, beaches and national parks at your doorstep

At Nelson City Council, we are committed to fostering a diverse, equitable, and inclusive workplace where everyone feels safe, valued, and has a true sense of belonging. We welcome applications from people of all backgrounds, including those from diverse ethnicities and cultures, LGBTQ+ communities, neurodivergent individuals, and people with disabilities. If you require any assistance with your application, please don’t hesitate to get in touch.

Applications close | Rā whakakapi

Midnight Wednesday 18 November 2026.

For a copy of the position description - visit the vacancy on our careers page here.

For further enquiries | Ina he pātai anō, whakapā mai

Please email enquires to Sarina Barron (Acting CIO) - [e-mail]