Introduction
The Associate Analytics Consultant at NSW Treasury builds Power BI dashboards and strategic procurement intelligence. Working within the Data & Analytics Division of the Procurement Reform and Banking Group, you will support teams across Treasury and other agencies. Requests include business improvements and reporting on Ministerial priorities, so the analysis needs to answer a clear question and reach the people who will use it.
Two mandatory questions shape how to apply for Associate Analytics Consultant. One asks for complex analysis you have undertaken, while the other examines how you handled a problem that changed as the work progressed. Your cover letter must include those answers and explain your alignment with the essential requirements in the role description.
The ongoing Clerk Grade 5/6 position is based in Sydney CBD, with flexible working options available. Check the ongoing-employment eligibility conditions before preparing the application. Applications close at 9:59am on 15 October 2026, so allow time to complete the pre-screening questions and upload the documents before that morning deadline.
View the official job ad and check the application instructions before you prepare your submission.
In this guide
Role snapshot
| Detail | Information |
|---|---|
| Role title | Associate Analytics Consultant |
| Organisation | NSW Treasury |
| Location | Sydney CBD; flexible working options available |
| Job reference | req53377 |
| Work type | Ongoing |
| Remuneration | Clerk Grade 5/6, $102,936 to $113,579 plus superannuation and leave loading |
| Closing date | 15 October 2026 at 9:59am |
Application requirements
Plan the written application around the documents and responses requested. Keep each response within its stated maximum so the recruitment team can assess your evidence against the instructions.
- Up-to-date resume detailing relevant knowledge, skills and experience
- Cover letter explaining your alignment with the essential requirements and answering the 2 mandatory questions
- Written pre-screening answers as part of the application
Submit the cover letter together with your CV as one submission through I Work for NSW. Follow the application form for file uploads and any limits; no cover-letter page limit is specified in the advertisement.
Use the NSW cover-letter template if a letter forms part of your application, adapting the structure to the instructions for this position.
Required written questions
| Question | How to plan your response |
|---|---|
| Provide an example of procurement, operational or other complex analysis you have undertaken. How did you approach the business question, and how did you present the outcome of your analysis? | State the business question, the data you used and how you analysed it. Explain checks on the result and how you presented the findings so the audience could make a decision. Procurement or operational work is useful, although the question also allows other complex analysis. |
| Describe a complex analytics problem where the initial request, data or stakeholder expectations changed as the work progressed. How did you test assumptions, adapt your approach, engage stakeholders and resolve competing needs? What outcome did you achieve, and what would you do differently next time? | Explain what changed during the work and the assumptions you retested. Describe how you handled competing stakeholder needs, altered the approach and assessed the result. Include the specific lesson you would apply next time. |
Eligibility and essential role requirements
- Australian or New Zealand citizenship, or Australian permanent residency, for ongoing employment
- Background checks and confirmation of tertiary academic qualifications before commencement
Treasury does not provide relocation expenses or employer-sponsored work visas unless the advertisement specifically states otherwise. Check your eligibility for ongoing employment before applying and review the essential requirements in the role description.
Candidate evidence
The evidence areas below draw on the work and experience requested for this position. Use them to choose relevant examples; check the role description for the official focus capabilities.
| Requirement or evidence area | How to demonstrate it |
|---|---|
| End-to-end Power BI delivery | Describe ETL processes, DAX formulas, dashboard design and user acceptance tests within a dashboard you built, implemented and maintained. |
| Automation tools | Explain how Power Automate, Power Apps or a similar tool improved an analytical workflow and how you checked the result. |
| Analytics delivery across a devolved organisation | Show how you worked with stakeholders whose responsibilities or data needs differed and agreed a useful approach. |
| Financial or procurement data | Use relevant datasets to explain a business decision, including how you understood definitions and checked the figures. |
| Initiative and continuous improvement | Describe an improvement you proposed, how you tested it and the effect on the team’s work. |
| Microsoft Office skills | Mention the applications used in relevant analysis or reporting and support the claim with work evidence. |
Application structure
The cover letter must explain your alignment with the essential requirements and include answers to both mandatory questions. A focused two-page letter is a practical recommendation unless the application form sets a different limit; no page maximum is specified in the advertisement. The outline below keeps each question recognisable while connecting it to the analytics work Treasury needs.
| Cover letter section | What to include |
|---|---|
| Opening paragraph | Name the position and briefly connect your dashboard or complex-analysis experience with Treasury’s work. |
| Relevant technical experience | Address the role-description essentials and refer to your Power BI or automation experience. |
| Eligibility | Confirm the applicable ongoing-employment eligibility condition accurately. |
| Closing paragraph | Refer to the attached resume and your interest in supporting useful procurement and financial analysis. |
Required responses within your cover letter
| Required question | What a strong response would include |
|---|---|
| Provide an example of procurement, operational or other complex analysis you have undertaken. How did you approach the business question, and how did you present the outcome of your analysis? | State the business question, the data you used and how you analysed it. Explain checks on the result and how you presented the findings so the audience could make a decision. Procurement or operational work is useful, although the question also allows other complex analysis. |
| Describe a complex analytics problem where the initial request, data or stakeholder expectations changed as the work progressed. How did you test assumptions, adapt your approach, engage stakeholders and resolve competing needs? What outcome did you achieve, and what would you do differently next time? | Explain what changed during the work and the assumptions you retested. Describe how you handled competing stakeholder needs, altered the approach and assessed the result. Include the specific lesson you would apply next time. |
What the panel will want to see in your examples
- A clear business question and sound data preparation
- How ETL, DAX and testing supported a reliable dashboard
- The assumptions you revisited when circumstances changed
- How competing stakeholder needs affected your choices
- The result and a practical lesson for subsequent work
Before you submit
Check the closing date, 15 October 2026 at 9:59am, in the official vacancy and complete the application before that cutoff. Read the form for any extra written questions or upload instructions before submitting. Check that your examples describe your own contribution and that the documents stay within the required limits.
Help with your application
Choose the examples for both mandatory questions first, then decide which technical detail each needs. You can use the cover-letter template to organise the submission and request help making the analysis understandable within the space available.
You can use the free cover-letter template or request help with your application. Return to the official vacancy to complete your submission.