This position serves as CPW’s operational professional for statewide activities on research, wildlife health, species conservation and terrestrial data analysis and summarization. Responsibility as an operational professional includes consulting and working with the Research, Policy and Planning Branch (RPP), Species Conservation Section (SCON), and periodically with the Terrestrial Section on creating/maintaining/automating software databases for future access and analyses to enhance wildlife management in Colorado; compiling, combining, organizing, storing, analyzing, and reporting wildlife research and management datasets for terrestrial wildlife (mammal and avian) species; designing analytical tools necessary to analyze and evaluate wildlife management and research programs; contracts and overseeing vendor performance of data delivery for major programs; procedures to integrate and manage data in agency systems; monitoring functionality of data systems and correcting associated problems; and maintain backup procedures to ensure recovery of information in the event of a system failure.
Consults with the RPP and SCON program leaders on the maintenance, monitoring and modification of database software, such as SQL server database on an Enterprise level system.
Designs an overall database strategy, including systems, processes, guidelines, rules, and standards that are common across all research projects and associated databases to ensure organized and efficient data management across RPP and SCON.
Advises the RPP and SCON program leaders with design and guidance on data systems, processes and standards for managing the collection and use of research and management information.
Coordinates with Office of Information and Technology (OIT) and manage permissions for numerous temporary hires and contractors who will periodically require access to the system.
Maintains system backup procedures to ensure recovery of information in the event of a system failure.
Interfaces with existing agency data storage network and servers.
Builds and maintains custom SQL Server databases, stored procedures, and code for each research project, tailored to the specific needs and objectives of each, while maintaining standards or organization and structure across projects to optimize efficiency.
Executes complex queries in order to provide data summaries, reports, and input files for further analysis to personnel in RPP and SCON; may include creation of complex code in VBA, SQL, and/or other languages (e.g., R, Python, C++ or similar) in order to carry out repetitive data summarization needs in an efficient and repeatable manner.
Evaluates the design and approach for each segment of the database system for each project which routinely employ GPS technology, remote camera technology, genetic technology or some combination of the three which generate data sets with millions of data points for a given project.
Coordinates with the Office of Information Technology and reports new database additions to the Server, changes to permissions, and to periodically double-check back-up systems.
Develops innovative solutions to store, manage, and retrieve new, changing, and atypical data streams (e.g. millions of photos collected from game cameras or GPS locations from deployed radio collars).
Keeps up with evolving data streams and is tasked with constantly updating systems to accommodate rapidly changing statistical analysis packages and approaches, which typically require raw data output from databases in a unique format.
Identifies innovative solutions and new ways traditional data is served (e.g., telemetry locations) including web-based application interfaces with data management systems.
Fields requests from researchers, managers, and other personnel for interim data summaries, tables of results, and other project reports.
Build custom applications such that users can themselves retrieve data summaries, tables of results, and other project reports if such information is required repetitively.
Periodically programs, composes and disseminates custom analyses and reports for the Parks and Wildlife Commission, Colorado Legislature, media inquiries and Colorado Open Records Act (CORA) requests.
Performs any other job-related duties needed to help implement RPP, SCON, & agency missions.
Observes or participates in field activities for the RPP and SCON to gain an understanding of the needs, purpose, procedures, and challenges inherent in data collection for a specific project, maximize efficiency of the associated data management mechanisms, and provide data collection advice to RPP and SCON personnel.
Other duties as assigned
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
At least a Bachelor's degree from an accredited institution in a field of study related to the work assignment such as data management information systems or wildlife biology or closely related field AND at least three years of related professional experience involving database design and management and working with two or more computer programming and query languages.
Additional appropriate experience will substitute for the degree requirement on a year-for-year basis.
Additional appropriate education will substitute for the required experience on a year-for-year basis.
Please note: You may be required to provide your education-related transcripts (if requested) for verification of your qualifications.
Working knowledge of statistics
Basic understanding of wildlife population biology
Basic knowledge of Geographic Information Systems
Excellent interpersonal skills, including the ability to communicate through all avenues of communication (e.g., email, phone, website, in person, etc.)
Ability to multitask and process high volume environment
High attention to detail
Ability to problem solve independently and as a team member
Being reliable and punctual
Ability to perform under pressure and on deadline
Colorado Dept of Natural Resources, Human Resources