Organization: Mason, Bruce & Girard, Inc.
Title: Geospatial Analyst/Database Developer
Location: VALLEJO, CA
Geospatial Analyst/Database Developer VALLEJO, CA
About the Position
The USFS has need for analytical support for a Spatial and Relational Database Management Geographic Information System analyst. This project is in support of the Washington Office Natural Resource Manager (NRM), National Applications, Fire and Aviation Management and GIS programs. Work on this project shall require current expertise and experience with advanced GIS technologies and enterprise relational database (RDBM) skills. This position is an on-site position with the US Forest Service, Regional Office in Vallejo, CA. Contractors primary work location will be at the R5 Regional Office in Vallejo, CA.
In this role you will perform the following tasks:
Use ESRI ArcGIS geodatabase, Oracle database design, Access database design and format output reports, tables, and displays assigned by numerous PMs. Examples include development and modification of regional and forest spatial and tabular queries, reports, and analysis products involving very complex and large datasets. This includes data in a broad range of subjects such as fire, roads, trails, wildlife, range, hydrography, hydrology, botany, aquatics, fisheries, heritage, geology, vegetation, and more.
Develop new SQL queries and/or scripts to retrieve tabular and spatial information from a large variety of complex National databases
Update existing SQL queries/workflows as needed
Cooperate with National Fire Center staff, developers and multiple government agencies to create, update and produce GIS products including non-fire related National Applications
Create, maintain, update, and organize user training materials
Work with staff to convert legacy workflows into automated scripts using SQL and/or Python including but not limited to NRM and Fire Applications
Maintain relationships with Forest and district personnel and other technical experts as necessary
Work with Regional Subject Matter Expert(s)[SME] and business area Program Managers (PM(s)), as well as end users to resolve problems
Attend and participate in meetings with assigned teams and PM(s) as technical SME
Participate in field trips to forests as needed
If required, create a knowledge transfer plan to coordinate ongoing work with government employees or other designated parties. This includes identifying and documenting:
o Project management processes
o Points of contact
o Location of technical and project management documentation
o Status of ongoing technical initiatives
o Key personnel
o Identify pending actions required of the Government
o Establish status meetings for effective communication with the appropriate Contractor/Government personnel for the period of transition
Additional project work may be assigned due to changing Regional priorities.
The excel at this position the candidate will have the following skills and experience.
Expertise with GIS analysis and technology including ESRI software, specifically ArcGIS 10.
Relational database management skills
Development experience with scripting languages including Python
Solid SQL query/workflow experience
Advanced knowledge of MS Access.
Experience automating workflows
Excellent communication skills
Attention to detail
Well established organizational skills
Ability to qualify for government credentials (background check, fingerprinting etc.)
In addition to the skills required by the contract, it is desirable that the proposed personnel also have the following skills:
Knowledge of corporate data source locations, database table structures and their appropriate use
Knowledge or ability to learn developing and refining SQL queries of spatial and tabular information
Knowledge or the ability to learn national databases, tables, and their appropriate use
Experience working in Citrix and ArcGIS 10x environment supporting a Land Management agency
Knowledge and experience working with Oracle and complete MS Office Suite software
Knowledge or the ability to implement Mobile GIS and Web GIS using Survey123, Collector, Explorer and/or Navigator, including ArcGIS Online and/or other web-based platforms
Bachelors degree in Forestry, Ecology, Wildlife Biology, Soils, Geology, Hydrology, Geography or Earth Science. Masters degree from an accredited college or university in GIS is highly desired.
Five years of intensive and progressive experience in a field requiring extensive use of GIS and related tools.
Fifteen years of intensive and progressive experience in a field requiring extensive use of GIS and related tools accompanied by a High School degree or equivalent.
Mason, Bruce & Girard, Inc. is a full-service natural resources consulting firm, with expertise in environmental services, forestry and geographic information systems (GIS). A set of core values guide our work, focusing our efforts on providing responsible, sustainable solutions that meet client needs.
Our areas of expertise include forestry, wildlife, fisheries, wetlands, water quality, and GIS. Our work is characterized by the highest level of client service, the application of the best science and technology, quality processes and results, integrity, and our respect for the natural environment. We provide natural resource consulting services to both industry and government and have done so since 1921.
Join Us/Apply Now
Click here http://www.masonbruce.com/careers/current-openings
or visit the Careers section of our website to send us your resume.
Mason, Bruce & Girard is an equal opportunity, affirmative action employer, and we do not discriminate against employees or job applicants on the basis of race, color, national origin, age, religion, gender, gender identity, disability, sexual orientation, veteran status, or any other status or consideration protected by local, state and federal laws, except where a bona fide occupational qualification applies. Equal opportunity applies to hiring, promotion, training, compensation, and any other organizational action. MB&Gs written Affirmative Action Plan is available to all employees and job applicants upon request.
MB&G is proud to be an equal opportunity employer.