City of San Antonio · Government · San Antonio, TX · 16 weeks
Municipal data quality program established across 12 departments
The City of San Antonio faced data quality issues across 12 departments that threatened $4.1 million in federal grant funding. We developed and implemented a targeted data quality program that fixed the errors and set up continuous monitoring to safeguard their funding moving forward.
Challenge
A federal audit found serious data quality issues in grant reports from 12 city departments. The problems included inconsistent beneficiary counts, missing outcome metrics, and duplicate service records. The city faced a 90-day deadline to fix these errors or lose $4.1 million in federal funding.
Outcome
We helped all 12 departments pass the federal re-audit, securing $4.1M in grant funding. We built a data quality monitoring platform that continuously checks compliance with federal reporting rules and sends automated alerts if any department’s data drops below the required standards.
Results
- $4.1M Federal grant funding preserved
- 12 Departments remediated
- 90 days Remediation completed on time
- 0 Deficiencies in re-audit
We had just 90 days to fix problems across 12 departments or we’d lose $4.1 million in federal funding. Thinklytics helped us zero in on the biggest risks first, and we passed the re-audit without any problems.