GIS Enterprise Spatial App Developer; Information Systems Analyst, Principal - GIS Enterprise

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, .
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 (PROTEC
17). To view this labor agreement, .
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.

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.

• 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.

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…