Data Specialist

**_E ngā iwi, e ngā karangatanga huri noa i te motu, tēnei te mihi atu ki a koutou katoa. He īnoi tēnei ki a koe. Tono mai ki tētahi tūnga ki te Kaunihera o Ōtautahi_**

**About the team | Ko te rōpū nei**

At the Christchurch City Council, our love for our city inspires us as we constantly strive to make it an even better place to live, work, and play.

A role at the Council isn't just a job, it's an opportunity to make things happen in the city you're dedicated to. Join our team, and be inspired by the people you work with, the community you serve, and the results and successes we share in together.

Our Digital Unit focuses on the delivery of world class solutions that positively impact on the lives of everyone in Christchurch. We offer a fantastic opportunity for you to continue to develop your professional skills and will offer a large variety of business focused technology projects.

**About the role | Ko te mahi nei**

The purpose of this position is to support Council staff to comply with the Council's data and information management procedures, governance and relevant legislation. This requires providing technology solutions, advice and guidance for data management and governance practices across the organisation.

The Intermediate Data Specialist will provide support to the business units and teams within Council by improving, enhancing and automating data processes to meet the business' data requirements and increase data quality standards. You will also be responsible for:

- Creating and analysing views, triggers, and stored procedures using SQL programming language from data sourced from multiple corporate systems
- Identifying, understanding requirements and automating data processes using appropriate tooling, for example; Feature Manipulation Engine (FME), SQL and Robotics Process Automation (RPA)
- Designing relational databases and data models using SQL and PowerDesigner
- Supporting Council Information Stewards to troubleshoot and correct data problems by using Data Management tools.
- Interfacing with business and functional analysts to ensure the proper integration of business data processes and procedures to information technology
- Assisting in defining technical requirements for on-going systems maintenance and future functionality
- Providing technical support to users on matters related to data structure, data management, SQL scripts developed to perform data management functions.

**About you | Ko Koe Tēnei**
- SQL, FME (Feature Manipulation Engine), RPA (Robotic Process Automation), UiPath, Power Platform, GIS Tools (ESRI), Asset Management Systems (SAP), CASE Tools (PowerDesigner)
- Bachelor's level qualification in computer science, information science, or related field Example: Tertiary qualification at Certificate/ Diploma/ Degree level in relevant field or relevant experience to demonstrate an equivalent level of knowledge.
- At least two years in a digital corporate environment.
- Effective stakeholder engagement and relationship development.
- An all-in attitude. You're hands-on, proactive, and always looking to solve the next problem.

**What's in it for you? He aha ngā hua ki a koe?**

Want to be involved in shaping your City? Here at the Council we know our strength comes from our people, working together as one team to create results. When you join us, you're getting involved first hand, and contributing to crafting the Christchurch community. You will also benefit from:

- Access to training programmes, workshops, and development opportunities
- Flexible working arrangements - WFH, adjustable start and finish times, option to purchase extra leave.
- Collaboration - exposure to wider areas of the organisation
- Benefits - a variety of benefits for Council staff from health schemes to retail discounts.

**Additional Information | Ko ētahi atu kōrero**:

- _ Hours of work - Monday - Friday full time_
- _ Position - Permanent_
- _ Location_ - This position is primarily based at _Te Hononga, Christchurch City Council Civic Offices - 53 Hereford Street
- _ Closing Date - Wednesday 20th August_

**_ Applications will be reviewed as they are received, and interviews may take place prior to the close date. This means we reserve the right to close a job ad before the advertised close date._