Remote GIS Enterprise Spatial & SQL Developer

City of Portland, Oregon; Portland (OR); Remote; USD 105,000 - 145,000; Full time

Job summary

The City of Portland seeks a GIS Enterprise Spatial and SQL Applications Developer to maintain and improve geospatial systems supporting city services. Focus is on SQL Server geodatabases, ETL pipelines, and Esri ArcGIS platforms while building desktop and web GIS apps.

You will design spatial models, optimize data workflows, and troubleshoot data issues to ensure secure, accessible city data. Collaborate across teams to deliver reliable GIS solutions.

Qualifications

• Spatial database expertise: SQL Server geodatabases, performance tuning, data integrity.
• GIS development: building and maintaining Esri ArcGIS-based apps/services.
• Automation: create dependable data workflows and ETL processes.
• Analytical problem-solving: diagnose complex issues and implement sustainable fixes.
• Customer-focused comms: translate needs into technical requirements clearly.
• Collaborative and inclusive: work across diverse teams.
• Organization and accountability: manage priorities and document work clearly.

Responsibilities

• Maintain enterprise spatial databases and SQL Server geodatabases with schemas and versioning.
• Develop and optimize stored procedures, views, and SSIS packages for geospatial data.
• Design and integrate geospatial data and support data migration.
• Troubleshoot performance issues and optimize SQL queries for reliability.
• Develop GIS desktop and web applications using Esri tools.
• Collaborate with GIS staff, developers, and project managers on solutions.
• Coordinate project work and contribute to larger initiatives.
• Document standards, procedures, and coding guidelines.

Skills

Spatial DB

GIS Development

Automation & ETL

Problem Solving

Communication

Collaboration

Organization

Education

GIS Degree

GISP Certification

Esri Certification

ArcGIS Admin

SQL Server Admin

Tools

ArcGIS Enterprise

ArcGIS Online

Job description

The City of Portland seeks a GIS Enterprise Spatial and SQL Applications Developer to maintain and improve geospatial systems supporting city services. Focus is on SQL Server geodatabases, ETL pipelines, and Esri ArcGIS platforms while building desktop and web GIS apps.

You will design spatial models, optimize data workflows, and troubleshoot data issues to ensure secure, accessible city data. Collaborate across teams to deliver reliable GIS solutions.