Summary
Australian Government procurement and grants reporting relied on information drawn from multiple systems, making consistent reporting, data management and analysis increasingly challenging.
Working in partnership with the Department of Finance, Citadel Edge designed, delivered and operates the Information Delivery Platform (IDP), a shared analytics and reporting capability that brings together procurement and grants data into a single platform. Built on AWS using Matillion ETL, Snowflake and Tableau, IDP provides a secure and scalable environment for reporting and analysis.
The platform has reduced reliance on manual reporting processes, improved access to procurement and grants information, strengthened data governance and established a foundation for future expansion as additional data sources and reporting requirements are introduced.
The challenge
The Department of Finance required a modern reporting capability to move beyond fragmented datasets and manual report preparation. Key challenges included:
- Limited visibility across procurement and grants data held in multiple systems
- High levels of manual effort to prepare and validate reports
- Difficulty governing and validating large volumes of transactional data
- The need for a secure environment capable of supporting growing data volumes and additional data sources
- Providing timely reporting and analysis for government stakeholders
The solution
Citadel Edge designed and delivered IDP as a central analytics and reporting platform that consolidates procurement and grants data into a single governed environment.
Key activities included:
- Integrating data from procurement, grants and related government data sources
- Implementing automated data ingestion, transformation and reporting processes using Matillion ETL and Snowflake
- Delivering secure AWS-hosted platform services aligned with government assurance requirements
- Providing self-service analytics and reporting capabilities
- Implementing data governance and data lineage capabilities to improve confidence in reporting
- Delivering an IRAP-assessed environment and supporting the onboarding of additional data sources over time
Implementation
Citadel Edge partnered with the Department of Finance to design, deliver and operate the platform, working closely with stakeholders to understand reporting, governance and assurance requirements
The team provides:
- Ongoing platform operations and support
- Delivery of new reporting and analytical capabilities
- Secure cloud-hosted platform management
- Data governance, validation and quality assurance services
- Integration of additional datasets and reporting requirements as business needs evolve
Outcomes and impact
Key outcomes included:
- Improved confidence in procurement and grants reporting through governed and traceable data
- Faster access to reporting and analysis
- Reduced manual effort associated with report preparation
- Self-service analytics capabilities for business users
- Secure operation within an IRAP-assessed environment
- A scalable platform capable of supporting future reporting and integration requirements
Looking ahead
IDP continues to evolve through the onboarding of additional data sources and reporting capabilities. Citadel Edge continues to support the platform’s operation and enhancement, helping ensure the Department of Finance maintains a secure and scalable reporting capability that can adapt to future business, reporting and policy requirements.
