Sadie Gill

Data Scientist

  • Black Twitter Icon
  • Black LinkedIn Icon

Hi!  I am a data scientist with a background in physical geography and statistics. 

 

I love using data to help others be better stewards of our shared natural resources.

 
 

(2)

Education

2016

M.S. Statistics
California State University, East Bay

2014

B.S. Physical Geography
University of California, Santa Barbara

(1)

Recent Projects

Sacramento Valley Data Demonstration. Bechtel Foundation

This project capitalizes on data driven analytics and visualizations to improve water management decisions supporting winter-run Chinook Salmon in the Sacramento River. My primary role is in data acquisition and developing the front end design of the web dashboard using R, Shiny, HTML, and CSS. The design consolidates various data, delivering actionable insights to water and fisheries managers via an accessible web-based platform.

CVPIA Advanced Data Analytics and Visualization Tools to Support SDM 

U.S. Bureau of Reclamation and U.S. Fish and wildlife Service

For this project, I worked with a diverse set of stakeholders in the Central Valley Project Improvement Act (CVPIA) Structured Decision Making (SDM) process to systematically replace expert elicitation model inputs with empirical measurements. To facilitate this exchange and increase transparency regarding model inputs and mechanics, she is developing interactive web apps using open source tools. These apps helped to focus experts attention on the model logic representing biological processes and data sources of model inputs, empowering them with the context needed to make suggestions for new model improvements. Additionally, she conducts exploratory data analysis to support the translation of biologists' findings into proposals for model updates. She also collaborates with the lead model architects to convert SDM input data into R data packages, easing the model update process.

Voluntary Settlement Agreement for Delta Flows. California Natural Resources Agency

The California Natural Resources Agency is facilitating a voluntary settlement agreement for Delta flows. FlowWest is acting as neutral technical support for this effort. Working with an interdisciplinary team, including fish biologists and California water resource managers, Sadie adapted an existing winter-run Chinook salmon life cycle model to run comparative management scenarios for the settling parties. Sadie performed data wrangling of the settling parties’ data to prepare the data as model inputs. She also developed interactive data visualizations to display the model’s results.

Land Evaluation and Site Assessment (LESA) Model. Solano County

The FlowWest team developed a Land Evaluation and Site Assessment (LESA) Model for Solano County to enable a more comprehensive understanding of the agricultural significance within a portion of the County. The LESA framework aids land-use decision makers by rating lands based on land evaluation (LE) and site assessment (SA) rating factors. The factors and rating system were developed collaboratively with local stakeholders and technical experts who are familiar with the landscape and analysis objectives. Sadie worked to develop the model as a Python script ArcMap toolbox and will be shared with the County planning department to further identify, explore, and compare agriculturally significant lands in the region.
 

(3)

Work Experience

Data Scientist: FlowWest      

(January 2017-Current)

  • Created model for land cover classification with Google Earth Engine for the Klamath Tribes’ restoration opportunities analysis

  • Developed data management strategy for Central Valley Project Improvement Act’s Anadromous Fish Restoration Program, including creating several R data packages that provide inputs into a population model that helps in the prioritization of project funding based on biological outcomes

  • Created a model for rating the relative importance of agricultural land resources in Solano County based on soil quality, water availability, and surrounding protected resource lands

  • Developed Shiny apps to communicate results and increase program transparency to stakeholders

 

Data Analyst Intern: Udemy.com       

(June 2016-August 2016)

  • Conducted analysis in R on large and complex datasets to study user search behavior

  • Built SQL tables and wrote queries to extract relevant data to test hypotheses

  • Developed interactive dashboards to effectively communicate analytical results, enabling coworkers to monitor the performance of the marketplace and inform business decisions

  • Assisted team members with experimental design and analysis of experiment results using established statistical methodology

  • Improved data quality by finding and reporting bugs/issues with the data logging and infrastructure

Engineering Intern: City of Oakland Public Works       

(August 2014-March 2015)

  • Conducted data cleanup on the sanitary sewer system, which includes over 930 miles of pipes and over 31,000 structures using R, ArcGIS and Python

  • Worked with engineers to create a model that leverages existing data to identify sewer pipes in need of maintenance

  • Analysed 2,300 lane miles of streets to help find opportunity sites where projects overlapped to optimize the city’s limited resources

  • Created web mapping applications using ArcGIS Online and CartoDB, incorporating data from several different city programs to provide managers with tools for better collaboration and new insights

  • Generated maps, using ArcGIS and Illustrator, for planning future bicycle infrastructure

  • Maintained and updated the city's bikeways geodatabase

© 2018 Sadie Gill