GIS Developer/Analyst

The GIS Analyst / Developer II reports to the Manager, IT or IT Director (Applications) and will be responsible for complete systems life cycle management activities (e.g., analyses, design, technical requirements, coding, testing) implementation for geospatial and other application systems that support agency operations, planning, asset management, and field data workflows. This role is responsible for configuring, administering, developing, and integrating both Esri and open-source GIS technologies into enterprise systems such as ERP, CRM, Asset Management, Scheduling, and Planning applications, for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (JPB), and the San Mateo County Transportation Authority (TA). 

• Designs, develops, administers, and supports enterprise GIS solutions using ArcGIS Enterprise, ArcGIS Online, ArcGIS Pro, OGIS, geodatabases, web maps, feature services, dashboards, mobile GIS, and related technologies.
• Develops geospatial applications, automation, scripts, workflows, and analytical tools using Python, ArcPy, Arcade, ModelBuilder, SQL, REST APIs, and web-GIS development tools.
• Designs and maintains GIS data models, geodatabases, metadata, editing workflows, data-quality controls, service-publishing standards, and data-governance practices.
• Performs spatial analysis, cartography, geoprocessing, data visualization, and decision support for transit routes, stops, stations, facilities, service areas, assets, ridership, accessibility, and capital projects.
• Integrates GIS with transit applications, asset-management systems, work-management systems, CAD/AVL, ERP/CRM platforms, operational databases, APIs, reporting tools, and external data sources.
• Administers ArcGIS Enterprise services, security, access controls, user roles, data-sharing settings, backups, recovery processes, system performance, and availability.
• Develops and maintains GIS dashboards, web maps, mobile data-collection tools, public-facing or internal GIS applications, and operational reporting tools. 
• Develop and configures mobile/field data collection apps. Optimize spatial databases and maintain a living GIS data dictionary
• Leads technical planning, requirements analysis, implementation, testing, deployment, and support for complex GIS initiatives involving multiple District departments.
• Develops and executes unit, system, integration, regression, and user-acceptance testing; validates spatial accuracy, completeness, performance, and usability.
• Establishes and maintains technical documentation, system diagrams, data dictionaries, support procedures, test plans, implementation plans, and GIS standards.
• Coordinates GIS-related vendor work, software licensing, implementation activities, technical support cases, and product evaluations.
• Applies security, least-privilege, privacy, accessibility, data-retention, and change-management practices to GIS systems and data.
• Provides technical mentoring, guidance, and review to GIS users, analysts, developers, consultants, and project teams.
• Participates in scheduled and unscheduled off-hours support, maintenance windows, incident response, disaster recovery testing, and service-restoration activitiess.

Examples of Duties:

• Acts as technical expert and maintains responsibility for analysis, design, and implementation of projects as assigned, including complex and highly specialized applications.
• Design and develop complex workflows and innovative ideas on modernizing business practices.
• Perform spatial analysis and obtain location information and/or data extraction from large datasets.
• Review and process (QA/QC) spatial data, perform data/attribute enrichment, and migrate production ready data to a centralized repository.
• Produce professional maps/figures and investigate and analyze spatial datasets.
• Develop, maintain, and optimize linear referencing systems/networks.
• Develop efficient and repeatable scripts that streamline complex and reoccurring tasks.
• Review and publish production ready GIS data on to Agency GIS Portal.
• Participate in the investigation, procurement, installation, configuration, administration, maintenance and integration of commercial off-the-shelf (COTS) software that specializes in geospatial technology and solutions to streamline GIS and other business processes.
• Support to the creation, implementation, and maintenance of GIS standard operating procedures, as well as GIS related policies and procedures for data creation/acquisition.
• Participate in new release feature and functionality reviews to provide ongoing technical guidance and support.
• Maintains the sensitivity and confidentiality of data and systems architecture environment.
• Monitor GIS related software, databases, and applications and conducts performance tuning as needed.
• Validate features and datasets, tools/widgets, scripts, and software upgrades/patches
• Provide input for the preparation, coordination, and management of GIS project work plans and schedules to include defining requirements, tasks, and resource assignments, ensuring that approved quality levels and deadlines are met
• Conduct GIS user trainings and prepare technical papers, presentations, procedures/ training manuals, and demonstration videos to help support staff and end users utilize spatial applications.
• Provide strategic leadership in identifying and prioritizing the evolution of the GIS Applications (ESRI and Open-source GIS technologies). Lead discussion and assist in making decisions on application data relationships required for managing the integrity of data representing the agency.
• Steer the business community in achieving digital transformation and streamline their operations towards productive/optimal workflow practices within and across multiple user groups. Coordinate with other departments on integrated applications as needed. 
• Identify and lead the implementation of new and creative solutions that are compatible with current and future technologies.
• Analyze situations, identify problems, and recommend and implement solutions in a cost-effective manner.

• Perform all job duties and responsibilities in a safe manner to protect one's self, fellow employees and the public from injury or harm. Promote safety awareness and follow safety procedures in an effort to reduce or eliminate accidents.

• Performs related duties and may be assigned to other applications, projects, or technology assignments based on District business needs.

• Degree in GIS/Geography (Cartography), Computer Science, Information Systems, Engineering, or a related field with major course work in GIS. 
• Five (5) years of experience developing and managing enterprise geographic information systems and databases for one or more of the following environments asset management, engineering, planning, public health, environmental, and transportation.
• Demonstrated ability to establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.

• Esri’s ArcGIS Pro and ArcGIS Online
• HTML, advanced JavaScript, and CSS
• ArcGIS JavaScript API, Dojo, ArcGIS Server & Web Adaptor
• Python, React, Vue.js, TypeScript, and Arcade, Calcite
• Knowledge of OS Geo including: GeoServer, OpenLayers, Esri’s Leaflet
• Geospatial enabled database platforms (e.g. MS SQLServer, PostgreSQL, Oracle, etc.)

• Seven (7) years of experience developing and managing enterprise GIS and databases in the aforementioned environments. 
• Excellent verbal and written communication and presentation skills.
• Experience in public sector/transportation, railroad, utility, environmental, or public works industry.
• Proficiency with Esri and Open-Source GIS software/platforms (e.g. ArcGIS Pro, ArcGIS Server, ArcGIS Online, QGIS, GeoServer, OpenLayers, etc.)
• Experience with field data collection and techniques.
• Experience with web application development, public-facing GIS tools, or accessibility-compliant geospatial applications.
• Experience with data integration platforms, relational databases, and computer networks.
• Able to possess a California driver’s license with a safe driving record.

Knowledge of:

• Transit operational workflows and the operational consequences of system changes.
• GIS principles, spatial data management, spatial analysis, cartography, and enterprise GIS support
• Enterprise GIS architecture, geodatabase design, service publishing, security, performance, backup/recovery, metadata, and data quality.
• Spatial analysis, cartography, transit data, and GIS integration patterns.

Ability to:

• Establish and apply GIS standards, technical documentation, data governance, and quality-control procedures.
• Assess technical alternatives and recommend sustainable, scalable GIS solutions.
• Analyze and communicate the reliability, limitations, and appropriate use of geospatial data.
• Mentor staff and promote consistent GIS practices across the District.
• Protect sensitive operational, location, employee, customer, and security-related information.
• Diagnose application, database, interface, data-quality and configuration issues.
• Engage with technical and nontechnical stakeholders and explain GIS capabilities, limitations, data quality, and analytical results.
• Translate business needs into GIS requirements, data models, application designs, and implementation plans.
• Lead cross-department technical work and coordinate vendors, consultants, and internal staff.
• Communicate clearly through maps, dashboards, written technical documentation, and oral presentations.