Job Description

Under the direction of the Data & Analytics Manager, the GIS Data Analyst will support the development and maintenance of various dashboards, maps, reports and other data products related to housing production, development pipeline, racial and social equity, and area plans monitoring. This role will also support the data preparation, analysis, and visualization (both geospatial and non-geospatial) related to internal and external data requests. This position will work cross-functionally with other data analysts, data engineers, and planners.

The essential functions of this position include but are not limited to: 

• Conducting data queries from variety of databases, and disparate spreadsheets, and performing data analysis, and creating data visualizations and maps for statutory reports;
• Developing streamlined dashboards, using PowerBI, Esri Dashboard, Experience Builder, or other dashboarding technologies, to support the Planning staff’s data and analytics needs;
• Working cross-functionally with data analysts, engineers, urban designers and planners to expand the Department’s GIS analytics capabilities (including ArcGIS Urban, ArcGIS Dashboards and StoryMaps); scopes and coordinates requests for data and geospatial analysis work products; and works with the Data and IT teams to develop GIS and data workflow improvements through automation, business process improvements and clear technical documentation;
• Developing and maintaining databases/datasets, incorporating data from various sources and publishing them to ensure continuous support to mission critical programs;
• Responding to geospatial data and map requests by performing queries from variety of data sources (databases/datasets).

Qualifications

MINIMUM QUALIFICATIONS

1. 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]. AND  
2. One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis. AND  
3. One (1) year of verifiable and recent experience in Geographic Information System (GIS) using ESRI products (Arcview, ArcInfo, ArcGIS, MapObjects, ArcIMS) performing analysis, design, development, testing, implementation, and production support for GIS applications.

The above minimum qualifications reflect special conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.  

SUBSTITUTION Additional experience as described above 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.

DESIRABLE QUALIFICATIONS The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

• Proficient with Excel
• Proficient with PowerBi, PowerApps and Experience Builder
• Fluent in SQL (ideally experience with Oracle and Microsoft SQL Server)
• Proficient in ArcGIS Pro, ArcMap, and ArcGIS Online
• Education or professional experience in urban planning
• Familiar with project review, entitlement, and permitting process
• Familiar with Python, including geopandas and arcpy

APPLICANTS MUST MEET THE MINIMUM QUALIFICATIONS REQUIREMENT BY THE FINAL FILING DATE UNLESS OTHERWISE NOTED.

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 http://sfdhr.org/index.aspx?page=456

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.

Additional Information

SELECTION PROCEDURES

After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

1. MINIMUM QUALIFICATION SUPPLEMENTAL QUESTIONNAIRE (MQSQ) - QUALIFYING Candidates will be sent an MQSQ via email as part of the employment application. Applicants will be required to respond to the MQSQ in the time frame indicated, and submit their answers as directed. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQs) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

2. SUPPLEMENTAL QUESTIONNAIRE EXAM (SQ) - WEIGHT 100% Candidates who meets the minimum qualification for this position will be sent a Supplemental Questionnaire (SQ) via email to complete and return. Applicants will be required to respond to the SQ in the time frame indicated, and submit their answers as directed.

The Supplemental Questionnaire is designed to determine relative knowledge, skills and ability levels in job related areas which may include, but not be limited to:  knowledge of the principles and practices of geographic information systems (GIS) and software (e.g. ArcGIS Suite), communication technologies, and cartographic methods and procedures; project management ability; problem solving ability; knowledge of the methods and techniques of database managemetn and design; and written communication ability.

The SQ will account for 100% of the total weight of the final score.

A passing score must be achieved on ALL components of the selection procedures in order to be placed/ranked on the score report. The department may administer additional position-specific selection procedures to make final hiring decisions.

ELIGIBLE LIST/SCORE REPORT: A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.

CERTIFICATION: The certification rule for the eligible list resulting from this examination will be RULE OF SEVEN (7). Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

The duration of the eligible list resulting from this examination process will be SIX (6) MONTHS, and may be extended with the approval of the Human Resources Director.

Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see:  Position-Counts-by-Job-Codes-and-Department-FY-2021-22.pdf (sfdhr.org).

ADDITIONAL INFORMATION REGARDING EMPLOYMENT WITH THE CITY AND COUNTY OF SAN FRANCISCO:

• Information About The Hiring Process
• Position Based Testing Information
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Seniority Credit in Promotional Exams
• Right to Work
• Copies of Application Documents
• Diversity Statement

TERMS OF ANNOUNCEMENT:

This is a Position Based Test conducted in accordance with Civil Service Rule 111A. Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations.  Clerical errors may be corrected and, if so, an amended note will be posted on this official job announcement.

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date

HOW TO APPLY:

To be considered, please submit a SmartRecruiters application and attach to your application:

• Cover Letter
• Resume

Applications for City and County of San Francisco jobs are ONLY accepted through an online process.

Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

QUESTIONS:  If you have any questions regarding this recruitment or application process, please contact the exam analyst, Michael Eng, by telephone at 628-652-7522, or by email at Michael.Eng@sfgov.org.

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.