Data Warehouse developer

Job Overview National Archives of Australia – Sydney CBD NSW 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. Responsibilities 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. Support 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. Collaborate with business and technical teams to document existing business rules, processes and procedures, map current data flows and define collection reporting requirements. Maintain, or be able to gain, skills in database fundamentals, Python, Power BI, Microsoft Azure SQL, Azure DevOps and MS Fabric. Relevant certifications or equivalent qualifications would be well regarded. Qualifications & Experience 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 Eligibility 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. Application Process 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. A statement (1000 words maximum) describing how your skills, knowledge and experience 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. Be careful – Don’t provide your bank or credit card details when applying for jobs. Don’t transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad. #J-18808-Ljbffr