Senior Data Warehouse & BI Analyst — 24/7 Analytics Leader

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

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.