Remote GIS Enterprise Spatial & SQL Applications Developer

City of Portland; Beaverton (OR); Hybrid; USD 90,000 - 120,000; Full time

Job summary

City of Portland is seeking a GIS Enterprise Spatial and SQL Applications Developer to maintain and enhance geospatial systems that support City services and decision making.

You will work with SQL Server geodatabases, create and optimize ETL processes, and develop GIS applications within Esri ArcGIS, both desktop and web, to improve data accessibility and reliability across the organization.

Qualifications

• Experience supporting SQL Server enterprise geodatabases and writing advanced SQL.
• Ability to design and optimize spatial data models and workflows.

Responsibilities

• Maintain enterprise spatial databases and geodatabases, including schemas and data integrity.
• Develop and optimize data workflows using SQL, SSIS, and Python.
• Design, migrate, and connect spatial data with business systems.
• Improve performance and reliability of geospatial applications.
• Develop Esri desktop and web applications using ArcGIS tools.

Skills

Spatial databases

GIS development

Automation & integration

Analytical problem solving

Communication

Collaboration

Organization & accountability

Education

GIS or IT degree/certificate

GISP certification

Esri Technical Certification

Tools

Esri ArcGIS

SQL Server

SSIS

Python

Job description

City of Portland is seeking a GIS Enterprise Spatial and SQL Applications Developer to maintain and enhance geospatial systems that support City services and decision making.

You will work with SQL Server geodatabases, create and optimize ETL processes, and develop GIS applications within Esri ArcGIS, both desktop and web, to improve data accessibility and reliability across the organization.