Aps 6 Data Analyst

Salary Range: $97,735 - $110,982 + Attractive Superannuation

DVA has an insatiable appetite for data and associated insights. From ad-hoc requests for specific information to inform reporting and policy development, to cutting edge modelling to predict future trends, volume, costs, and program efficacy - data is increasingly central to everything we do.

The purpose of the Data and Insights Branch is to evolve the way the department produces and uses data, analytics and research, to underpin evidence-based policy development, service delivery and wellbeing outcomes. The branch fosters a culture of curiosity in data and research, establishing processes that enable the department to better understand and serve the needs of veterans and their families.

The Data Engineering team is building an enterprise data warehouse, integrating data from multiple sources into curated data products that are used for a variety of purposes including standard business reporting, advanced analytics, simulation modelling and predictive analysis. Our primary purpose is to ensure that source system data is well understood, documented for business use, modelled into consistent formats and structures, and to build products that enable business teams to understand their business and to drive decision making. We also provide technical support for proof of concept projects, trialling new ways of working with data and technology especially in cloud infrastructure. We work closely with the Visualisation team and ICT teams to improve data within DVA. Our current focus for recruitment is across technical analysts roles, data engineers and data modellers.

**Duties**
- Evaluate and profile data sources and legacy data products, to identify the most suitable data to meet new requirements and determine ETL rules.
- Design and document ETL rules and mapping rules.
- Write and optimise SQL queries to retrieve data.
- Work with Data Modellers to design a model that will meet the needs of users, while maximising re-use.
- Plan, document and execute testing of data products, and ETL processes, and contribute to other quality assurance activities.
- Create practical and actionable plans to address complex data issues, and be able to explain these to users and other stakeholders.
- Work with the team to improve processes, determine standards and devise technical solutions for the ongoing development of the EDW and related tools.
- Work with Governance and Business to implement privacy and security controls.
- Work with Engineers, Analysts and Business to implement timelines for integrated EDW data tables.
- Communicate complex information or specialised content clearly, accurately and precisely for different stakeholders in person and in documentation.

**Eligibility**
- Under section 22(8) of the Public Service Act 1999, employees must be Australian citizens to be employed in the Australian Public Service (APS).
- All applicants external to DVA offered employment will be required to successfully undergo a pre-engagement screening check, even if they have a security clearance. The screening check is conducted in accordance with the Australian Government Protective Security Policy Framework requirements.

**Notes**

Where a non-ongoing position is offered, the role will be filled for an initial specified term of up to 23 months.

A merit pool of suitable applicants may be created which may be used to fill future ongoing and non-ongoing vacancies should they become available over the next 18 months.

DVA is committed to improving the data skills and capability of our workforce to underpin our goal of becoming a leading data-driven organisation.