o Build and maintain data models using dbt and SQL to provide downstream users curated datasets to conduct their analyses

o Support sales and finance teams with ad hoc requests to fill short term gaps in our reporting infrastructure

o Perform regular code reviews and refactoring to ensure our data models are both accurate and performant

o Analyze large sets of data using R and Python to identify opportunities to improve the efficiency, integrity, and stakeholder experience of Universal Service program participants

o Communicate findings and metrics via well-maintained Tableau and R-Shiny tools

o Develop curated datasets in our Tableau environment using custom SQL for various stakeholders around the company

o Taught courses on data science tailored to public policy students, using R and Python to explore topics such as data wrangling, version control, reproducible examples, machine learning, and text analysis

o Guided students in collecting real-world datasets, designing models, and conducting analyses to determine and articulate policy proposals

o Oversaw the development of machine learning models to evaluate and propose solutions for topics such as improving the efficiency of the New York City public transit system

o Collected and analyzed publication and citation data on major political science departments to evaluate the university’s academic performance relative to other institutions

o Built a multi-decade data warehouse and evaluated the university’s Ph.D. retention rate as well as the success rate of individual faculty members

o Collaborated with faculty on the collection and analysis of datasets to support research, data visualization, academic writing, and statistical modeling using R, STATA, and ArcGIS

o Managed the data collection process — including overseeing 3 undergraduate researchers — for a precinct-level primary election project, gathering data from 14 states, organizing them in a data warehouse for associated scholars to use in their research

o Designed course materials, planned lessons, provided constructive feedback to students, and led sections in a range of courses, such as American Government and Politics, Introduction to GIS for Social Science Research, and Advanced Statistical Methods for Social Science

o Developed a remote lab process to increase access and efficiency for students and faculty using ArcGIS

o Created dummy and real datasets to demonstrate complex models and mapping processes in R, STATA, and ArcGIS