Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Legal Aid NSW is seeking a Senior Business Analyst in Sydney CBD with hybrid work options. The role focuses on transforming raw data into trusted datasets, dashboards, and actionable advice for operational and executive decision-making.
It requires investigating data quality, understanding databases and reporting changes, and communicating implications to non-technical colleagues. The position involves working with relational databases, SQL-based environments, Power BI and Excel, supporting
The Senior Business Analyst at Legal Aid NSW works in Business Reporting, turning raw data into reliable datasets, dashboards and advice for operational and executive decisions. This is a data-heavy role for someone who can investigate quality issues, understand database and reporting changes, and explain the implications to colleagues outside the technical team.
There are two ongoing full-time roles in Sydney CBD, with hybrid work arrangements available. The work spans relational databases, SQL-based environments, Power BI, Excel and modern data practices. A useful application shows how your technical analysis led to a trustworthy reporting result or a better decision.
Role
Role Senior Business Analyst
Organisation
Organisation Legal Aid NSW
Location
Location Sydney CBD, with hybrid arrangements available
Employment
Employment Two ongoing full-time roles
Salary $133,348 to $146,945 per annum, plus superannuation and entitlements
Legal Aid NSW asks you to label both targeted answers inside your cover letter. Treat the page limits as hard editing constraints and make each answer understandable without relying on the resume for context.
Australian or New Zealand citizenship or Australian permanent residence is required. Relevant pre-employment checks include a Criminal Record Check and Conduct Service Check. Tertiary qualifications with a data-analysis or manipulation component, or relevant professional experience, are also specified. Keep these conditions separate from the written evidence in your two answers.
The role’s candidate profile points to data accuracy, analytical depth and communication. Choose examples that show the technical steps you took and how the resulting information became useful to a decision-maker.
Evidence area
How to demonstrate it
Data quality and modelling Explain how you interrogated raw data, traced a defect to its cause and produced a clean, well-defined dataset or control.
Reporting and visualisation Show the reporting need, the SQL or modelling work behind a dashboard, and how Power BI or Excel helped stakeholders understand the result.
Communication and adaptation Describe how you explained a technical issue or changed requirement to a non-technical colleague, agreed the response and adjusted the solution without losing accuracy.
The cover letter must answer both targeted questions, so give each one a clearly labelled section and a complete example. Its maximum length is two pages, alongside a resume of no more than five pages. The table below shows how to divide that limited space.
What to include
Opening Briefly connect your reporting and data-analysis experience to Legal Aid NSW’s decision-support work.
Target Question 1 Use a data-quality issue with a traceable root cause, the correction you made and the prevention you put in place.
Target Question 2 Use a change with an unintended consequence; explain the impact, your response and the lesson you applied afterwards.
Closing Connect the two examples to reliable reporting and clear advice for stakeholders.
Use the following wording to check that your examples answer every part of each question.
What a strong response would include
Tell us about a time you inherited or discovered a data quality issue in a reporting solution. How did you identify the root cause, and what did you do to prevent it from recurring? Show your investigative method, the evidence that confirmed the cause, the immediate correction and the enduring control or process change.
Can you describe a situation where a change to a database, ETL or ELT process, or reporting solution had unintended consequences? What happened? And what lessons did you take from it? Explain the change, the unexpected effect on data or users, how you detected and managed it, and a specific lesson that altered later practice.
Check the five-page resume limit, the two-page cover-letter limit and both question labels. Make sure your answers explain what you did yourself, and that any claim about SQL, Power BI, Excel, GIT, DBT or DAX is supported by real work. Return to the official vacancy before submitting by 11:59 pm on 27 September.