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

City of Portland, Oregon
  • Portland, OR
  • $114,275.20–$160,784 Per Year
3 days ago

Job Description

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

Salary

$114,275.20 - $160,784.00 Annually

Location

Portland Building, 1120 SW 5th Ave, OR

Job Type

Regular

Job Number

2026-00964

Bureau

Bureau of Technology Services

Opening Date

11/09/2026

Closing Date

11/23/2026 11:59 PM Pacific

  • Description
  • Benefits
  • Questions

The Position

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.

To Qualify

Applicants must demonstrate how their education, training, and experience meet each of the minimum qualifications listed below:

  • Experience applying Geographic Information Systems (GIS), relational database management systems (RDBMS), and Business Intelligence (BI) principles, methods, and best practices. Knowledge of database management and administration.
  • Experience developing, programming, implementing, and supporting geospatial applications and enterprise GIS solutions using ESRI technologies, including ArcGIS Pro, ArcGIS Enterprise, ArcGIS Online, ArcGIS SDK for .NET, ArcGIS API for Python, and ArcMap.
  • Experience developing software solutions using programming languages and tools such as FME, C#, Python, SQL, XML, JSON, Visual Studio, REST APIs, and SQL database integration.
  • Experience designing, developing, optimizing, and maintaining spatial databases and data management solutions within complex business systems, including advanced SQL development, spatial database design, data integration, performance tuning, and data transformation.
  • Experience gathering and analyzing complex business requirements, applying the full software development lifecycle, and designing innovative technical solutions in collaboration with customers, stakeholders, project managers, developers, and analysts.
  • Experience establishing and maintaining effective working relationships and collaborating successfully with diverse teams, technical staff, business partners, and other organizational stakeholders in support of enterprise initiatives.

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.

The Recruitment Process

How to Apply:

  • Submit your resume and responses to the supplemental questions by the closing date. The information you provide must correctly reflect your work history/resume. A lack of information in your application materials to each of the minimum qualifications may result in elimination from the recruitment.
  • (Optional) Submit Veterans' Preference documents, if applicable.

If this is your first time applying with the City of Portland, or if you haven't requested veteran preference before (and would like to now), please attach your DD214-Member 4 and/or VA Benefit Letter to your application. Once we verify your eligibility, we'll record your veteran preference in our system, so it automatically applies to your future applications.

  • Click here for application tips for resume, supplemental question response and/or cover letter.

What to Expect:

  • Application Review - Week of November 23, 2026: Well review your application materials to ensure you meet the minimum qualifications listed above.
  • 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.
  • Selection Process - Mid-December: The hiring bureau will review qualified applications, conduct interviews, and check references.
  • Conditional Job Offer - Final candidates may undergo a background or driving record check, depending on the position.

Additional Information

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.

Questions? Were here to help!

If you have questions about this recruitment or need assistance, contact:

TroyLynn Craft, Senior Recruiter

troylynn.craft@portlandoregon.gov

Bureau of Human Resources

A Career with the City of Portland offers many Employee Benefits

We offer a comprehensive benefits package, including but not limited to

  • Health Care (Medical, Vision and Dental)
  • Carrot Fertility
  • Wellness Benefits
  • Life Insurance
  • Long-term disability
  • Employee Assistance Plan
  • Flexible Spending Accounts
  • Retirement
  • Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer
  • Family Medical Leave
  • City Paid Parental Leave

AND SO MANY MORE!

Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers.

01

Thank you for considering joining the City of Portland. We sincerely value your time and hope to make your application experience as positive as possible.

The following supplemental questions are an important step in the examination and selection process to assist us in determining if you possess the knowledge, skills, and abilities to succeed in the posted vacancy.

A lack of a complete and thorough response to each of the supplemental questions in the space provided may result in disqualification from the examination. In addition, the selections you make and responses you provide in the questionnaire must accurately reflect what is documented in your resume.

Have you read and understood the information listed above?

  • Yes
  • No - If you have any questions, please contact the recruiter on the announcement.

02

Where did you first learn about this job opportunity? (If on a website or job board, please specify which one)

03

The City of Portland receives public records requests at times. Please indicate which response you find appropriate: (Answer will not disqualify you from the process)

  • My application was submitted with the understanding that the City of Portland would keep the information confidential and would only disclose the information if ordered to do so. I would not have submitted this application without the promise of confidentiality.
  • You may release my application; I am waiving confidentiality.

04

Experience applying Geographic Information Systems (GIS), relational database management systems (RDBMS), and Business Intelligence (BI) principles, methods, and best practices. Knowledge of database management and administration.

Describe how your experience meets this minimum qualification. In your response, include:

  • Your experience with GIS, RDBMS, and BI principles, methods, and best practices.
  • Your knowledge of database management and administration.
  • An example of a project where you have applied this experience to manage data, analyze information, or support business decisions.
  • The tools and methods you used and the results of your work. Limit your response to 1-2 paragraphs. If you do not have relevant knowledge, enter "N/A."

05

