About the job
Close Date: 19/9/21
Start Date: October
Security Clearance: NV1 minimum
Location: Canberra, ACT
2 positions available
On 19 April 2021, the Prime Minister announced his intent to establish a Royal Commission into Defence and Veteran Suicide. The Royal Commission will examine systemic issues and common themes in past deaths by suicide of Australian Defence Force (ADF) members and veterans.
The Minister for Veterans’ Affairs and Minister for Defence Personnel led a public consultation process on the Royal Commission’s Terms of Reference, which closed on 21 May 2021.
The Terms of Reference are expected to cover a range of themes including, but not limited to: the availability and quality of health and support services for veterans, families and colleagues affected by a Defence or veteran death by suicide; pre-service, during service and post-service issues for Defence members, veterans, and their families; and risk factors for current and former Defence members who have attempted or contemplated suicide.
Royal Commissions are the highest form of inquiry on matters of public importance and are independent of government. Royal Commissions generally have broad powers to investigate, gather evidence and summon witnesses to appear before it. It can hold public and private hearings and hear directly from individuals about their personal experiences to help inform its work, and to identify any systemic issues that need to be addressed.
The Royal Commission will not inquire into matters that have been dealt with by other inquiries, investigations or criminal or civil proceedings. Further, it will not be required to make findings of civil or criminal wrongdoing, or findings about individual Defence or veteran deaths by suicide.
- They provide technical guidance and assistance in the analysis and development of data requests and queries.
- Assist in the specification and undertake development of reports and information products including the development of solutions using a dimensional model methodology
- Analyse, design and build reporting and analysis products for the delivery of HR information from Defence’s PeopleSoft environment/s including the extraction of specialised/one off data requests
- Provide detailed technical advice and guidance to staff across the directorate around the interpretation and extract of data from Defence HR environments
- Work and contribute as a member of a multi-disciplined team applying agile work-practices/ techniques, including the provision of mentoring and skills transfer
- Detailed working knowledge of data structures and associated business/application concepts underlying complex HR transactional systems
- Demonstrated experience in writing SQL and the development of data extraction procedures
- Demonstrated ability to work collaboratively as a member of a mixed employment team consisting of contracted personnel, including the provision of mentoring and coaching
- Preferred working knowledge one or more analytics/query tools e.g. IBM Cognos, Tableau, PeopleSoft Query
- Preferred working knowledge of data engineering tools e.g. Microsoft SSIS, IBM Info Sphere, Tableau Prep