Senior Data Warehouse and Business Intelligence Analyst

Harrison McMillan Pty Ltd; Adelaide; In loco; AUD 106.000 - 112.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Database design

SSIS

BIML

SQL

Data modelling

ETL

Cloud analytics

Microsoft Fabric

Strumenti

Microsoft Fabric

Descrizione del lavoro

ASO6 Senior Data Warehouse and Business Intelligence Analyst

Full-time vacancy up to 31/07/2028.

The Information Systems and Technology (IS&T) Service supports the frontline policing and corporate operations of SAPOL through the provision of ICT infrastructure and communication platforms, operational software applications, and support services. The Service is responsible for driving the ongoing evolution of ICT capability across SAPOL, through the delivery of high-quality ICT change programs. The Service is structured across four core pillars: Strategy, Innovation and Engagement; Program Delivery; Operational Services; and Security and Assurance. The Service extends from traditional ICT services to encompass a specialist radio and technology capability, including laser and radar calibration services.

The Application Services Branch provides proactive support to ensure the availability and quality of applications used throughout SAPOL. The Branch manages and maintains SAPOL data and enables its transformation into useful information for business purposes. Application Services staff work closely with application and data business owners and users to optimise the use and functionality of applications and reporting to meet business outcomes. The Branch manages software throughout its life and also contributes to projects by providing expertise and advice and works collaboratively with project managers to ensure projects successfully transition to a supported life cycle model.

Role Overview

The Senior Data Warehouse and Business Intelligence Analyst delivers high-level expertise in the design, development and support of data warehouse and business intelligence solutions to enable 24/7 business operations. The role leads the delivery and continuous improvement of reporting and analytics and provides expert advice to ensure timely, accurate and fit-for-purpose data insights for stakeholders.

Desired Experience

• Proven experience in database design, integration and administration with data warehouse environments.
• Proven experience designing, developing and implementing of data integration solutions using tools such as SSIS, Business Intelligence Markup Language (Biml) and cloud data pipelines.
• Strong proficiency in SQL for querying, transforming and managing complex data sources.
• Experience in data modelling for analytics and reporting, including understanding of data structures optimised for business intelligence tools.
• Sound knowledge of data warehousing principles, ETL, data quality, and reporting tools.
• Understanding of contemporary data and analytics platforms, including cloud-based or integrated analytics environments such as Microsoft Fabric or equivalent.

Special Conditions

• The incumbent must hold a current Australian work eligibility status and will be subject to a criminal history check.
• The incumbent may be assigned to other duties at this remuneration level or equivalent.
• Some out of hours work and intra/interstate travel may be required.
• The incumbent is required to participate in SAPOL’s iEngage program.

ASO6 - $105,747 - $111,854 per annum.

Enquiries

Neetu Singh

[e-mail]

South Australia Police is dedicated to strengthening trust and collaboration with First Nations communities in South Australia as we shape a culturally responsive and inclusive workplace for First Nations employees.

Our vision is to create safer communities by strengthening the bonds of mutual respect, understanding, and partnerships between police and First Nations peoples. By deepening our appreciation and understanding of First Nations cultures and acknowledging the past, we are committed to focusing on the present and moving forward together into the future.

To strengthen our workforce, South Australia Police encourage applications from First Nations peoples.

South Australia Police is an equal opportunity employer committed to providing a working environment that embraces and values diversity and inclusion.

People with disability are strongly encouraged to apply. The South Australian public sector supports flexible ways of working including part-time working arrangements wherever reasonably possible. The sector is diverse and desires to increase in diversity and to create opportunities for more South Australians.

We are committed to making reasonable adjustments to provide a positive, barrier-free recruitment process and supportive workplace. If you have any support or access requirements, we encourage you to advise us at the time of application.