CapabilityOne (C1) is Defence’s portfolio management and decision support tool. It comprises an ecosystem of user interfaces, reporting and business intelligence tools that enable users to manage, view and interrogate data relating to programs, projects and domains and a range of other Defence capabilities. The Investment Portfolio Management Branch is responsible for maintenance, support and business intelligence capability for the solution. As part of a sustainment and enhancement program of work focussing on continuous improvement, business intelligence and reporting. As part of a program of work focussing business intelligence and data analysis, C1 requires Business Intelligence Analysts with experience in Microsoft Sql Server and Congnos Analytics. Deliverables: Under broad direction from the Data Management and Business Intelligence Lead, the successful candidate will work closely with stakeholders to understand information requirements for reports, dashboards and other visualisations and undertake analysis, design, development and maintenance of business intelligence artefacts (reports, dashboards and/or visualisations) to ensure business requirements are met. The successful candidate will be a part of multi-disciplinary team and will be responsible for the following deliverables and activities (but not limited to):
•Experience in design, development and support of the COGNOS Framework Manager models.
•Experience in design, development and support of COGNOS reports and dashboards.
•Experience in writing simple and complex SQL statements.
•Knowledge or experience for designing and developing power BI reports.
•Experience for gathering and analysing reporting requirements from stakeholders
•Develop and update technical documentation
•Following implementation standards and Industry best practices The successful candidate is expected to exhibit the following behaviours:
•Work collaboratively with Portfolio Performance Management team and other Investment Portfolio Management Branch members to delivery CapabilityOne outcomes;
•Develop and maintain professional, respectful and positive relationships with CapabilityOne users, product owners, and suppliers across Defence Groups;
•Contribute to a harmonious team environment that fosters innovation, creativity, and team collaboration to deliver project outcome;
•Provide mentorship and guidance to other team members, APS and third parties as required. Miscellaneous
•Other tasks as requested by Director Portfolio Performance Measurement in accordance with Defence outcomes.