General 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). Essential Functions & Duties
- 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.
Minimum Qualifications Sufficient education, training, and experience to demonstrate the knowledge and ability to successfully perform the essential functions of the position. In lieu of a degree, work-related experience that demonstrates the skills and experience necessary to perform this role will be accepted. Development of the required knowledge and abilities is typically obtained through but not limited to:
- 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.
Technical Qualifications
- 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.)
Preferred Qualifications:
- 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.
Additional Information
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.
Benefits
Below is a summary of the comprehensive benefits provided to District full-time employees:
Health and Welfare Benefits:
- Healthcare Benefits –District employees are offered a choice of healthcare providers under the CalPERS Health Benefits Program. The District will contribute ninety (90) percent towards monthly premiums for full-time employees. Fifty (50) percent for part-time employees.
- Free Dental and Vision Benefits provided – Employer Covers Premiums
- Free Employee Assistance Benefit – Employees are entitled to 5 face-to-face sessions or telephonic or web-video consultations for problem-solving support per incident, per calendar year.
- Flexible Spending Accounts – Pre-tax dollars to pay for qualified Health or Dependent Care expenses.
Retirement Medical Benefits:
- Long Term Disability Insurance – After 90 days of total disability, Administrative full-time employees are eligible for 60% of monthly income covered by the District.
- Health and Wellness – Gyms located at most work locations and discounted Weight Watcher Membership Option.
Holidays and Paid Time Off:
- Paid Time Off – Newly hired employees accrue 6.5 hours bi-weekly when hired (if Exempt 8.25 hours). As you move up in years of service credit, the rate of the amount of PTO accrued will also increase.
- Paid Holidays – The District provides seven paid holidays throughout the year – New Years Day, Martin Luther King Jr. Day, Memorial Day, Independence Day (July 4th), Labor Day, Thanksgiving Day and Christmas Day
- Floating Holidays – District employees can earn up to five (5) floating holidays.
Financial Planning Benefits:
- Pension Benefits through CalPERS –You must have a minimum of 5 years of service to be eligible for this pension.
- CalPERS PEPRA vs. Classic – All employees hired on, or after January 1, 2013, are considered PEPRA members and will contribute 8% of their salary up to the maximum IRS cut-off. All Classic members will contribute 6%
- Deferred Compensation Options – Select to contribute to one or both of our Tax Deferred Compensation Options
- Reliance Standard Life Insurance with 100% premium paid by the District - 1 times annual salary of employee – max $200,000
- Optional Life Insurance – Employees may purchase additional life insurance for themselves and their eligible family members.
Growth and Education Benefits:
- Professional Development – Access to LinkedIn Learning and San Mateo County’s professional training. District Tuition Reimbursement Program – A maximum of $5,250 per year for courses related to your job or career goals with the District.
- Computer Loan Program – Interest-free two-year loan with a maximum amount of $2,000.
Other Amazing Benefits:
- Credit Union – Employees and family members are eligible to join the San Mateo Credit Union and Patelco Credit Union.
- Employee Clean Commute (ECC) – Car/Van poolers and Public Transit riders receive a monthly reimbursement.
- Commuter Benefits – Free Employee Parking; Free Bus Pass for employee as well as children/spouse; Clipper Card/Go Pass Program for Central employees.
For union employees, all of the above benefits are subject to the employee’s Collective Bargaining Agreement. Benefits listed are also subject to change with or without notice and are subject to contract/provider terms and conditions. The selection process may include a panel interview, written and skills test assessments, or supplemental questions. Only those candidates who are the most qualified will continue in the selection process. Meeting the minimum qualifications does not guarantee an invitation to continue in the process.
How to Apply
• Complete an online employment application by 11:59 p.m. of the listed closing date. Resumes and cover letters will not be accepted in lieu of fully completed applications. It is the applicant’s responsibility to ensure that applications are completed with all relevant information (experience, education, certifications, licenses, references and/or other information).
• The Human Resources Department will make reasonable efforts in the recruitment/examination process to accommodate applicants with disabilities upon request. If you have a need for an accommodation, please contact the Human Resources Department.
• We celebrate diversity and are committed to creating an inclusive and welcoming workplace environment. We are an Affirmative Action/Equal Opportunity Employer. Minorities, Women, Persons with Disabilities and Veterans are encouraged to apply.