Asset Data & Analytics Engineer

Hornsby Shire Council; Hornsby; Hybrid; AUD 97,000 - 109,000; Full time

Benefits offered by this job

9-day fortnight

Hybrid work arrangements

Flexible working opportunities

Employee Health and Wellbeing Program

Professional Development Opportunities

Employee recognition scheme

Job summary

Hornsby Shire Council seeks a data-centric professional to consolidate data from multiple sources into a single TechOne Asset database and establish ongoing capture processes. You will collaborate with Finance, GIS and Business Improvement to ensure integration across systems and develop dashboards to support infrastructure planning.

You will optimise asset renewal, maintenance and service delivery through robust data analytics, Excel and SQL workflows, and excellent communication with

Qualifications

• Bachelor's degree in Data Analytics, Information Systems, engineering or related discipline.
• Demonstrated experience in managing and analysing large datasets and developing dashboards using tools such as Power BI or similar.
• Working knowledge of asset management systems (eg TechOne, Assetfuture, GIS) and data integration techniques.
• High level of proficiency with Excel and database querying tools.

Responsibilities

• Consolidate data from a range of sources into a Single TechOne Asset database.
• Identify gaps in asset data and set up processes for ongoing data capture.
• Manage data collection projects across Finance, GIS and Business Improvement teams.
• Develop Dashboards and Data Analytics tools to optimise asset renewal, maintenance and service delivery.

Skills

Data analysis

Dashboard development

Data quality

Communication of technical concepts

Education

Bachelor's degree in Data Analytics, Information Systems, Engineering or related discipline

Tools

Power BI

Excel

SQL / database querying

TechOne

AssetFuture

GIS

Job description

Hornsby Shire Council seeks a data-centric professional to consolidate data from multiple sources into a single TechOne Asset database and establish ongoing capture processes. You will collaborate with Finance, GIS and Business Improvement to ensure integration across systems and develop dashboards to support infrastructure planning.

You will optimise asset renewal, maintenance and service delivery through robust data analytics, Excel and SQL workflows, and excellent communication with