Experience developing, programming, implementing, and supporting geospatial applications and enterprise GIS solutions using ESRI technologies, including ArcGIS Pro, ArcGIS Enterprise, ArcGIS Online, ArcGIS SDK for .NET, ArcGIS API for Python, and ArcMap.

Describe how your experience meets this minimum qualification. In your response, include:

  • The ESRI technologies you have used and how you used them.
  • A specific geospatial application or enterprise GIS solution you helped develop, program, implement, or support.
  • Your responsibilities, the business need addressed, and the results. Limit your response to 1-2 paragraphs. If you do not have relevant experience, enter "N/A."

06

Experience developing software solutions using programming languages and tools such as FME, C#, Python, SQL, XML, JSON, Visual Studio, REST APIs, and SQL database integration.

Describe how your experience meets this minimum qualification. In your response, include:

  • The programming languages and tools you have used to develop software solutions.
  • Your role in writing, testing, and/or troubleshooting the solution.
  • How the solution integrated data or systems, automated a process, or addressed a business need, and the results. Limit your response to 1-2 paragraphs. If you do not have relevant experience, enter "N/A."

07

Experience designing, developing, optimizing, and maintaining spatial databases and data management solutions within complex business systems, including advanced SQL development, spatial database design, data integration, performance tuning, and data transformation.

Describe how your experience meets this minimum qualification. In your response, use an example from your experience that demonstrates:

  • Supporting geodatabases, advanced SQL development and data transformation.
  • A specific data management challenge, the methods you used to address it, and the results. Limit your response to 1-2 paragraphs. If you do not have relevant experience, enter "N/A."

08

Experience gathering and analyzing complex business requirements, applying the full software development lifecycle, and designing innovative technical solutions in collaboration with customers, stakeholders, project managers, developers, and analysts.

Describe an example of this experience. In your response, include:

  • How you gathered, analyzed, and confirmed complex business requirements.
  • Your involvement in requirements gathering, design, development, testing, implementation, and ongoing support.
  • How you collaborated with others to design a technical solution and how the solution met the identified business needs. Limit your response to 1-2 paragraphs. If you do not have a relevant example, enter "N/A."

Required Question

Employer City of Portland

Address 1120 SW 5th Ave, Room 987

Portland, Oregon, 97204

Website http://www.portland.gov/jobs

Numbers & Facts

LocationPortland, OR
Salary$114,275.20–$160,784 Per Year

Skills

  • Analysis Skillsunmatched
  • Application Programming Interface (API)unmatched
  • ArcGISunmatched
  • ArcMapunmatched
  • Automationunmatched
  • Best Practicesunmatched
  • Business Analysisunmatched
  • Business Intelligenceunmatched
  • Business Skillsunmatched
  • Business Solutionsunmatched
  • Business Supportunmatched
  • City Administrationunmatched
  • Compensation and Benefitsunmatched
  • Cryptographyunmatched
  • Customer Relationsunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Database Administrationunmatched
  • Database Data Formatsunmatched
  • Database Designunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Programmingunmatched
  • Desktop Administrationunmatched
  • Desktop PCunmatched
  • Documentationunmatched
  • Driver's Licenseunmatched
  • ESRIunmatched
  • Employee Assistance Planunmatched
  • Enterprise Applicationsunmatched
  • Follow Throughunmatched
  • Geographic Information Systems (GIS)unmatched
  • Healthcareunmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Internet Applicationunmatched
  • Interviewing Skillsunmatched
  • JSONunmatched
  • Life Insuranceunmatched
  • Microsoft .NETunmatched
  • Microsoft C# (C Sharp)unmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Visual Studiounmatched
  • Needs Assessmentunmatched
  • Performance Managementunmatched
  • Performance Tuning/Optimizationunmatched
  • Problem Solving Skillsunmatched
  • Programming Languagesunmatched
  • Programming Toolsunmatched
  • Project/Program Coordinationunmatched
  • Project/Program Managementunmatched
  • Python Programming/Scripting Languageunmatched
  • Quality Assuranceunmatched
  • Query Optimizationunmatched
  • REST (Representational State Transfer)unmatched
  • Reference Verificationunmatched
  • Relational Databases (RDBMS)unmatched
  • Reliability Engineeringunmatched
  • Requirements Managementunmatched
  • Root Cause Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Databasesunmatched
  • SQL Server Integration Services (SSIS)unmatched
  • Server Supportunmatched
  • Software Administrationunmatched
  • Software Designunmatched
  • Software Developmentunmatched
  • Software Development Lifecycle (SDLC)unmatched
  • Spatial Dataunmatched
  • Stored Proceduresunmatched
  • System Integration (SI)unmatched
  • Systems Administration/Managementunmatched
  • Systems Analysisunmatched
  • Team Playerunmatched
  • Technical/Engineering Designunmatched
  • Test Plan/Scheduleunmatched
  • Testingunmatched
  • Web Programmingunmatched
  • Work From Homeunmatched
  • XML (EXtensible Markup Language)unmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder