GIS Enterprise Spatial App Developer (Information Systems Analyst, Principal - GIS Enterprise)

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

Job Appointment: Full Time, Regular
Work Schedule: Monday - Friday, 8:00 AM - 5:00 PM. Alternate schedules may be available.
Work Location: This position has an exception to work primarily remotely. However, there will be instances when it is necessary to come onsite for work (with as much advance notice as possible). Remote work must be performed within Oregon or Washington. For more information, click here.
Benefit: Please check our benefits tab for an overview of benefits for this position
Union Representation: This position is represented by Professional Technical Employees, Local 17 (PROTEC17). To view this labor agreement, please click here.
Starting Pay: The City of Portland follows the Oregon Equal Pay Act. Your salary is determined based on the experience listed in your resume that is directly related and equivalent to the position for which you are applying.

Position Summary:

The Bureau of Technology Services (BTS) Enterprise Geospatial and Data Services team is seeking a GIS Enterprise Spatial and SQL Applications Developer to help maintain and improve the geospatial systems that support City services and decision-making.

This position primarily supports SQL Server enterprise spatial geodatabases within the Esri ArcGIS platform, with additional opportunities to develop and support desktop and web GIS applications. You will design and maintain spatial databases, develop SQL tools and procedures to support geospatial applications and ETL processes, including automation of data workflows, systems integration, and troubleshoot database related technical issues to keep the City’s data accurate, accessible, secure, and reliable.

Working with GIS professionals, developers, analysts, and project managers, you will translate business needs into practical technical solutions. Your work will help improve system performance, integrations, strengthen data integrity, and provide dependable geospatial data services across the organization.

What You’ll Do:

• Maintain enterprise spatial databases:Develop and support SQL Server geodatabases, including schemas, versioning, data integrity, troubleshooting, code development and optimization to support applications, data integrity, and security including cryptography.
• Develop and improve data workflows: Create, maintain, and enhance stored procedures, functions, views, Python applications, SQL Server Integration Services (SSIS) packages, and other extract, transform, and loading (ETL) processes including cross-database and format data synchronizations.
• Design and integrate geospatial data: Develop spatial data models, migrate data, perform quality assurance, and connect data with other business systems.
• Improve performance and reliability: Troubleshoot database and application issues, optimize SQL queries and code, and support stable enterprise applications.
• Develop GIS applications: Opportunities to build and support Esri desktop and web applications using ArcGIS development tools and software development kits.
• Collaborate on technical solutions: Work with GIS professionals, developers, analysts, and project managers to understand requirements and plan, implement, and maintain infrastructure and data services. Work with the City Database Administration Group to manage the Geodatabase Servers.
• Coordinate project work: Contribute technical expertise to larger projects and manage smaller internal projects.
• Document and share knowledge: Create, update, and peer review technical standards, procedures, diagrams, application documentation, and coding guidance.

Ideal Candidate

Our ideal candidate brings strong technical skills, a practical approach to solving problems, and a commitment to effective collaboration. They demonstrate:

• Spatial database expertise:Strong experience supporting SQL Server enterprise geodatabases, writing advanced SQL, and improving database performance and reliability. Knowledge of database management and administration.
• GIS development skills:Experience developing and maintaining applications and services within the Esri ArcGIS platform.
• Automation and integration skills: Ability to create dependable workflows that connect systems, transform data, and reduce manual work.
• Analytical problem-solving: Ability to investigate complex issues, identify underlying causes, and develop sustainable solutions.
• Customer-focused communication: Ability to translate business needs into technical requirements and explain technical concepts clearly to people with different levels of technical knowledge.
• Collaborative and inclusive practices: Ability to build productive relationships, value different perspectives, and work effectively in a culturally and gender-diverse workplace.
• Organization and accountability: Ability to balance competing priorities, document work clearly, and follow through on commitments.

Preferred Qualifications:

• A degree or certification related to GIS or information technology.

• GIS Professional (GISP) certification through the GIS Certification Institute.

• Esri Technical Certification.

• Eight or more years of professional GIS experience.

• Eight or more years of experience administering ArcGIS Enterprise and ArcGIS Online environments.

• Five or more years of development experience in a Microsoft SQL Server environment.

• Five or more years of ArcGIS development experience.

What to Expect:

1. Application Review - Week of November 23, 2026: We'll review your application materials to ensure you meet the minimum qualifications listed above.
2. Notice/Feedback - Week of November 30, 2026:You will receive an email when the minimum qualification review is complete. If you disagree with the evaluation results, you may request a review within 14 days of the email notice, per City Administrative Rule 3.01.
3. Selection Process - Mid-December: The hiring bureau will review qualified applications, conduct interviews, and check references.
4. Conditional Job Offer - Final: candidates may undergo a background or driving record check, depending on the position.

Learn More About:

• How to Apply Videos and Workshops
• City of Portland Core Values
• HRAR-3.01 - Recruitment Processes
• Veteran Preference Information
• Total Compensation and Benefits
• Language Pay Differential Eligibility

We’re committed to providing a fair, inclusive, and accessible hiring process. If you need assistance with your application or would like to request a reasonable accommodation due to a disability, pregnancy, or religious belief, please contact the recruiter listed below.

TroyLynn Craft, Senior Recruiter
[e-mail] Bureau of Human Resources

Questions? We're here to help!
If you have questions about this recruitment or need assistance, contact: