Job Description

ABOUT CITY DISTRIBUTION DIVISION The San Francisco Public Utilities Commission’s City Distribution Division (CDD) is responsible for directing approximately 322 employees in the operation and maintenance of the water distribution system within the City and County of San Francisco. These activities include, but are not limited to: operating and maintaining 9 pump stations, (16 hydro stations), 13 reservoirs, 8 storage tanks, 20 regulators as well as other ancillary appurtenances and equipment; installing, repairing and maintaining 1,266 miles of water distribution mains including service connections and meters; four water systems (potable, ERWS, recycled, G.W.);  engineering and designing new main and feeder extensions; managing the flora and fauna on over 1,000 acres of city owned property and rights-of-ways; and responding to all two-alarm or greater fires to assist the Fire Department in maintaining adequate water volume and consistent pressure while fighting fires.

POSITION SUMMARY Under general direction, provides direct ongoing supervision to other IS Business Analysts, or serves as the top technical authority for one or more related specialties, or provides technical leadership and direction and assumes technical responsibility for the completion of major projects; performs or oversees all or most of the systems development life cycle and ongoing administration functions, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration; directs and participates in complex studies.

The essential job functions may include, but are not limited to, the following:

• Maintain and update CDD’s GIS databases, incorporating data from various sources and publishing the data into desktop and mobile applications to ensure continuous support to current mission critical programs.
• Define, implement, maintain and manage a GIS program for CDD, including developing policies and procedures and train end users.
• Manage GIS software integration projects.
• Identify GIS improvements in business processes through automation; make recommendations for new procedures and applications.
• Manage GIS software integration projects to expand end user access to GIS, by integrating the ESRI based GIS systems with other enterprise systems and making GIS data available on desktop and mobile devices. 
• Define GIS system requirements; design, code, test and debug systems; train users on new applications.  Maintain an enterprise which supports multi-user editing, with defined roles which give database privileges based on organizational roles. 
• Provide advice on the functionality of new programs and compatibility of modifications to ensure user needs are met. 
• Evaluate software and hardware products on multiple platforms; make recommendations for GIS compatibility, based on user requirements and systems analysis. 
• Incorporate data in a variety of data formats including .dwg, .kml, and ESRI geodatabases to develop products on for use on multiple platforms including ESRI’s ArcGIS Online and ArcGIS Server.
• Provide GIS base mapping for CDD Engineering projects.    
• Publish map services and create web maps using ESRI ArcGIS server and ArcGIS Online to be used on desktop and mobile applications.
• Design, deploy and maintain mobile GIS applications for use on phones and tablets, on both Android and IOS operating systems, for both viewing and collecting GIS data, to support field staff and mission critical programs.
• Perform other related duties as required.

Qualifications

If you are interested in this job, we are looking for people that have the following minimum qualifications:  

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].

EXPERIENCE: Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

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 ten (10) semester / fifteen (15) quarter units in computer science or a closely related field.

SPECIAL CONDITIONS:

• Two (2) years verifiable and recent experience in supervision or project lead of an IT project in a large-scale (multi-departmental) and with enterprise applications within information technology organizations.
• Two (2) years 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(s) to be filled. They may differ from the standard minimum qualifications associated with this class code.

VERIFICATION OF EDUCATION AND EXPERIENCE: 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 how-to-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.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. 

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

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

SELECTION PROCEDURE Applicants will be required to complete both a Minimum Qualifying Supplemental Questionnaire (MQSQ) and a Supplemental Questionnaire (SQ) Exam. Both sections must be completed by the application deadline. The MQSQ will determine if applicants meet the minimum qualifications for the position. The information provided on the qualifying questionnaire must be consistent with the information on the application and is subject to verification. 

SUPPLEMENTAL QUESTIONNAIRE EXAMINATION (WEIGHT 100%) The Supplemental Questionnaire is an exam and contents will be evaluated and scored.  The Supplemental Questionnaire Exam is to evaluate the experience, knowledge, skills and abilities that candidates possess in job-related areas which have been identified as critical for this position and include, but are not limited to: technical skills in GIS and ESRI, knowledge of programming languages, ability to publish services, and supervisory skills.

Candidates will be placed on the eligible list in rank order according to their final score. Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director. The department may administer additional position-specific selection procedures to make final hiring decisions. Candidates scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director. 

Additional Information

CERTIFICATION RULE: The certification rule for the ranked eligible lists resulting from this examination will be Rule of 7 Scores. 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. 

The duration of the eligible list resulting from this examination process will be 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.

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. [Note: The correction of clerical errors in an announcement may be posted on the Department of Human Resources website at https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ .] The terms of this announcement may be appealed under Civil Service Rule 110.4. Such appeals must be submitted in writing to the Department of Human Resources, 1 S Van Ness Avenue, 4th Floor, San Francisco, CA 94103-5413 by close of business on the 5th business day following the issuance date of this examination announcement. Information concerning other Civil Service Commission Rules involving announcements, applications and examination policies, including applicant appeal rights, can be found on the Civil Service Commission website at http://sfgov.org/civilservice/rules. 

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

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

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that are expected to be in effect until further notice. As a result, the Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

HOW TO APPLY: Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process. 

•    Select the “I’m Interested” button and follow instructions on the screen 

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. 

If you are having trouble with the application, please visit Smart Recruiter's FAQs or email supportfeedback@smartr.me. It is suggested you use Google Chrome or Microsoft Edge web browser to submit the application.  

EXAM ANALYST INFORMATION: If you have any questions regarding this recruitment or application process, please contact the exam analyst, David Jung at DJUNG@SFWATER.ORG.

PLEASE NOTE: 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.