Program And Management Analyst
CurrentSummary: conduct statistical analysis, develop reporting tools and pipelines, and manage project timelines aimed to improve agency outcomes.Design web apps, reports, data infrastructure, and automations • Developed over a dozen recurring reports and dashboards for the agency, including tools to identify operational pain points by linking qualitative feedback with KPIs. • Built and maintain two web apps on QuickBase to formalize data collection, tracking, and notifications of previously manual processes. • Wrangle administrative data from structured and semi-structured sources using languages like Python and SQL. • Design automated notifications for supervisors creating tailored, actionable content, such as nudges to complete family visits or reminders for upcoming documentation deadlines.Employ econometrics and AI/ML methods • Conducted program evaluation using econometric techniques, including propensity score matching, to estimate the effectiveness of In-Home case management, which found the service significantly reduces the likelihood of family separation. • Designed an OLS fixed-effects model to determine how caseloads would change if the agency internally detailed social workers into an understaffed branch. • Implemented natural language processing models to summarize and categorize unstructured text data, including a model to identify barriers to fatherhood engagement by mining agency contact notes.Collaborate, strategize, present, and train. • Run weekly check-in meetings with In-Home Administration leadership to answer research questions, scope out and implement new processes, and automate routine tasks. • Recommend and support process and policy changes across the agency and levels of leadership. • Present analysis and findings during agency-wide meetings in a straightforward, digestible manner. • Train agency colleagues, including both peers and leadership, on tools including Python, QuickBase, and Excel.
