Data Warehouse developer

National Archives of Australia – Darwin NT As part of the Digital First program, the Unified Data View (UDV) will provide a complete, accurate, and up-to-date data for Business Intelligence, data analysis, and enhanced collection search capability. The Unified Data View aggregates, unifies, and presents collection metadata from multiple, disparate sources into a single, cohesive view to facilitate better decision-making, improve data accessibility, and enhance data analysis capabilities for users across the National Archives of Australia (National Archives). The underpinning technologies are based on Microsoft cloud technologies, including Microsoft Fabric OneLake data warehouse, Power BI business intelligence and Microsoft Azure Application Programming Interface Management (APIM). To sustain, maintain and further develop these new technologies, Technology Branch have a vacancy for an APS6 Data Warehouse Developer to manage ongoing operations of the Unified Data View. Under broad direction, the main duties of the role include: Support the development and sustainment of the unified data warehouse system and associated business intelligence products. Process, cleanse, and integrate large data sets from various sources, ensuring accuracy, completeness, and consistency of the data. Supporting the development and execution of test plans and test cases and perform data validation and data integrity testing. Manage existing and/or develop data warehouse processes and systems, ensuring ongoing reliability and alignment with business needs. Implement and maintain data models to structure and organise the National Archives' data effectively for analysis. Use technical skills in Microsoft Azure data solutions to implement and manage Extract, Transform and Load (ETL) pipelines. Cultivate and maintain expertise in business domain knowledge within the National Archives, with a strong understanding of collection management practices and government recordkeeping. Collaborate with business and technical teams to document existing business rules, processes, and procedures, mapping current data flows and defining collection reporting requirements Maintain, or ability to gain, skills in database fundamentals, Python and Power BI, Microsoft Azure SQL, Azure DevOps and MS Fabric. Relevant certifications or equivalent qualifications would be well regarded. Promote and apply the APS and National Archives values and contemporary people management principles and practices in equity and diversity, WHS and participative management practices. Apply the National Archives’ Vision, Mission and Commitments as expressed in Strategy 2025–2030: Evolving National Archives and Our Values Who we are National Archives provides leadership in the best practice management of the official record of the Commonwealth and ensures that Australian Government information of enduring significance is secured, preserved and available to government agencies, researchers and the community. Our vision: National Archives is committed to being a world-leading archive and strives to strengthen Australia's cultural identity and democracy by connecting people with the evidence of Australian Government activities and decisions. We operate in a complex, challenging and changing environment requiring professional and robust risk management. We support a positive risk culture where risks are discussed regularly and either accepted or actively managed to prevent or reduce their impact. The National Archives recognises that the factors that generate risks can also create opportunities, particularly in our rapidly changing digital environment. National Archives is committed to: Inclusion As we are also committed to developing the capability and expertise of our staff, we offer a Studies Assistance Program that supports staff to achieve individual goals as well as increasing their capacity to help achieve the Archives’ strategic objectives. We have a Health and Wellbeing program to encourage and support a healthier workplace and healthy lifestyle changes for employees. Are you eligible? To be eligible for the role you must be an Australian citizen. If you are selected, you will be required to successfully undergo a pre-employment check and be able to obtain and maintain a security clearance at a Baseline clearance level. How to apply You need to apply through our e-recruitment system. Your application will need to include: the names and contact details of at least two referees, one of whom should be a current supervisor statement (1000 words maximum) describing how your skills, knowledge, and experience/qualifications would enable you to perform the duties of the role taking into account the “Performance Expectations” at the relevant classification and the National Archives’ Vision, Mission and Commitments as expressed in Strategy 2025–2030: Evolving National Archives and Our Values. #J-18808-Ljbffr