o Design and build dimensional models and data marts using dbt and Snowflake, creating reusable data products that serve as the single source of truth for product analytics across Customer Success, Sales, and Product teams

o Architect modular data transformations with comprehensive testing frameworks and documentation, implementing data quality checks that ensure reliability for self-service analytics

o Partner with business stakeholders to translate analytical requirements into scalable data solutions, delivering ad hoc analyses and reports that drive revenue growth and customer retention strategies

o Lead code reviews and mentor team members on dbt best practices, SQL optimization, and analytics engineering patterns

o Led the design and implementation of the analytics layer for the organization’s data warehouse using dbt, establishing best practices for testing, documentation, and modular data transformations

o Built reusable data products and analytical datasets using SQL, Python, and R that identified operational inefficiencies and improved data integrity across all four Universal Service Fund program areas

o Developed and maintained predictive analytics pipelines with comprehensive monitoring, translating complex findings into actionable insights through Tableau and R Shiny dashboards

o Mentored junior analytics team members on dbt best practices, SQL optimization, and dimensional modeling through code reviews and technical guidance o Designed star schema data marts that enabled business stakeholders to self-serve their analytics needs while maintaining data governance

o Designed and taught graduate-level courses on data science for public policy students, covering SQL, Python, R, data warehousing, version control, machine learning, and text analysis

o Mentored 60+ students through code reviews and office hours on analytics best practices, reproducible workflows, and technical communication

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

o Oversaw development of machine learning projects evaluating solutions for public sector challenges, including NYC transit system optimization

o Built data pipelines using Python, Airflow, and PostgreSQL to enable ongoing analysis of publication and citation data, evaluating the university’s academic performance relative to peer institutions

o Designed and maintained a multi-decade data warehouse supporting strategic decision-making on PhD retention rates, faculty performance, and program outcomes

o Managed data collection for a multi-state precinct-level election research project, supervising 3 undergraduate researchers and organizing data for use by academic collaborators

o Collaborated with faculty on dataset collection, analysis, and visualization supporting research publications using R, STATA, and ArcGIS

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