Location Thames (working from area offices, as necessary) Reports to Solution Delivery Manager
Group Corporate Services
Direct Reports Nil
Financial Authority Nil Functional Relationships Internal
Team Staff
External
Vendors
Our Council
As one of the largest employers on the Coromandel Peninsula, we are proud to be
Thames-Coromandel District Council.
We will provide high quality, affordable services and facilities with excellent customer service.
We will maintain innovative leadership and empower our communities. We will strive to make
the Coromandel Peninsula a desirable place to live, work and visit.
To achieve our vision we aim to attract, employ and support people to be their best while being
guided by our core values of respect, integrity, innovation and teamwork.
How you fit
The Business Intelligence and Data Engineer is responsible for the design, development,
implementation, management and support of mission critical BI reporting and Extract,
Transform, Load (ETL) processes and environment. The position also acts as the owner of the
Data Models across all applications and will manage any Data-marts that will be required by the
business for Operational Dashboards.
The role sits within the Solution Delivery team, working alongside a team of specialists in
business intelligence, data management and analytics.
January 2021 Page 2 of 5
Your responsibilities
Accountable for
Successful when
Business Intelligence
Identifies and recommends new ways to improve efficiency bystreamlining business processes.
Creates models that depict trends in Council data and works with departmental managers to outline and then prioritise the specific data needs for each business unit.
Acts as a consultant for others who utilize the data contained in the information systems.
Provides analytical guidance and understanding on how to use data to provide business insight.
Creates custom solutions, with the ability to customize databases and software to meet business reporting requirements
Automates or increases efficiency of existing reporting Business analysis undertaken to gather required BI system requirements
Translates business requirements into specifications that will be used to drive data store/ data warehouse/ data mart design and
configuration
Uses ETL tools to load data store(s)/ data warehouse(s)/ data mart(s). Provides technical assistance and cross training to other team
members
Designs and implements technology best practices, guidelines and repeatable processes
Integration
Supports in-house integrations where data is provided from or to ourvendors
Creates new integrations for movement of data within TCDC and to external parties.
Data Management
Evaluates existing databases and systems ensuring they are runningcorrectly
Analyzes data details and accuracy ensuring that the data being used is viable and accurate
Oversees data mapping processes
Ensures proper configuration management and change controls are implemented
Supports internal customers to ensure timely and accurate delivery of data.
Provides support as required to ensure the availability and performance of database and BI environments for TCDC
Relationship
Management
Customers, stakeholders and staff are supported with professional, accurate and timely advice and guidance, as required.
External relationships are professionally managed with clear communication on expectations
Key stakeholders are well informed and consulted, with input and influence from Council in decision making.
Organisational Support Team Meetings are regularly attended ensuring knowledge and skills are shared, and other staff are supported.
Procedures, information systems and policies are documented and complied with.
Appropriate and agreed continuous professional development is undertaken.
Civil Defence and Emergency Management training and activities are participated in.
Other duties are completed, as requested by the manager, to support the business unit.
Health, Safety &
Wellbeing
Take all reasonably practicable steps to ensure your own safety, and to ensure that you do not cause harm to any other person by your actions or inaction.
Cooperate with any reasonable workplace health and safety policy or procedure.
Comply with any reasonable instructions given
Demonstrate a personal commitment to Health and Safety in accordance with TCDC’s Health and Safety Policy.
Te Tiriti o Waitangi
Demonstrate commitment to developing an understanding of Te TiritiJanuary 2021 Page 4 of 5
About you
Honesty, Enthusiasm, Accountability, Respect and Teamwork are considered core competencies for all staff.
A successful Business Intelligence and Data Engineer will need the following to succeed:
Education / Training
A degree in computer science, information technology, or softwareengineering is desirable
Experience
5+ years' experience implementing reporting systems, working withusers in a requirements analysis role.
Extensive use of SQL and RDBMS systems (DB2, Oracle, SQL Server, etc.)
Extensive experience with data warehouse implementations High level of working knowledge using SSIS, SSRS, and SSAS Demonstrated business acumen in utilising business intelligence to inform and drive business effectiveness, value and growth. Experience in working with API’s.
Experience in working with a range of corporate technologies. Current, Full Drivers Licence.
Demonstrated experience of embedding a continuous improvement culture in business processes.
Knowledge, skills and
attributes
Strong knowledge of logical and physical data modelling conceptsUnderstanding of Data Standards (National and Regional) including Information Management/Records Management Strategies and Policies.
Ability to understand project management methodologies. Ability to contribute to strategic discussion, able to drive and influence decisions confidently with highly developed interpersonal and communication skills.
Solution focused, understands the need for key relationships, acts with honesty, transparency and empathy for people and
communities.
Innovative mind set, is an improvement focused team player that shows initiative and inspires commitment to achieve Council outcomes.
Strong decision making and problem-solving skills, can confidently analyse and apply key information with good judgement and takes accountability.
I certify that I have read this position description and reasonably believe that I understand the requirements of the position. I understand that:
a) This position description may be amended by the employer following reasonable notice to me b) I may be asked to perform other duties as reasonably required by the employer in accordance
with the conditions of the position.
...
...
Employee Date
... ...
