Skip to content
 
 

Career Opportunity

GIS Analyst - Power Enterprise - SFPUC (1052) - (157136)

Recruitment: RTF0157135-01156745

Published: July 07, 2025

Contact:

Stefanie Lim - SMLim@sfwater.org

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

Department: Public Utilities Commission
Job class: 1052-IS Business Analyst
Salary range: $111,878.00 - $140,738.00
Role type: Permanent Civil Service What does this mean?
Hours: Full-time
Exam type: Position Based Test
Rule: Rule of 10
List type: Combined Promotive and Entrance
 

About:

This is a Position-Based Test conducted in accordance with CSC Rule 111A.

  • Application Opening: July 7, 2025
  • Application Filing Deadline: July 18, 2025
  • Recruitment ID: PBT-1052-157136; RTF0157135-01156745

WHO ARE WE? 
San Francisco Public Utilities Commission (SFPUC)
Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.

Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.

Our Vision: We are an innovative utility leader, recognized 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 https://www.sfpuc.gov

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. 

To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpuc

Role description

The Power Enterprise, within the SFPUC, has two separate power programs, Hetch Hetchy Power, San Francisco’s Publicly Owned Utility serving 150 MW of retail load, and CleanPowerSF, San Francisco’s Community Choice Aggregation program, serving 500+ MW of retail load. Power Enterprise serves this load with a combination of owned and purchased resources. SFPUC owns and operates the Hetch Hetchy Water and Power Project, which includes hydro-electric power generation in Moccasin, California; solar arrays throughout San Francisco; and biogas cogeneration facilities, which together produce cost-effective energy with a zero greenhouse gas (GHG-free) emission profiles. Both of these power programs’ supply portfolios exceed State minimum renewable content. Power Enterprise provides its retail customers with distributed energy resource programs. In addition to these retail electricity service offerings, Power Enterprise is responsible for San Francisco street and pedestrian lighting.

Under direction of the Power Enterprise's Asset Manager, this GIS Analyst will be responsible for:
Supporting and managing the Power Enterprise's Geographic Information System content, dashboards, reports, and maps related to electric utility transmission and distribution systems. The position will be expected to intake as-built documents and identify locations of assets and use the Power Enterprise standardized nomenclature to record in internal databases. Identification of assets and locations requires extensive coordination with engineering groups and utility field services to accurately document equipment and conditions. The position will coordinate and input asset info in Maximo, GIS, and SharePoint systems.

The essential duties of this position include, but are not limited to the following:

  • Manage Geographic Information System content, dashboards, reports, and maps related to electric utility transmission and distribution systems              
  • Assign and track asset and location ID numbers for electrical assets           
  • Working cross-functionally with engineers, field staff, and data analysts to obtain as-built information       
  • Developing and maintaining databases/datasets, incorporating data from various sources and publishing them to ensure continuous support to Operations             
  • Work with the Data and IT teams to develop GIS and data workflow improvements through automation, business process improvements and clear technical documentation            
  • Manage and ensure the asset data is accurate and consistent across all Asset Management databases (Maximo, GIS, and SharePoint)
  • Develop streamlined dashboards, using Power BI, ESRI Dashboard, Experience Builder, or other dashboarding technologies, to support the Power Enterprise staff’s data and analytics needs     
  • Responding to geospatial data and map requests by performing queries from variety of data sources (databases/datasets)
  • Related duties as assigned

How to qualify

Education: An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field]. AND

Experience: One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.

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 one of the fields above or a closely related field.

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

One year of full-time employment is equivalent to 2000 hours. (2000 hours of qualifying work experience is based on a 40-hour work week.) Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

Desirable Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.

  • Familiar with Electric Utility Operations            
  • Familiar with CMMS systems 
  • Familiar with Python and SQL
  • Proficient in ArcGIS Pro and ArcGIS Online
  • Familiar with ESRI Utility Network

Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education for considerations taken when reviewing applications. 

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 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 Procedures: After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

Supplemental Questionnaire Examination (Weight: 100%): Candidates who meet minimum qualifications will be invited via a separate link to complete the Supplemental Questionnaire Examination. The purpose of the Supplemental Questionnaire Examination 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: 

  • Knowledge of the principles and practices of geographic information systems (GIS) and software
  • Knowledge of database concepts pertaining to integration of GIS and asset management and document management systems
  • Knowledge of cartographic methods and procedures       
  • Ability to develop dashboards using dashboarding technologies such as Power BI and ESRI
  • Ability to communicate clearly, concisely and in a well-organized and effective manner, both orally and in writing 
  • Ability to establish and maintain effective working relationships with departmental staff, representatives of other agencies, and field staff

A passing score must be achieved on the Supplemental Questionnaire Examination in order to continue in the selection process and be placed on the eligible list.

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.

What else should I know?

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 of 12 months, and may be extended with the approval of the Human Resources Director. 

Certification: The certification rule for the eligible list resulting from this examination will be Rule of Ten Scores.

Terms of Announcement and Appeal Rights: 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 by the posting the correction on the Department of Human Resources website at https://careers.sf.gov/.

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.

Additional Information Regarding Employment with the City and County of San Francisco:

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

•    Select the “Apply Now” 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. 

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Stefanie Lim, at SMLim@sfwater.org or 415-916-6632.

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.