Senior Data Warehouse & BI Analytics Leader

Harrison McMillan Pty Ltd; Adelaide; On-site; AUD 106,000 - 112,000; Full time

Job summary

Harrison McMillan Pty Ltd seeks a Senior Data Warehouse and Business Intelligence Analyst for SAPOL’s IS&T Service in Adelaide. The role will design, develop and support data warehouse and BI solutions to enable 24/7 operations and robust reporting across the organisation.

You will lead reporting delivery, drive continuous improvement, and provide expert data insights to stakeholders. Some out-of-hours work and interstate travel may be required.

Qualifications

• Proven experience in database design, integration and administration with data warehouse environments.
• Experience designing data integration solutions using SSIS, BIML and cloud data pipelines.
• Strong proficiency in SQL for querying and transforming data.
• Experience in data modelling for analytics and reporting.
• Knowledge of ETL, data quality and reporting tools.
• Understanding of cloud-based analytics platforms such as Microsoft Fabric.

Responsibilities

• Lead the delivery and continuous improvement of reporting and analytics.
• Provide expert data insights to stakeholders with timely and accurate data.
• Support 24/7 business operations and assist in data governance.

Skills

Database design

SSIS

BIML

SQL

Data modelling

ETL

Cloud analytics

Microsoft Fabric

Tools

Microsoft Fabric

Job description

Harrison McMillan Pty Ltd seeks a Senior Data Warehouse and Business Intelligence Analyst for SAPOL’s IS&T Service in Adelaide. The role will design, develop and support data warehouse and BI solutions to enable 24/7 operations and robust reporting across the organisation.

You will lead reporting delivery, drive continuous improvement, and provide expert data insights to stakeholders. Some out-of-hours work and interstate travel may be required.