Senior Business Analyst

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

Select how often (in days) to receive an alert: Create Alert

• Salary range $133,348 - $146,945pa (plus superannuation and entitlements)
• 2 x Ongoing Full-time roles based in Sydney CBD (hybrid work arrangements available)

About Legal Aid NSW

We stand beside people when they need it most.

At Legal Aid NSW, fairness isn’t just a legal principle, it shapes everything we do - our culture, our services, our workplace and our decisions.

Since 1979, Legal Aid NSW has provided legal advice, support and representation in criminal, family and civil law, helping people across NSW navigate hardship and complex legal issues. Our work is challenging, but deeply meaningful.

In partnerships with LawAccess NSW, Community Legal Centres and the Aboriginal Legal Service NSW/ACT, we are located throughout the state including our Central Sydney office, 25 regional offices, and satellite and outreach offices.

About the Role

As a Senior Business Analyst, you will transform and maintain raw data within the Business Intelligence environment to support operational reporting, analysis, and informed decision-making across Legal Aid NSW.

Working within the Business Reporting team, you will analyse and transform complex data into meaningful reports and interactive visualisations, providing valuable insights to stakeholders across the organisation. You will also undertake investigative analysis, prepare reports for executives, and work closely with internal and external stakeholders to interpret data, identify trends, and support evidence-based decision‑making.

About You

You are a curious and analytical data professional with a strong understanding of relational databases and experience transforming complex, raw data into accurate, well‑defined datasets, dashboards and reports. You can confidently interrogate large datasets, identify trends and insights, and translate technical information into clear, practical recommendations for a range of audiences.

With strong attention to detail and excellent communication skills, you are adept at partnering with both technical and non-technical stakeholders. You bring advanced capability in tools such as Power BI and Excel, experience working with SQL-based environments and modern data practices, and the ability to quickly learn new technologies and adapt to changing business needs. Qualifications in data analysis or a related discipline, or equivalent professional experience, will support your success in this role.

You Belong Here

Here, every role has purpose.

Whether you’re delivering frontline legal services or strengthening our organisation from behind the scenes, you’ll help create fairer outcomes for the people across NSW.

We’re building a workplace where every culture, identity, ability and voice are included and valued. We welcome Aboriginal and Torres Strait Islander peoples, people with visible and invisible disability, culturally diverse communities, and LGBTQI+ communities so you can connect and flourish at every stage of career.

You will be part of a diverse and inclusive organisation, working alongside like‑minded and values driven people dedicated to justice, community impact, and delivering exceptional support and service through cross collaboration.

Benefits of working at Legal Aid NSW

As an employee of Legal Aid NSW, you will have access to and enjoy a variety of support and benefits so you can thrive professionally and personally. You’ll love our:

Flexible Working - we are a Flex Ready certified and Carers and Employers accredited organisation. We are leading the way in offering a variety of flexible working options to uniquely support your unique work life balance.

Professional Growth – as the largest law firm in NSW we offer a variety of opportunities to enhance your career at every stage, through regional graduate programs, Practical Legal Training and work placements, mentoring, training, and secondment opportunities.

Work Health, Safety and Wellbeing – with dedicated programs, training, resources, and respectful work practices, our Wellbeing Framework ensures your physical, mental and psychosocial wellbeing matters, so you feel supported, safe and holistically well.

• Hold Australian or New Zealand citizenship or Australian Permanent Residency
• Undertake relevant pre-employment checks such as Criminal Record Check, and Conduct Service Check
• Possess tertiary qualifications with a data analysis or data manipulation component or relevant work experience.
• Sound understanding of relational database structures
• Demonstrated experience in interrogating large databases to extract reporting information, modelling raw data into clean, well defined data sets, and translating data into dashboards and reports.Advanced, demonstrated skills in the use of Power BI and Excel spreadsheets.
• Demonstrated knowledge of data base query tools, particularly the SQL Server Management Studio, GIT, DBT, and DAX.

We may use this recruitment to create a Talent Pool for similar ongoing or temporary vacancies we have over the next 18 months.

Closing Date: Sunday 27 September 2026 at 11.59pm

Legal Aid NSW is committed to a recruitment process that is inclusive and barrier free.

For accessibility support or recruitment adjustments, please contact Paige Gill, Recruitment Officer , [e-mail] or 02 9134 9347.

We look forward to receiving your application!