Senior Technical Analyst
Australian citizenship required. No PR or work visa holders. Must have an active Baseline or higher security clearance.
Job Details
The Digital First program aims to uplift the National Archives' capability to manage, preserve and provide access to digital records. As part of this program, the Unified Data View will provide accurate and structured data for business intelligence, analytics, and search capabilities. The National Archives is seeking a Technical Business Analyst to support delivery of a Microsoft Fabric Data Warehouse and ensure clean, reliable and structured data for Power BI reporting.
Key Duties and Responsibilities
1. Design and document data models including ERDs, domains and table groupings
2. Analyse and document system logic, lineage and dependencies
3. Develop unified knowledge maps across source systems
4. Support design and operation of ETL/ELT pipelines
5. Prioritise datasets for reporting and analytics
6. Support backlog prioritisation, UAT and SQL validation
7. Maintain mapping documents, lineage diagrams and traceability
8. Deliver technical documentation including data dictionaries and architecture artefacts
9. Develop user stories and acceptance criteria for technical delivery
10. Collaborate with stakeholders across business and technical teams
11. Apply APS values and organisational standards
Technical Skills
12. SQL proficiency for validation and transformation testing
13. Understanding of ETL/ELT pipelines and data movement patterns
14. Knowledge of Azure cloud data platforms
15. Understanding of Power BI reporting and analytics requirements
16. Experience with Azure DevOps, Git repositories and Fabric pipelines
17. Knowledge of data governance, validation and compliance frameworks
Selection Criteria
The buyer has specified that each candidate must provide a one-page pitch to address all criteria specified. This is equal to 5000 characters.
Essential Criteria
18. Technical expertise: Demonstrates SQL proficiency such as writing queries to validate requirements, test transformations, and support developers. Has familiarity with ETL/ELT pipelines – understanding how data moves, common patterns, and constraints and knowledge of Azure cloud data platforms. Able to consolidate system knowledge into unified data maps and lineage documentation for engineers, architects and project leadership. Demonstrates an understanding of Power BI/reporting tools to ensure downstream reporting needs are captured and has relevant certifications in Microsoft Fabric, Azure, Data Engineering, or Business Intelligence.
19. Cloud & DevOps: Demonstrates experience using Azure DevOps for version control, task management, branching and merging. Utilising Git repositories, and Fabric deployment pipelines. Understanding of cloud architecture principles, performance optimisation, in Microsoft Azure environments.
20. Project delivery experience: Backlog prioritisation such as balancing business value with technical dependencies. Testing support such as writing test scenarios, validating data outputs, supporting UAT, and performing SQL based checks. Documentation discipline such as maintaining mapping documents, lineage diagrams, and requirements traceability.
21. Data governance & security: Knowledge of data quality frameworks, validation, cleansing, and governance processes. Awareness of security, privacy, and compliance requirements relevant to government data (e.g., Archives Act, Privacy Act).
22. Analytical & visualisation skills: Use of critical thinking, curiosity and analytical ability to capture business rules and design and develop interactive dashboards and reports in Power BI with strong data storytelling skills to support decision‐making. Experience creating data maps by extracting, analysing, and documenting view logic, to form a cohesive view of source systems and source‐to‐target mappings.
23. Collaboration and communication: Ability to work effectively with technical and non‐technical stakeholders and strong documentation and knowledge‐sharing practices.
Desirable Criteria
24. Quality assurance and deliverable management: Ensures that project and product quality reviews are conducted on schedule and according to procedure. Manages deliverables to be completed within agreed cost, time, and resource constraints, and ensures formal acceptance by stakeholders.
25. Security clearance: Preference is for the candidate to hold a Baseline Security Clearance due to the tight timeframe for project delivery, however will consider candidates that have the ability to obtain and maintain a Baseline Security Clearance.
26. Desirable skills and qualifications: Relevant certifications in Microsoft Fabric, Azure, Data Engineering, or Business Analytics. Familiarity with RecordSearch, Preservica, and Mediaflex is advantageous but not essential. Familiarity with metadata management and interoperability standards. Entry Certificate Business Analytics (ECBA), Certificate Capability Business Analytics (CCBA), or Certified Business Analysis Professional (CCBA) qualifications are highly desirable. Understanding of collection data within the Galleries, Libraries, Archives and Museums sector would be advantageous.
#J-18808-Ljbffr