Skip to content
 
 

Career Opportunity

Address Dataset Maintenance Analyst- Department of Technology (1051)

Recruitment: RTF0128667-01095294

Published: November 22, 2022

Contact:

Carol Wong - carol.x.wong@sfgov.org

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

Department: Technology
Job class: 1051-IS Business Analyst-Assistant
Salary range: $87,724.00 - $110,344.00
Role type: Temporary Exempt What does this mean?
Hours: Full-time
 

About:

IMPORTANT: Your application MUST include responses to the supplemental questionnaire found here: https://forms.office.com/g/JPHz1bPyAb

Applicants must complete the supplemental questionnaire prior to starting the online application process. The application will not be reviewed without a completed supplemental questionnaire. 

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!

Role description

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.

JOB APPOINTMENT TYPE: 

One (1) temporary exempt, full time for up to a maximum of 1040 hours are excluded by the Charter from the competitive civil service examination process. The successful candidate shall serve at the discretion of the appointing officer. 

WORK LOCATION: 

Incumbent will conduct the majority of work at the Department of Technology, One South Van Ness Avenue, 2nd Floor. However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary.  

How to qualify

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.

Verification: “Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

What else should I know?

Compensation: 

$42.1750 -  $53.0500 (hourly) / $87,724 - $110,344 (annually)

How to Apply:

  • Your application MUST include a resume.  To upload, please attach using the "additional attachments" function.
  • You MUST fill out the supplemental questionnaire: https://forms.office.com/g/JPHz1bPyAb

You may contact Carol Wong via email at carol.x.wong@sfgov.org with questions regarding this opportunity.

Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States. 

Helpful Information

All your information will be kept confidential according to EEO guidelines.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.