GIS Developer Services

The vendor is required to provide geographic information system (GIS) developer contractor on an as-needed basis.
- GIS software and spatial database development, including the use of PostgreSQL and post GIS, or equivalent.
- Task
•    Geographic information systems: systems design, configuration, implementation, and integration services, application development, data conversion, and workflow and records management.
•    Database management: database design and analysis, management and administration, security, governance, data quality management, and structured query language (SQL) programming, including enterprise, cloud and database warehouse design and implementations.
•    Software or application development: design, development, implementation, and support of custom programming code (primarily web services-based applications) adapted to specific or enterprise-wide uses, either as a primary system or as a deployable interface used to integrate and interact with multiple diverse systems.
- The GIS developer will play a key role in designing the technical framework that enables this analysis, integrating data from multiple sources, implementing defined calculations, and producing repeatable, accurate outputs that support policy evaluation and compliance reporting.
- Job description
•    GIS developer to support the department systems and citywide housing policy teams in developing a robust data infrastructure and analytical model for the sb 79 project.
•    The GIS developer will design and implement a database and spatial data model to support the department’s analysis of parcel-level compliance under sb 79.
•    This role involves integrating and staging both tabular and spatial GIS datasets into a database environment, developing tools or scripts to automate data processing, and building a program or workflow to execute the defined data model and generate outputs.
•    The GIS developer will collaborate closely with the citywide housing policy staff, who will define the calculation logic, and with the department systems team, who will provide reference GIS datasets and technical support for data integration.
- Task descriptions
•    Design, develop, and maintain a relational database (e.g., PostgreSQL and post-GIS or equivalent) to store, organize, and manage GIS and tabular data relevant to sb 79. 
•    Develop a data model and associated processing workflows to evaluate parcel-level compliance with sb 79 criteria. 
•    Work closely with the citywide housing policy team to translate model calculations and compliance rules into executable spatial and tabular data models. 
•    Collaborate with the systems team to access, clean, and stage GIS reference data for integration into the project database. 
•    Develop scripts, tools, or applications (in python, SQL, or similar languages) to automate data ingestion, transformation, and analysis. 
•    Ensure data accuracy, integrity, and performance through quality control checks and optimization of spatial queries. 
•    Produce reproducible data outputs and reports to support policy analysis. 
•    Document database schema, data model logic, and workflow processes to support long-term maintenance and transparency.