IT GIS & Data Analyst w/City of Vancouver (WA)

https://cityofvancouver.wd5.myworkdayjobs.com/en-US/COV/job/LOC0075-City-Hall---3rd-Floor/IT-GIS-and-Data-Analyst_23-0054

Job Summary
Provide a professional level of support to end users and managers for the City’s Enterprise Geographic Information System (GIS), data management, and governance. Utilize project management skills and advanced understanding of GIS and data management best practices, techniques, systems architecture, third party software, and data analysis to manage complex projects and to develop data management plans and solutions to meet user needs. Coordinate with multiple departments across the organization to help facilitate user data need and identify opportunities for improvement. Develop and administer Esri suite of software. Manage/administer, design, build SDE enterprise GIS databases using SQL Server, and ensure that these databases are properly optimized. This position requires the ability to develop and maintain solutions using ArcGIS .NET API, automation/ETL processes such as Python, FME Workbench, FME Server and other scripting tools.

​This is a full-time, regular, exempt position.

Open until filled. First review March 20, 2023.

Essential Functions:

• Design, create and maintain geodatabases, including security and performance tuning; Perform database queries; Develop and maintain data/database integrations with other system; and Troubleshoot issues.
• Work with all city departments to assess business needs, develop workflows, and build solutions and documentation to meet those departmental need. Develop and configure web solutions using ArcGIS Enterprise.
• Develop and maintain ETL/automation processes using tools such as FME Workbench, FME Server, and Python to update data, update layers, create layers, and update datasets to/from various systems and develop GIS layers to be used within desktop and web applications.
• Coordinate with GIS and Data Manager and other GIS users to develop and maintain a metadata management system.
• Assist GIS and Data Manager in the administration of ArcGIS Enterprise and ArcGIS Online.
• Integrate commercial software applications such as permitting, work management, asset management, and document management systems with GIS.
• Design and develop intuitive, consistent, and extensible GIS solutions.

Qualifications
Experience and Education

• Five (5) years of related experience with Esri’s ArcGIS suite of software including ArcGIS Enterprise, ArcGIS Portal/ArcGIS for Server/ArcGIS Pro as well as experience administering SDE geodatabases with SQL.
• Equivalent to a Bachelor's Degree in computer science, geography or related field.
• Alternatively, an Associate’s Degree with 6 or more years of related experience will be considered.
• Equivalent combinations of education and experience may be considered.

Computer Skills

• Advanced knowledge of Esri’s ArcGIS suite of products including ArcGIS Enterprise, ArcGIS Portal/ArcGIS Server, ArcGIS Desktop (ArcGIS Pro/ArcMap 10.x or greater), including Esri ArcGIS extensions such as Spatial Analyst, Network Analyst, Field Maps, Workforce, Survey 123, Operations Dashboards, Experience Builder and Story Maps.
• SQL Server Management Studio
• Intermediate: Microsoft Word
• Intermediate: Microsoft Excel
• Intermediate: Microsoft Outlook
• Intermediate: Microsoft PowerPoint

​Required Licenses and/or Certifications

• Possession of a valid driver’s license
• GIS / ESRI Certification preferred
• SQL Server MCSA Certification preferred

Knowledge

• Extensive knowledge and proficiency of database fundamentals, database design, understanding of relational databases, best practices for optimization, and administering enterprise GIS databases (ArcSDE), using stored procedures and web services with SQL Server. (Experience in Public Sector or enterprise GIS environment preferred.)
• Knowledge and understanding of Esri’s new Utility Network is a plus.
• Programming logic, database management, computer operating systems and networks.
• Experience in programming within the ArcGIS environment using ArcGIS .NET API, Python, HTML, Java and Arcade and SQL.
• Experience with designing and developing GIS tools, add-ins, and solutions using some or all of the following tools: ArcGIS, ArcServer, ArcGIS .Net SDK, and ArcGIS API for Python.
• Experience with FME Workbench and FME Server is preferred.
• Pertinent federal, state, and local laws that pertain to Information and records management
  Modern office procedures, methods, and computer equipment
• Use of personal computers and basic software

Abilities

• Performing GIS analysis, GIS data management, and production of cartographic products using Esri’s suite of software
• Operate a personal computer and appropriate software
• Work in a manner consistent with the City of Vancouver’s Operating Principles
• Work and act as a team player in all interactions with other City employees
• Provide a high level of customer service at all times
• Project and maintain a positive image with those contacted in the course of work
• Develop and maintain collaborative and respectful working relationships with team members and others
• Consistently provide quality service
• Maintain regular and dependable attendance
• This position is subject to successful completion of a pre-employment reference check, a basic criminal background check, a driving abstract, and Triple-I fingerprint background check.

​