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

Wellbeing & Safety

Job summary

Legal Aid NSW is seeking a Senior Business Analyst to transform and maintain data within the Business Intelligence environment, enabling operational reporting and informed decision-making across the organisation.

You will join the Business Reporting team, turning complex data into meaningful dashboards and reports, and collaborate with stakeholders to interpret data, identify trends and support evidence-based decisions.

Qualifications

• Tertiary qualifications with a data analysis or data manipulation component or relevant work experience.
• Demonstrated experience interrogating large databases to extract reporting information.
• Advanced skills in Power BI and Excel for dashboards and reports.
• Strong knowledge of relational databases and data transformation into clean data sets.
• Ability to communicate technical information clearly to both technical and non-technical stakeholders.

Responsibilities

• Transform and maintain raw data within the BI environment to support operational reporting and decision-making.
• Analyse and transform data into meaningful reports and interactive visualisations for stakeholders.
• Prepare executive-ready reports and collaborate with internal and external stakeholders to interpret data and identify trends.

Skills

Power BI

Excel

SQL

Data analysis

Data visualization

Education

Data analysis degree

Tools

SQL Server Management Studio

Git

DBT

DAX

Job description

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

• 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

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.

Essential Requirements

• 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 database query tools, particularly the SQL Server Management Studio, GIT, DBT, and DAX.

Download the Role Description to explore the role in-depth.

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

We’re here to help

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.

For information on Recruitment and Workplace Adjustments, visit Adjustments for individual needs | I Work for NSW.

For more information about the recruitment process and working at Legal Aid NSW view our Candidate Information Pack.

For role specific enquiries, contact Alfred Swe, A/Manager Business Reporting, [e-mail] or 02 9219 5032.

For recruitment enquiries, contact the Talent Acquisition Team on 02 9134 9347 or via [e-mail].

Aboriginal candidates are encouraged to connect with the Legal Aid NSW Aboriginal Services Branch for a yarn.

For guidance on preparing for interviews, explore the NSW Public Sector’s interactive Capability Application Tool.

Connect with us on LinkedIn, Facebook and Instagram.