Data and analytics

Senior Data & Automation Analyst

Nelson City Council

NelsonToday
Full timeMid level

What the role involves

  • Designing data platforms
  • Leading integration automation
  • Administering enterprise databases

What they ask for

Senior data or automation experience; relevant tertiary degree or equivalent experience; advanced SQL, database and Azure expertise; experience delivering enterprise solutions, managing integrations, leading projects and mentoring technical staff

  • Bachelor's degree

About the job

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. Applications will be reviewed as they come in, so we encourage you to apply early as the role may close ahead of the advertised date.

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) - sarina.barron@ncc.govt.nz

Applying for this job

What to show on your CV

  • It asks for this qualification: Bachelor's degree. Name yours exactly as it's awarded, with the year you finished.
  • It names Microsoft Azure, Microsoft Fabric, Microsoft Power Platform, Microsoft SQL Server, Azure SQL services and MySQL. Use the same words on your CV for the ones you've used, so a search finds them.
  • For the work it describes, like "Designing data platforms", give an example from your own experience, with a result you can talk about at an interview.

Our guides to the New Zealand CV format, cover letters and interview questions cover the rest.

More jobs like this

CV examples for these jobs

Cover letter examples