Data Analyst (PowerBI)
Russell Offices, ACT (no remote option)
The Directorate of Portfolio Performance Measurement (DPPM) requires analysis to be undertaken to develop visualisations that represent status of capability delivery; portfolio performance and a report highlighting insights on capability delivery based through the analysis of capability delivery data. The report will advise how existing capability delivery data can help Defence understand if projects and programs are on track to deliver the right capability effect, and support reprioritization of the IIP when our strategic circumstances change.
DPPM is seeking the following deliverables:
1. Multiple Visualisations – using PowerBI or other available business intelligence tools, create dashboards displaying capability delivery portfolio health including displaying approval status of projects. This will include leveraging existing Defence data platforms to enable complex analysis and predictive modelling on capability delivery data.
o First set of visualisations to be provided within 20 business days of contract commencement.
2. Report: - This report will:
o detail how capability delivery data from multiple sources with Defence can be used to assess health status of the IIP and continually track projects and projects;
o explain how the multiple visualisations developed and how these can support capability analysts in undertaking portfolio analysis;
o describe measurement and reporting of key IIP statistics;
o detail the analysis of capability delivery data to provide comprehensive insights on trends and observations that describe the health of the portfolio through multiple lenses.
3. Progress Reports: Weekly progress reports on work done as part of this work-package delivered to the Contract Manager or/and their nominated representative.
4. Repeatable and Scalable: The work delivered must be scalable to address the future requirements.
5. Data considerations: using existing data landscape to :
o Detail the degree of data completeness;
o Identify and remediate any gaps to consolidate and standardise information management.