Senior Data & BI Analyst — Power BI, SQL (Hybrid Sydney)

NSW Department of Communities and Justice; Sydney; Hybrid; AUD 133,000 - 147,000; Full time

Benefits offered by this job

Flexible Working

Professional Growth

Work Health, Safety and Wellbeing

Job summary

Legal Aid NSW is seeking a Senior Business Analyst to transform and maintain raw data within the Business Intelligence environment, delivering operational reporting and insightful analyses. You will create reports and interactive dashboards, support executives with data-driven decisions, and collaborate with stakeholders to identify trends across NSW services.

You will leverage Power BI and Excel to model data, work with SQL-based environments, and communicate complex findings in clear,

Qualifications

• Tertiary qualification with a data analysis or data manipulation component, or equivalent work experience.
• Strong understanding of relational database structures.
• Experience interrogating large databases to extract reporting information and transform data into dashboards.
• Advanced Power BI and Excel skills; familiarity with SQL-based environments.
• Ability to translate technical information into practical recommendations for diverse audiences.

Responsibilities

• Transform and maintain raw data within the Business Intelligence environment to support operational reporting and decision-making.
• Analyse and transform complex data into meaningful reports and interactive visualisations.
• Undertake investigative analysis and prepare reports for executives.
• Collaborate with internal and external stakeholders to interpret data, identify trends and support evidence-based decisions.

Skills

Data analysis

Interrogating large databases

Dashboards & reporting

Stakeholder communication

Education

Data analysis qualification

Tools

Power BI

Excel

SQL Server Management Studio

GIT

DBT

DAX

Job description

Legal Aid NSW is seeking a Senior Business Analyst to transform and maintain raw data within the Business Intelligence environment, delivering operational reporting and insightful analyses. You will create reports and interactive dashboards, support executives with data-driven decisions, and collaborate with stakeholders to identify trends across NSW services.

You will leverage Power BI and Excel to model data, work with SQL-based environments, and communicate complex findings in clear,