Home | Jobs | Search

Position Detail

Organization: Mason, Bruce & Girard, Inc.
Title: Geospatial Analyst/Database Developer
Location: VALLEJO, CA
Application Deadline:
Posted: 2018-05-25

Position Description:

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. Contractor’s 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.

About You

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


Education Requirement:
Bachelor’s degree in Forestry, Ecology, Wildlife Biology, Soils, Geology, Hydrology, Geography or Earth Science. Master’s degree from an accredited college or university in GIS is highly desired.

Experience Requirement:
Five years of intensive and progressive experience in a field requiring extensive use of GIS and related tools.


Alternate Requirements:
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.

About Us

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&G’s written Affirmative Action Plan is available to all employees and job applicants upon request.

MB&G is proud to be an equal opportunity employer.