Skills
Analysis Tools — Excel, Google Sheets, Looker
Database Systems - BigQuery, Databricks, Presto, AirTable, Google Tables, Google Sheets, SQLite, EPM
Programming Languages - Google Apps Script, Python, SQL, HTML, CSS
Experience
Condé Nast
Director, Innovation & Solutions (Apr. 2021 - Present)
- Automated business reporting through Dashboards, Documents, Decks, Slack, & Email
- Built a workflow to process P&L data to cutdown on manual input for standard month-end reporting
- Created an ecosystem to analyze, set & visualize KPIs
- Engineered a system to measure ROI on YouTube video inventory
Sr. Manager, Video Research & Analytics (July 2019 - Apr. 2021)
- Analyzed the performance of video inventory across all programming platforms
- Built data visualizations to help programming leads track performance
- Created standard reports to contextualize the health of the business
- Developed tools to plan quarterly content programming against budget & projected targets
Vox Media
Analyst (July 2017 - July 2019)
- Developed standard reports for audio & video programming
- Built dashboards to quantify monthly performance
- Composed monthly reports to contextualize the state of the business
Operations Manager (March 2015 - July 2017)
- Packaged video inventory for distribution to O&O and partner platforms
- Optimized content for growth via discovery & recommendation
- Managed metadata taxonomy via video content management system organization
Projects
Global KPI Initiative | Databricks, Python, Google Drive (Nov. 2023 - Present)
- Unified system for setting targets for Condé Nast’s brands across all key platforms
EPM Data Extractor | EPM, Python, Google Drive (Aug. 2023 - Sept. 2024)
- Hybrid workflow that minimized manual data extraction for P&L data
Video Inventory ROI | Databricks, Python, Google Drive (Aug. 2022 - Feb. 2024)
- Engineered composite data segments that evaluated investment against returns
Programming Plan Scratchpad | Google Drive (July. 2019 - June 2024)
- Tool that projected performance against budget and targets