Program Design and Planning
What Student Data is Needed?
As a part of my role with Community Center for Education Results (CCER) and the Road Map Project, I worked with a small organization that wanted to improve their data reporting capabilities. They were using an annually-updated excel spreadsheet and wanted a more user-friendly and automated interface for their staff to enter data on clients more frequently. We worked over two sessions to identify the key elements of their program theory. It was crucial to understand how data collection might affect student-staff relationships and to design a system that would honor and even improve high quality student services.
Database Redesign Project
At Community Center for Education Results (CCER), I was fortunate to work with a fantastic team at Brainbox/Logic 20/20 and highly skilled analysts and database developer internally team to redesign the CCER database. The redesign allowed data to be stored more efficiently and to be more accessible to staff. In prior roles, I've worked to design databases for mental health client support and fundraising environments. I enjoy the technical challenges associated with designing data systems that fit with the needs of an organization and their clients. Sometimes the data system just needs to be a white board that marks staff in-office time.
King County Management Processes
While working at King County's Office of Performance, Strategy and Budget, I collaborated with the Lean Team as we built a system of management processes to help the King County Executive Leadership Team learn about the important work done throughout County government and provide the support and resources Departments needed to successful serve King County residents.
In addition, I worked directly with Department Directors and the Executive team to determine how to report project status in a useful way, making the process more simple for Directors and more informative for leadership.
Project Management in a Complex Environment
I worked on several cycles of annual reporting with the Road Map Project and enjoyed providing the project management for our team. We tracked hundreds of data points, images for a designer, and narrative writing by several key staff members while working in an environment of uncertainty around data delivery and data quality. Every year, using tools like Basecamp, JIRA, Microsoft Project and Excel, we not only kept track of progress, we also communicated clearly to our internal and external teams and ensured that our partners had what they needed to move forward. Managing a complex project requires both heart and task management skills in equal measure.
Reflect on Results
Data Analysis and Exploration
Analyzing data and sharing insights has been a cornerstone of my career. From looking at the impact of financial literacy training, to identifying strengths and challenges of Mental Health Court operations, to supporting improved strategies for serving students throughout South King County, I've been involved in the all stages of analysis and reflection, including technical data work and reporting results for diverse audiences. I've worked with large quantitative data sets and am equally comfortable analyzing results from focus groups and surveys.
When I look at a set of data and prepare results, I think about the key questions facing my audience, how I can use a structural lens to avoid racial or other stereotypes, and how to include the voice of clients and staff in searching for root causes.
Adjust Strategy or Approach
Better Serving Seattle Mental Health Court Clients
Working with colleagues from King County Mental Health, Seattle's Mental Health Court team, the Sound Mental Health nonprofit, and Seattle Municipal Court Leadership, we created a better solution for mentally ill defendants who were not competent to stand trial. I analyzed data regarding criminal case filings and service needs for defendants involved in mental competency hearings. We found that many were cycling in and out of jail, harming their healing processes and using valuable court resources. We developed a new program to provide housing and case management services that was successful in reducing recidivism and helping improve mental health and housing stability.
Data Team Focus Groups and Surveys
During the two years that I managed the Community Center for Education Results Data Team, we conducted a review of our services for colleagues. We used a focus group, surveys, and individual conversations to better understand whether we were providing the analytic products needed at the right times. We adjusted our practice to focus more on a streamlined approach for accepting requests while keeping a personal touch. We also set up some standard questions to ask when the team received data requests to ensure that the process flowed smoothly from start to finish.
Shared Measurement and Reporting
Road Map Project Student Success
I've worked extensively with school districts, state and local agencies, and an internal team to measure a large set of indicators of student success. Taken together, the indicators represent the state of education for our students in South King County. Due to widespread acceptance and use, they are helping to drive targeted improvements so that all our students have access to the amazing economy of this region. Our team worked diligently to move reporting on these indicators from paper-based reports to automated electronic data visualizations.
Measuring Progress for King County Residents
As a Performance Management Analyst for King County, I worked with a small team to update an annual performance reporting website, using metrics from the King County Strategic Plan. Gathering data from inside and outside County departments, we identified and reported on key community indicators and County performance measures. Staff across King County worked to provide useful context for the measurement system.