Democratic National Committee, Analytics Engineer
May 2024 - November 2024
- Led direct engineering support for all battleground states, supporting over 15 data directors and over 40 data engineers across the campaign.
- Created and orchestrated data pipelines in dbt and Airflow for identifying leads for prospective volunteers and canvassing opportunities.
- Maintained the campaign’s Google Cloud Functions to implement feature requests, improving reliability and consistency.
- Leveraged the Jira/Slack APIs to automate task delegation, facilitating the rapid onboarding of volunteers in the final stretch of the campaign.
- Scraped county websites to obtain real time, precinct-level vote counts to be ingested by our data pipelines during election night reporting.
PythondbtSQLAirflowGCPHexBashshellSuperblocksDNC PortalBigQueryETLdata pipelinesdata orchestrationweb scraping
LA Promise Fund, Data and Analytics Manager
March 2020 - May 2024
- Designed and implemented an efficient data pipeline for ingesting raw academic data from the Los Angeles Unified School District (LAUSD) spanning millions of records.
- Delivered mission-critical academic reports and other data products for the National School Improvement program, providing insight into student academic performance for several principals across the Slate-Z/South Los Angeles region.
- Successfully negotiated the renewal of the organization’s data memorandum with LAUSD by outlining a clear mission and delivery timetable of data products to stakeholders both in the school district and across our departments.
- Extended features in our Student Information Systems (PowerSchool) by writing custom plugins in SQL, NodeJS, and Python, automating data delivery to key vendors supporting our schools.
PythonSQLRsftpshellBashNodeJSGoogle Drive APIXMLdata cleaningETLSalesforceTableauPowerSchool
Alliance College-Ready Public Schools, Operations Analyst
Sep 2017 - Aug 2019
- Automated workflows and tooling to ingest data from all 30 schools in our network, increasing the efficiency of our state reporting cycle.
- Oversaw the improvement of our network's overall P&L by providing guidance to schools on adminstering a more effective breakfast and lunch program
- Conducted analyses in R and Python to perform data matching across different vendor files, increasing the networks' overall reimbursement rate from federal programs.
- Led trainings in both the home office and at school sites in the importance of a data-oriented strategy.
PythonRGoogle Drive APIData CleaningETLTableauPowerSchool