Andrew Taylor Email & Phone Number

Sydney, NSW, AU

Hybrid, Brooklyn, New York, United States

• Coordinate semi and fully automated ETL processes for multiple prosecution offices and community based service providers.
• Lead analytics team on data analysis; including peer coding in R, Python and SQL, webscraper development, ETL processes on AWS, and quasi experimental program evaluation design.
• Review and produce internal and external evaluation reports, dashboards, presentations, and other ways of convening technical information to community, academic and government audiences.

New York, New York, United States

Coordinate quantitative research for the Mayor's Office of Criminal Justice in New York City, including maintaining existing ETL pipelines of program and live feed court data, and managing the case processing and alternatives to incarceration research projects.

Greater New York City Area

• Construct and analyze administrative datasets from criminal justice RDS systems in order to facilitate recommendations on reducing jail populations and transforming the role of prosecutors.
• Conduct descriptive and multiple regression analyses of outcomes in prosecution, jail, and other criminal justice datasets.
• Develop pdf scraping, web scraping, and optical character recognition scripts in R and Python to gather alternative data. Prepare interactive html and java script based data visualizations and dashboards for internal.

Greater Seattle Area

• Coordinated a national team conducting a systematic review on the effects of criminal justice (CJ) stigma on health.
• Assisted with the development of a model for future research on CJ stigma and health.
• Merged, analyzed, and supplemented CJ data sets on court statistics, judicial fines and fess revenue, and crime for every state in the U.S.

• Use a combination of in situ administrative data, census data, and open data source city data to assess, map, and analyze the effects of out of school resources in Denver Colorado.
• Work collaboratively using multiple approaches and platforms, including R, Python, Tableau, Git, and Leaflet.

• Coordinated data requests and subject matter experts relevant to assessing disparities in misdemeanor sentencing outcomes in Tacoma Municipal Court.
• Used R Studio with packages “diplyr”, and “tidyverse” to clean and analyze administrative court and police data sets with 3.1 million, 450,000, and 75,000 observations respectively.
• Used Tableau, and R Studio with “ggplot2” and “ggmap” to visualize regression results.

Greater Seattle Area

• Assisted with design, fieldwork, and analysis of 15 qualitative interviews of Community Health Workers in predominantly low-income neighborhoods throughout Washington.
• Gave a lecture summarizing the literature on intersection incarceration and health.
• Facilitated findings in English and Spanish at a regional conference.

Tumwater, Washington

• Lead the capacity assessment for the 8.7 million dollar Maternal Child Health grant.
• Coordinated epidemiologists and economists to provide benefit cost analysis of policy recommendations the legislature.
• Provided literature and policy reviews as needed by subject matter experts.
• Tracked and analyzed legislation during the 2014 legislative session.

Master Of Public Administration - Mpa, Public Policy Analysis, 3.8

Activities and Societies: Pi Alpha Alpha International Honors, Huskies for Opportunities in Prison Education

Bachelor'S Degree, Political Economy, 4.0