GIS Enterprise Spatial App Developer (Information Systems Analyst, Principal - GIS Enterprise)
About The Position
The Bureau of Technology Services Enterprise Geospatial and Data Services team is seeking a GIS Enterprise Spatial and SQL Applications Developer to maintain and improve the geospatial systems supporting City services and decision-making. The 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. It designs and maintains spatial databases; develops SQL tools, procedures, and automated data workflows; supports systems integration and ETL processes; and troubleshoots database-related technical issues to keep City data accurate, accessible, secure, and reliable. The role works with GIS professionals, developers, analysts, and project managers to translate business needs into practical technical solutions and improve system performance, integrations, data integrity, and geospatial data services. The position is full-time and regular, with a Monday–Friday, 8:00 AM–5:00 PM schedule; alternate schedules may be available. It is primarily remote, with occasional onsite work as needed. Remote work must be performed within Oregon or Washington. The position is represented by Professional Technical Employees, Local 17 (PROTEC17). Starting pay is determined based on directly related and equivalent experience listed in the applicant’s resume, in accordance with the Oregon Equal Pay Act.
Requirements
- Experience applying 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 tools and languages 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 technical solutions in collaboration with customers, stakeholders, project managers, developers, and analysts.
- Experience establishing and maintaining effective working relationships and collaborating with diverse teams, technical staff, business partners, and other organizational stakeholders in support of enterprise initiatives.
- Ability to communicate customer needs as technical requirements and explain technical concepts clearly to people with varying levels of technical knowledge.
- Ability to balance competing priorities, document work clearly, and follow through on commitments.
Nice To Haves
- 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.
Responsibilities
- Develop and support SQL Server enterprise geodatabases, including schemas, versioning, data integrity, troubleshooting, code development and optimization, application support, and security including cryptography.
- Create, maintain, and enhance stored procedures, functions, views, Python applications, SQL Server Integration Services (SSIS) packages, and other ETL processes, including cross-database and format data synchronizations.
- Develop spatial data models, migrate data, perform quality assurance, and connect geospatial data with other business systems.
- Troubleshoot database and application issues, optimize SQL queries and code, and support stable enterprise applications.
- Build and support Esri desktop and web applications using ArcGIS development tools and software development kits, as opportunities arise.
- 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.
- Contribute technical expertise to larger projects and manage smaller internal projects.
- Create, update, and peer review technical standards, procedures, diagrams, application documentation, and coding guidance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
