GIS Developer/Analyst

San Mateo County Transit District•Millbrae, CA

About The Position

The GIS Analyst / Developer II reports to the Manager, IT or IT Director (Applications) and manages the systems life cycle for geospatial and other application systems that support agency operations, planning, asset management, and field data workflows. The role configures, administers, develops, and integrates Esri and open-source GIS technologies with enterprise systems, including ERP, CRM, asset management, scheduling, and planning applications, for SamTrans, the Peninsula Corridor Joint Powers Board, and the San Mateo County Transportation Authority. The position develops and supports enterprise GIS solutions, applications, integrations, spatial data, analytics, dashboards, web maps, mobile data-collection tools, and operational reporting. It leads technical planning and implementation of complex GIS initiatives, establishes standards and data-governance practices, oversees testing and documentation, coordinates vendors and technical support, and provides technical guidance and training. The role also supports system security, performance, availability, incident response, maintenance, and disaster recovery, including scheduled and unscheduled off-hours activities.

Requirements

Sufficient education, training, and experience to demonstrate the knowledge and ability to perform the essential functions; relevant work experience may be accepted in lieu of a degree.
Typically, a degree in GIS/Geography (Cartography), Computer Science, Information Systems, Engineering, or a related field with major coursework in GIS.
Five years of experience developing and managing enterprise geographic information systems and databases in one or more of the following environments: asset management, engineering, planning, public health, environmental, or transportation.
Ability to establish, maintain, and foster positive and effective working relationships.
Technical experience with Esri ArcGIS Pro and ArcGIS Online.
Knowledge of HTML, advanced JavaScript, and CSS.
Experience with ArcGIS JavaScript API, Dojo, ArcGIS Server, and Web Adaptor.
Knowledge of Python, React, Vue.js, TypeScript, Arcade, and Calcite.
Knowledge of OSGeo technologies, including GeoServer, OpenLayers, and Esri Leaflet.
Experience with geospatial-enabled database platforms such as Microsoft SQL Server, PostgreSQL, or Oracle.
Knowledge of GIS principles, spatial data management, spatial analysis, cartography, enterprise GIS support and architecture, geodatabase design, service publishing, security, performance, backup and recovery, metadata, and data quality.
Ability to apply GIS standards, technical documentation, data governance, and quality-control procedures; assess technical alternatives; and recommend sustainable, scalable solutions.
Ability to communicate geospatial data reliability, limitations, and appropriate use; diagnose application, database, interface, data-quality, and configuration issues; and translate business needs into GIS requirements and implementation plans.
Ability to protect sensitive operational, location, employee, customer, and security-related information.
Ability to engage technical and nontechnical stakeholders, lead cross-department technical work, coordinate vendors and staff, and communicate through maps, dashboards, documentation, and presentations.

Nice To Haves

Seven years of experience developing and managing enterprise GIS and databases in the listed environments.
Excellent verbal, written, and presentation skills.
Experience in public sector, transportation, railroad, utility, environmental, or public works industries.
Proficiency with Esri and open-source GIS software and platforms, such as ArcGIS Pro, ArcGIS Server, ArcGIS Online, QGIS, GeoServer, and OpenLayers.
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.
Ability to possess a California driver’s license with a safe driving record.

Responsibilities

Design, develop, administer, and support enterprise GIS solutions using Esri and open-source technologies.
Develop geospatial applications, automation, scripts, workflows, and analytical tools.
Design and maintain GIS data models, geodatabases, metadata, editing workflows, data-quality controls, publishing standards, and data-governance practices.
Perform spatial analysis, cartography, geoprocessing, data visualization, and decision support for transit operations, assets, accessibility, and capital projects.
Integrate GIS with transit, asset-management, work-management, CAD/AVL, ERP/CRM, operational database, API, reporting, and external data systems.
Administer ArcGIS Enterprise services, security, user roles, data sharing, backups, recovery, system performance, and availability.
Develop and maintain GIS dashboards, web maps, mobile data-collection tools, internal and public-facing GIS applications, and operational reports.
Configure mobile and field data-collection applications, optimize spatial databases, and maintain a GIS data dictionary.
Lead technical planning, requirements analysis, implementation, testing, deployment, and support for complex GIS initiatives across departments.
Develop and execute unit, system, integration, regression, and user-acceptance tests, validating spatial accuracy, completeness, performance, and usability.
Create and maintain technical documentation, system diagrams, data dictionaries, support procedures, test plans, implementation plans, and GIS standards.
Coordinate GIS vendor work, software licensing, implementation activities, support cases, and product evaluations.
Apply security, least-privilege, privacy, accessibility, data-retention, and change-management practices.
Provide technical mentoring, guidance, and review to GIS users, analysts, developers, consultants, and project teams.
Participate in scheduled and unscheduled off-hours support, maintenance windows, incident response, disaster recovery testing, and service restoration.
Act as technical expert for assigned projects, including complex and highly specialized applications.
Design complex workflows and identify ways to modernize business practices and streamline operations.
Extract location information and data from large datasets; review, quality-check, enrich, and migrate production-ready spatial data to a centralized repository.
Produce professional maps and figures, investigate spatial datasets, and develop and maintain linear referencing systems and networks.
Develop efficient, repeatable scripts to streamline complex and recurring tasks, and publish production-ready GIS data to the Agency GIS Portal.
Participate in procurement, installation, configuration, administration, maintenance, and integration of commercial geospatial software.
Support GIS standard operating procedures and policies for data creation and acquisition; review new software releases and provide technical guidance.
Maintain confidentiality of data and systems architecture, monitor GIS software and databases, tune performance, and validate features, datasets, tools, scripts, and software upgrades or patches.
Contribute to GIS project work plans and schedules, including requirements, tasks, resource assignments, quality levels, and deadlines.
Conduct GIS user training and prepare technical papers, presentations, procedures, training manuals, and demonstration videos.
Provide strategic leadership in prioritizing GIS application evolution and advising on application data relationships and data integrity.
Coordinate with other departments on integrated applications and lead implementation of creative solutions compatible with current and future technologies.
Analyze situations, identify problems, and recommend and implement cost-effective solutions.
Perform duties safely, promote safety awareness, and take on related applications, projects, or technology assignments as business needs require.