Data Specialist

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 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. Responsibilities / Requirements The 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 Skills To be successful in this position, you will have a minimum of 5 years' experience in a related role which includes experience working with the following (or similar) applications and skills: 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? 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 If this sounds like an interesting opportunity, you think you have what it takes and want to get involved in shaping our City then please apply today. Additional Information Ko ētahi atu kōrero: At the Christchurch City Council, we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with the job description, we encourage you to apply anyways. We understand that recruitment processes can be challenging. If you require any support or adjustments to help you put your best foot forward, please reach out to us at [email protected] 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 Salary - The salary band for this position goes from $88,003 to $97,781 per annum based on a 40-hour week. Starting salaries will be based on knowledge, skills and experience the successful candidate brings to the role, and relativities both, within the immediate team and in the broader organisation for the same or similar roles. To view the full position description, click here 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. #J-18808-Ljbffr