1054 IS Business Analyst-Principal (GIS - CDD)

Recruitment #TEX-1054-100519



This is a Temporary Exempt (TEX) position not to exceed thirty six (36) months. This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.

Headquartered in San Francisco, we have 2,300 employees working in seven counties with a combined annual operating budget of over $900 million.

OUR MISSION: to provide our customers with high quality, efficient, and reliable water, power and wastewater services in a manner that is inclusive of environmental and community interests, and that sustains the resources entrusted to our care.

OUR VISION: We are an innovative utility leader, recognize for excellent results in service, safety, stewardship, and inclusiveness. We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at www.sfwater.org

We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality. As you explore career opportunities with us, download our career guide and learn about what you can expect during the hiring process.

GIS implementation and management project focus will be defining, implementing, maintaining and managing GIS software system. In phase 1: the incumbent will be responsible for managing & maintaining the newly migrated GIS data in the enterprise database. In phase 2, the incumbent will be responsible for coordinating with PUC IT about the configuration of ArcGIS Enterprise & any relevant server technology. In phase 3, the incumbent will be responsible for managing the GIS side of any enterprise systems integrations project. In phase 4, the incumbent will  be responsible for creating and managing a GIS program at CDD. This entails implementing standard operating procedures and change management workshops for consistent GIS practices; improving the GIS on-boarding process for new hires; administering licensing of all GIS software to CDD staff.

Under general direction of a senior engineer, this position provides technical leadership for the completion of major Geographic Information System (GIS) projects within the City Distribution Division.  This position manages all of CDD’s GIS systems, and serves as the top technical authority for: the geospatial business program development, solution architecture and design, large-scale enterprise systems integrations, project planning and management, development life cycle support, and technology and software assessment. The GIS manager requires skills in GIS planning, system design, and system administrations as well as possess hands-on, technical GIS skills.   This position also performs ongoing administrative functions including the following:  Needs analysis, cost-benefit analysis, structured systems analysis, feasibility analysis, technology and software assessment, project planning and management, system installation, implementation and testing, technical and procedural documentation, user training, and post-implementation assessment and administration, defining GIS program goals, hiring and supervising staff, procuring software and hardware, managing GIS projects including the designing and deploying of applications, maintaining and updating CDD databases, incorporating data from various sources, publishing data into desktop and mobile applications.

WORK LOCATION: There is currently one (1) position available. The positions are with the City Distribution Division (CDD) of the Water Enterprise and is located at CDD Business Office, 1990 Newcomb Avenue, San Francisco, CA.

According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.
• 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.
• Maintain An enterprise which supports multi-user editing, with defined roles which gives database privileges based on organizational roles.  

EQUAL EMPLOYMENT OPPORTUNITY: 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.



Minimum Qualifications

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.  Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.

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

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

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

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted. All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included in the “Education” and “Training and Employment Record” sections of the City and County of San Francisco online application by the filing deadline. A resume does NOT substitute for this section of the City application and will not be considered in determining whether you meet the minimum qualifications.

• 5+ years of experience in geospatial technology with design, implementation and administration of Esri ArcGIS Platform
• 1+ years of GIS experience in a public utility organization
• 1+ years of experience with installation and administration of RDBMS (Oracle)
• 1+ years of experience integrating GIS to other enterprise business systems

Verification: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. 

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.

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.

Verification of required work experience typically must be on the employer’s letterhead, and must include the applicant’s name, job title, description of job duties, dates of employment, hours per week, and signature of the employer, supervisor, or appropriate representative.  Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. CCSF employees will not receive credit for experience obtained outside of their classification unless recorded in accordance with the provisions of the Civil Service Rule 110.9.1/111A.11.2. 

Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted.    

Verification of required valid licensure/certification typically must be a photocopy of the license/certificate including the name of the issuing agency as well as the name of the license/certificate holder, license/certificate number, and expiration date.

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.
• Select the desired job announcement
• Select “Apply” and read and acknowledge the information
• Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
• Follow instructions on the screen 

Need help completing the application?
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 is expected to be in effect until further notice.  As a result, 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.

We communicate by email.
You may be contacted by email about this announcement and, therefore, it is your responsibility to ensure that your registered email address is accurate and kept up-to-date.  Also, you must ensure that email from CCSF is not blocked on your computer by a spam filter.  To prevent blocking, you should set up your 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. You will receive a confirmation email that your online application has been received in response to every announcement for which you apply.  You should retain the confirmation email for your records.  Failure to receive the email means that the online application was not submitted or received.

Word of advice.
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.

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

Have questions about the application process?
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Jonathan Pettey, by email at jpettey@sfwater.org

Selection Procedures

Applicants will be prompted to complete a Qualifying Questionnaire (MQSQ) as part of the online application process. All applicants must complete the MQSQ and it must be submitted with the application by the final filing deadline. The information provided on the Supplemental Questionnaire must be consistent with the information on the application and is subject to verification. Applicant responses to the Supplemental Questionnaire will be used to assist in determining if applicants meet the minimum qualifications for the position.

Only those applicants who most closely meet the needs of the Department will be invited to continue in the selection process. Applicants meeting the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine applicants’ qualifications.

Conviction History

If you receive a conditional offer of employment, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you were given a conditional offer of employment. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

·         Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.

·         Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you receive a conditional offer of employment, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


Reasonable Accommodation Requests: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities

General Information concerning City and County of San Francisco Employment Policies and Procedures: http://www.sfdhr.org/index.aspx?page=20

Copies of Application Documents: http://www.sfdhr.org/index.aspx?page=20#copies

Right to Work: http://www.sfdhr.org/index.aspx?page=20#identification All person entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.


07/10/2020 - Announcement Extended
1054 - Temporary Exempt
Issued: 06/26/2020
Recruitment No.: TEX-1054-100519
Micki Callahan, Director
Department of Human Resources
team: PUC/JP jpettey@sfwater.org



All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.


Powered by JobAps