A Data-Driven Approach to Financial Oversight: Ensuring Financial Health & Stability for DC Public Charter Schools
Introduction
After three and a half years auditing federal clients at KPMG, I embraced a new challenge: overseeing the financial health of Washington, D.C.'s entire public charter school sector. In 2018, this meant managing a $990 million budget across 66 agencies operating over 120 schools and serving more than 40,000 students. While this was a significant departure from my previous audit work, I was determined to learn and make a positive impact.
During my nearly two years at the D.C. Public Charter School Board, I was immersed in a variety of projects that honed my skills in accounting, finance, strategic planning, and data analytics. The most ambitious initiative involved collaborating with the agency's "data team"—comprising data analysts, engineers, and scientists—to redesign the data warehouse for more frequent and insightful financial monitoring.
This initiative was driven by a previous school failure due to financial mismanagement, which had resulted in significant costs for the agency. My primary goal was to prevent a similar situation from happening again. As a former auditor, I conducted thorough investigations to understand the root causes of the failure. Working closely with my supervisor, we developed a multi-pronged solution to strengthen financial oversight:
Increased Frequency of Financial Reporting: We implemented new fiscal policies which mandated more frequent financial reporting from schools, shifting from annual reporting to monthly or quarterly submissions based on their risk levels. Although the interim results were not audited, this approach to financial reporting allowed for more frequent monitoring and earlier detection of potential issues.
Enhanced Transparency: We implemented a new quarterly reporting mechanisms to provide the board of Mayoral appointed officials with clearer and more timely insights into the financial health of the sector. On a quarterly basis, I met with the Financial oversight committee, comprised of myself, the Board’s Chair, Treasurer, the agency’s Executive Director, Chief Operating Officer, and the Financial Manager, and the Senior Manager of Finance & Academic Quality. In our meetings, we discussed general trends, specific school performance, and determined what actions we would take as an agency.
Data-Driven Analysis: We leveraged the redesigned data warehouse to conduct more in-depth analysis of schools’ financial trends, utilizing interim metrics to assess trends and identify potential potential risks requiring intervention.
