Database Analyst (Intermediate)

Responsibilities

Provide analytical and programming support on forest inventory compilation and analysis projects.
Analyze, design, construct, test, and maintain specialized computer applications and database applications related to forestry and vegetation inventory.
Develop and maintain database loading, updating, extracting, and reporting utilities using languages such as Visual Basic .Net, C#, C++, Python, SQL, and/or Java.
Collaborate with a small team of GIS and Natural Resource professionals in application design, development, and maintenance of existing databases.
Participate in configuration control processes for proposed work/changes and document approved changes accordingly.
Conduct quality assurance/quality control and data preparation for inventory compilation.
Develop new queries and use existing queries to ensure data completeness and consistency checks.
Support specialists working with forest inventory data and provide analytical support for special projects or bioregional-level analyses.

The successful candidate must have demonstrated skills in scripting and tool development including the use of Visual Basic .Net, C#, C++, Python, SQL, and/or Java, for developing and maintaining database loading, updating, extracting, and reporting utilities.
If development exceeds the authority within Information Management, the candidate must be able to work collaboratively with the Chief Information Office to facilitate an understanding of the need, supporting any party the CIO assigns to complete the effort.
The candidate should have 5 years of intensive and progressive experience in a field requiring extensive use of GIS and related tools, along with knowledge of scripting languages such as R, R Studio, Python, and VBA.
Bachelor's degree in Computer Science, Mathematics, or related Science with a minor in database programming.
Demonstrated knowledge of relational databases, PostgreSQL, Oracle, and Microsoft Access.
Knowledge of scripting languages such as R, R Studio, Python, VBA, etc.
Working knowledge of GIS technology.
Coursework and work-related experience pertaining to natural resource management.
Analytical techniques for modeling and assessing dynamic ecological communities.