SQL (High proficiency)
CTEs, window functions, REGEX, wrangling dates and timezones, data wrangling and cleaning, writing macros with Jinja
Python (Strong Intermediate)
Test-driven development, requests & APIs, data wrangling and cleaning, analysis, data visualization with seaborn, Parsons
Data Tools: Redshift, dbt, Civis Platform, Periscope, Netlify, Heroku, Google Cloud Platform
Progressive Tools: Mobilize America, Spoke, ThruTalk, Empower, Strive, Ballot Ready
Building ETL/ELT pipelines, setting up syncs between external systems and a data warehouse, cleaning messy datasets in both SQL and Python, working with organizers to track program goals, dashboarding, project and team management, CRM migration and set up, working with APIs
Research shows that it is 60x more effective at activating a new member if you welcome them within 15 minutes than within 24 hours. Currently, EveryAction's automation feature does not support this. I engineering a python script to text new contacts to our list within 15 minutes
Collaboration with Kyle Gracey & Data for Progress to pair existing green jobs research with Bureau of Labor Statistics data to better visualize jobs created by ambitious climate policy.
EveryAction does not include race and gender in their commercial Pipeline sync. Instead, I engineered a custom sync to bring in demographic data to our Redshift warehouse.
Selected Presentations and Podcasts
2021, New Mode Keynote Talk
2021, Analytics Engineering Podcast, dbt Labs
Working Families Party
Sunrise hired me as their first Data Director at the beginning of to lead and execute their data vision and strategy.
I built out Sunrise's data infrastructure for Sunrise School, our remote leadership training program, giving Sunrise staff data driven insight into their organizing for the first time ever.
I then went on to co-lead Sunrise's presidential and downballot targeting strategy and lead our electoral data work, which encompassed phones, texts, relational, and hand-written postcards. For the first time ever, Sunrise was able to accurately report the number of voters we reached across all our modes of organizing for our field work.
I brought the modern data tech stack to Sunrise, which primarily included building out Sunrise's dbt project. I incorporated software engineering best practices into our data program such as version control and testing to build robust, modular infrastructure.
I managed a team of 3-4 analysts and engineers, focusing on developing junior technical talent
Senior Policy Analyst
Data for Progress
I was the first person in the country to gain access to the raw AVR data from the Secretary of State offices, and produced a novel method of comparing state reported AVR opt-out rates.
I also worked on a short-term grant to research the jobs created by the Green New Deal and the demographics of the people who would have those jobs, focusing on race, gender, age, and geography.
New Era Colorado
Though I was hired on to the fundraising team, I quickly established myself as a tech-savvy, data-driven organizer. I would jump from attending a major donor meeting to analyzing our small-dollar donor data in R to optimize our monthly giving program to helping organizers with their Google Sheets.
Engineers for a Sustainable World
Engineers for a Sustainable World is a nonprofit network made up of people passionate about technical sustainability from all across the world. I lead a volunteer staff of 30 and oversee a network of over 1,750 young engineers at 45 collegiate and professional chapters.
At ESW, created two national programs. The first being Build Day, a national program to build more sustainable communities by empowering neighborhoods to gather and complete one-day builds. Since April 2018, we have reached over 500 people through our two Build Day pilot programs
I also developed the Resilient CommUnity Design Challenge that pairs student teams with local organizations to collaborate on solutions that build resilience to climate change.
In additional to my programmatic work, I handled the tech for the organization. I initiated the migration from CiviCRM to Nationbuilder, including setting up the design of the site with customized coding and establishing and maintaining the entire back end of database.
Bachelor of Science
Activities and Societies: Engineers for a Sustainable World, Society of Women Engineers, Social Justice & Equity Committee, K-12 STEM Education Outreach Volunteer, Volunteer at Interfaith Cot Homeless Shelter
Springboard Data Science Bootcamp
6-month intensive boot camp
Graduated from Springboard’s 6-month Data Science Career Track program and completed curriculum in Python for Data Science, Data Wrangling, Data Storytelling, Inferential Statistics, and Machine Learning. I specialized in Deep Learning and built a neural network to classify rooftops for satellite imagery to promote rooftop solar energy.