JOB SUMMARY:
The Geospatial Analyst will manage and analyze geospatial data relating to barriers to aquatic connectivity to support project selection and implementation for fish passage remediation in British Columbia. The Geospatial Analyst will primarily be responsible for developing and executing fish passage barrier remediation prioritization models. They will also work with project partners to map barriers to fish passage and provide any geospatial technical support necessary throughout each phase of the projects.
JOB RESPONSIBILITIES:
Perform network analysis on a dendritic hydrological dataset.
Develop, update, and execute Python and SQL scripts to query data and run a barrier prioritization model.
Work with team members to develop ecologically-defensible model parameters based on the latest scientific knowledge.
Contribute technical expertise to fish passage improvement planning and prioritization exercises to identify priority barriers for removal/remediation.
Oversee the management, updating, and querying of existing provincial geospatial databases.
Oversee the design, population, and management of new relational databases as needed.
Produce professional maps of high cartographic quality to support decision making and project planning.
QUALIFICATIONS
Necessary
Requires minimum Master’s degree with relevant work experience in related fields (Biology, Environmental Science or Studies, Geography, Geographic Information Systems, Geomatics, Spatial Analysis).
Experience managing and analyzing large-scale spatial datasets.
Extensive experience performing spatial analyses with Geographic Information Systems (e.g., ArcGIS suite or similar software), including raster and vector datasets.
Extensive knowledge of relational database management systems (RDBMS), including writing and executing Structured Query Language (SQL) scripts.
Experience writing and executing code and scripts for data manipulation, spatial analysis, and geospatial model development in Python or other programming platforms.
Demonstrated expertise working with hydrological, biological, topographic, and land use spatial datasets.
Experience producing high-quality map products, for print and web.
Strong English written and oral communication skills.
Additional Assets
Conservation planning and freshwater ecology experience.
Experience with geospatial prioritization/optimization scripting and modelling.
Experience reviewing and synthesizing scientific literature.
Experience collecting, manipulating, analyzing, and interpreting scientific data and contributing to reports of findings.
Experience with Oracle and PostgreSQL DBMS.
Experience coding in R for data manipulation and statistical analysis.
Experience with designing compelling data visualizations and/or constructing interactive web maps.
Location: This position may be based in our Kanata, Ontario head office or in British Columbia
To apply:
Interested and qualified applicants are encouraged to submit their resume and a customized cover letter to careers@cwf-fcf.org by July 17, 2019.