Address Dataset Maintenance Analyst

SF Enterprise GIS Program (SFGIS) is seeking an Address Dataset Maintenance Analyst, reporting to the Enterprise GIS Engineer. As the Address Dataset Analyst, you will primarily be responsible for operating the EAS and maintaining its address spatial and tabular data, as well as operating the custom software that supports the EAS (for example, the Bulk Loader). Secondary tasks include developing and maintaining automated address data flows; developing and maintaining dashboard and cartographic displays of address data metrics; and documenting all related artifacts and work processes.


Essential Duties:

  • Primarily, operate the City’s Enterprise Addressing System (EAS), and the custom software that supports the EAS, to augment and maintain the City’s address dataset.
  • Heads-up digitization of spatial features.
  • Query relational database tables with SQL.
  • Develop and maintain PDF/paper/Web/story maps.
  • Develop and maintain automated data flows.
  • Write software or scripts to automate repeatable tasks and workflows.
  • Strong verbal and written communication skills.
  • Attention to detail and quality.
  • Organized, and considerate of colleagues and common workspaces.

Education: An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Substitution: Experience in the information systems field, including technical support, content management, administration of network applications or system analysis may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Desirable Qualifications: The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred to hiring.

  •  At least one course, or equivalent, in using ArcMap or ArcGIS Pro is required.
  • At least one course, or equivalent, in using Structured Query Language (SQL), is required.
  • At least one year of address dataset analysis or GIS industry experience is preferred.
  • Experience with street address standards, parsing, standardization, and geocoding.
  • Knowledge of municipal and county government operations, generally.
  • Experience with the ArcGIS platform, including ArcMap, ArcGIS Pro, ArcGIS Online, ArcGIS Server, ArcGIS Enterprise, Portal for ArcGIS, and file and enterprise geodatabases.
  • Experience with relational databases, especially PostgreSQL/PostGIS, SQL Server, and Oracle and Oracle Spatial.
  • Experience developing software, particularly with Python, SQL, and PL/pgSQL or T-SQL or PL/SQL.
  • Experience with the FME platform, both Desktop and Server.
  • Experience with cartography and data visualization, including dashboard products (Power BI).
  • Experience with open-source software for geospatial (FOSS4G), for example QGIS.
  • Experience with Microsoft Office, particularly Word, Excel, and PowerPoint.


Why Work for the Department of Technology (DT)? The Department of Technology (DT) is the centralized technology services provider in CCSF. We deliver technology infrastructure and services to approximately 33,000 employees! With an annual operating budget of over $140M and approximately 260 employees, DT provides a host of services that includes:

People-Centered Solutions: Working for San Francisco, you can have a powerful, meaningful effect on the community every day. When we solve problems, people are the heart of every solution!

Benefits of Working for CCSF:  In addition to challenging and rewarding work, the City provides a generous suite of benefits to its employees.

  • Job security, pension, and robust retirement options
  • Competitive pay with consistent bi-yearly or yearly increases
  • Generous paid time off, family leave, and more!
  • Diverse work environment in a diverse city
  • Union protections and representation
  • Career development and growth — move between departments, learn on the job, or take subsidized/reimbursed classes!

CLOSING THE DIGITAL DIVIDE — bring the benefits of the internet to low-income and marginalized residents!

SHINE A LIGHT ON WHAT MATTERS — join an award-winning production team at SFGovTV to help residents watch legislators or learn more about what makes this City great!

DRIVE INNOVATION — deliver new, cutting-edge technology to residents and city partners to help San Francisco serve its residents!