Senior Data & Automation Lead

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

Benefits offered by this job

Wellbeing leave

Fully subsidised health insurance

Flexible workplace

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 drive smarter decisions for the city. You will oversee governance, security and performance while shaping a scalable, future‑focused data strategy.

In collaboration with stakeholders, vendors and partners, you will mentor colleagues and guide projects from concept to deployment, delivering resilient, enterprise‑grade solutions

Qualifications

• Senior experience in data engineering and enterprise integration.
• Proven ability to lead complex, enterprise-scale data and automation projects.
• Advanced knowledge of SQL, data warehousing, ETL/ELT development, and data governance.

Responsibilities

• Design and maintain scalable enterprise data platforms using Azure and on-premises databases.
• Lead development of data integration and automation using ETL/ELT pipelines and Power Platform.
• Provide technical leadership, governance, and lifecycle practices across data quality, security and performance.
• Administer and optimise SQL Server, Azure SQL, MySQL.
• Establish monitoring, backup, disaster-recovery and incident handling.
• Lead complex projects, mentor staff, contribute to roadmaps and standards.
• Support privacy, cybersecurity and audit requirements.

Skills

Data engineering

Enterprise integration

SQL & data modeling

Leadership

Governance & security

Education

IT/cs/data engineering degree or equivalent

Tools

Microsoft SQL Server

Azure SQL

MySQL

ETL/ELT

Power Platform

Azure Data Factory

Azure Logic Apps

Azure Functions

Power BI

Power Apps

Power Automate

Data Lakes/Warehouses

Job description

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 drive smarter decisions for the city. You will oversee governance, security and performance while shaping a scalable, future‑focused data strategy.

In collaboration with stakeholders, vendors and partners, you will mentor colleagues and guide projects from concept to deployment, delivering resilient, enterprise‑grade solutions