Senior Data Warehouse and Business Intelligence Analyst

South Australia Police; Adelaide; On-site; AUD 106,000 - 112,000; Full time

Job summary

South Australia Police is seeking a Senior Data Warehouse and Business Intelligence Analyst to design, develop and support data warehouse and BI solutions enabling 24/7 operations. You will deliver timely, accurate data insights for stakeholders across the organisation.

The role focuses on data integration, warehousing principles, ETL processes and analytics platforms, with potential travel and out-of-hours work as required.

Qualifications

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

Responsibilities

• Lead design, development and support of data warehouse and BI solutions to enable 24/7 business operations.
• Provide expert advice to ensure timely, accurate and fit-for-purpose data insights for stakeholders.

Skills

SQL

Data modelling

ETL

Data warehousing

Tools

SSIS

Biml

Cloud data pipelines

Job description

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.

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

Enquiries Neetu Singh [email protected]

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.