DATA WAREHOUSE

Designed and led the team to develop the agency’s first ever enterprise data warehouse. Negotiated agreements with software vendors to gain access to necessary data utilizing a combination of daily SQL backups, API tools and files and implemented them using automation. The repository consists of data needed for reporting to internal stakeholders as well as external funders using SQL Server Reporting Studio, SQL Server Integration Studio jobs as well as Tableau dashboards.