Following an agile methodology, we articulated requirements of the architecture design through developing user and non-user stories. We then completed data profiling on the source tables to become familiar with the data itself and designed a flexible architecture to meet the immediate needs of the agency while also accommodating any future modifications associated with their overall modernization effort. 

We sought to consolidate the multiple systems being used and establish one source of truth for the agency’s reporting and as such, created a centralized data repository. We established a data vault architecture to replace the existing traditional reporting repository structure and in doing so, provided a more flexible and extensible system with improved ease of maintenance. The data vault was designed in a way that allows for easy modification to data as needs change over time. BI reporting capabilities through SQL became more efficient, as establishing one central repository for the data streamlined the overall reporting process. Users gained the ability to generate reports autonomously and without the need to request information from their support team.  

The engagement improves operational efficiency and reduces costs through eliminating previously manual reporting processes. The enhanced reporting also provides increased transparency within the organization and enables better decision making with improved outcomes. Creating a view of the new source systems within the centralized repository improves the quality and overall integrity of the data itself, and the new architecture provides extensibility for the agency.