Cassie Zhang
Data Analyst | Public Policy | Finance | Education | Marketing
- Role
- Research Assistant at Edunomics Lab At Georgetown University
- Location
- Washington, DC, US
- LinkedIn followers
- 500 followers
About Cassie Zhang
I am a data-driven professional with a strong foundation in business and marketing…
Experience
Research Assistant
Edunomics Lab At Georgetown University
May 2025 — Present
Cleaned and integrated NCES and ESSA datasets by transforming inconsistent ID formats, computing composite indicators (federal vs. state/local shares), and resolving unmatched records through anti-joins and identifier recovery logic• Created reproducible R pipelines for education finance standardization across schools; applied dplyr for data reshaping, NA-safe summarization, and multi-source merging (ESSA + NCES), with QA/QC scripts to flag anomalies and missing data• Built Tableau dashboards using Excel Query and Python pipelines to visualize per-pupil spending vs. student outcomes across schools, enabling filters by demographics and funding types to support equity reviews• Scraped NY state website and NY ESSA district-level PDF reports using Python (BeautifulSoup, Selenium), automating the collection of per-pupil federal, state/local expenditure, enrollment, and instructional spending data across 60+ school districts• Parsed and extracted financial metrics from unstructured PDF reports using PyPDF2 and re, transforming mixed-format multiline entries into clean, structured fields with pandas for downstream fiscal transparency analysis
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.