Data Analyst

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. We are particularly interested in candidates with skills in Amazon Web Services and Microsoft cloud environments, with a focus on Azure Data Factory and Microsoft Purview Data Governance and Compliance tools, as well as Python coding experience. An understanding of third normal form and star schemas modelling techniques, Atlassian Cloud (Jira and Confluence) and Gitlab would also be of value. We are seeking an experienced Data Analyst to assist in the development of our Enterprise Data Warehouse (EDW). The ideal candidate for the Data Analyst role will possess a strong analytical mindset and extensive experience in examining and profiling source system data to understand its nature and structure. They will be adept at developing data engineering specifications to integrate data into the enterprise data warehouse, ensuring alignment with existing patterns. This individual will collaborate effectively with data engineers to comprehend current data transformation processes and work closely with data modelers to understand and enhance existing data models. A proactive approach to problem-solving is essential for success in this role. The key duties of the position include: 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. The successful candidate will be required obtain and maintain a Baseline Vetting (AGSVA) security clearance. Notes This recruitment process is being used to fill ongoing and/or non-ongoing position/s. For more information about the role, please see the Candidate Information Pack. 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. Successful applicants engaged into the APS will be subject to a probation period. DVA embraces and fosters a culture that supports diversity, inclusion and respect, where people are empowered to fulfil their potential. We welcome people with diverse skills, experiences, perspectives and backgrounds. We are dedicated and committed to attracting and recruiting Aboriginal and Torres Strait Islander peoples and encourage applications from people with disability, people that identify as LGBTQIA and people from culturally and linguistically diverse backgrounds. Take on a rewarding, varied, and broad career with an Australian Public Service Department that can bring balance and flexibility to your working life, while supporting you to stay connected to your community. DVA is committed to improving the data skills and capability of our workforce to underpin our goal of becoming a leading data-driven organisation. Getting to know the Department of Veterans' Affairs The Department of Veterans’ Affairs (DVA) exists to fulfil the nation’s duty to support our serving and ex-serving Australian Defence Force members and their families. We do this through programs of care, compensation, commemoration, income and Defence support services. Our aim is to enhance self-sufficiency, quality of life, financial wellbeing and community recognition for those we support. DVA is both a policy and service delivery agency. We have strong relationships with Australian ex-service organisations, Federal and State Government agencies and the veteran community. DVA’s vision is to honour veterans, and empower them and their families to continue life after service, within a society that understands and values their military service and their ongoing contribution to the community.

Location: Perth CBD, AU

Posted Date: 2/1/2025