GIS Data Engineer - IT Data Management--Journey - Permanent - 2025-05900

Benefits, Questions, Description

• Design and implement systems of record for storing and updating spatial datasets owned by the Wildlife Program.
• Design, implement, and maintain complex GIS resource inventory databases across a variety of data storage platforms.
• Design relational databases using development tools for entity relationship diagramming, script generations, and workflow modelling.
• Maintain source code for the databases and associated scripts in an organized repository.
• Use best practices for security and authentication for access to data.
• Identify nexuses with existing datasets to allow for improved interoperability between internal and external systems.
• Write documentation for the data models and databases before, during, and after development.
• Design and implement automated data pipelines through scripting, replication, or other means and spanning a variety of environments.
• Design and implement Extract-Transform-Load (ETL) patterns and scripts to migrate data across systems.
• Ensure data validation procedures are complete when data is either imported or exported.
• Design pipelines for data to move between environments; some environments are under agency control, while others are managed by third parties.
• Maintain source code for ETLs and scripts in an organized repository.
• Support legacy spatial data management systems and applications.
• Maintain and modify existing databases for domains such as the Private Lands Hunting System, Lands Information System, and legacy data management scripts.
• Design, develop, and implement enhancements to existing databases when necessary.
• Communicate changes to legacy systems to the appropriate users and stakeholders.
• Develop migration strategies when a system has been flagged for retirement.
• Participate in technical analysis and system architecture design process.
• Coordinates with cross-program/division staff to address system and process dependencies.
• Makes recommendations on technologies used in the development of GIS systems of record.
• Evaluates new and emerging technologies to further improve/enhance desktop, web, and mobile data capture, management, and visualization.

• Bachelor’s degree from an accredited college or university with major in Information Technology, Computer Science, Geographic Information Systems, Remote Sensing, Wildlife Management, Wildlife Ecology, Geography, or a closely related field.
• Five (5) years of information technology and geographic information systems experience such as consulting, analyzing, designing, programming and/or maintaining complex spatial and tabular data systems, developing complex computer applications, managing and directing projects, providing customer or technical support in spatial data.

• Benefits
• Retirement and Deferred Compensation
• Social Security
• Public Service Loan Forgiveness
• Holidays
• Sick Leave
• Vacation (Annual Leave)
• Military Leave
• Bereavement Leave
• Additional Leave

State of Washington Job Opportunities | Work that Matters