Advanced Metering Infrastructure (AMI) System Analyst (IS Business Analyst) - Customer Services Bureau (SFPUC) (1052) (159931)

This is a Position-Based Test conducted in accordance with CSC Rule 111A. Learn more about the City’s hiring process here: https://careers.sf.gov/knowledge/process/

Application Opening: November 6, 2025

Application Deadline: The job ad will close at 12:00 am PST on November 15, 2025. Applications must be submitted by 11:59 pm PST on November 14, 2025.

Salary Range: $111,878-$140,738 Annually

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

Becoming a City employee means being a part of a team that cares about making a difference. Your work will shape both the present and future of San Francisco. When you work for the City, you’re choosing a job with purpose.

Under general direction of the Advanced Metering Infrastructure (AMI) Operations Manager, the 1052 AMI System  Analyst will oversee key aspects of the AMI systems and operations. This includes system analysis, business process support, vendor coordination, backlog curation, root cause analysis of meter performance issues, provisioning and maintenance of AMI endpoints, User Acceptance Testing (UAT), contract administration, and the development of reports and analytics. This position will serve as a Subject Matter Expert (SME) in AMI operations and functions as a key liaison across business units, vendors, and field operations to ensure accurate data, reliable system performance, and effective utilization of AMI technology.

Essential Functions:

• Prioritize field work assignments and curate a large backlog of field activities;
• Analyze AMI data and evaluate vendor software and integrations to support departmental goals and regulatory requirements;  
• Conduct pilot programs and evaluate vendor products to ensure AMI systems meet operational and strategic objectives;  
• Monitor AMI system maintenance and enhancements, ensuring data integrity, system reliability, and compliance with standards; 
• Troubleshoot AMI system and data issues, providing technical support, analysis, and recommendations for resolution;
• Develop and execute user acceptance testing (UAT) for AMI systems and upgrades; document and track outcomes;  
• Research and evaluate emerging AMI technologies and industry practices; identify opportunities for improvement and innovation; 
• Generate reports and analytics to support billing, operations, and executive decision-making.  
• Develop and maintain AMI documentation, including business processes, procedures, technical configurations and reports; 
• Provide training to users and stakeholders on AMI processes and tools;  
• Represent the department at vendor meetings, cross-departmental workgroups, and industry committees related to AMI;  

The 1052 IS Business Analyst will perform other related duties as assigned.

Please note that incumbents in this classification may be required to perform duties as listed in the class specification, which can be found on DHR’s website: https://careers.sf.gov/classifications/

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.

Special Conditions: 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.

• Verifiable and recent experience in SQL structured query language to access SQL server databases (12 months) AND
• Experience in designing and configuring IBM Cognos (12 months)

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.

• Proficiency in SQL, including the ability to write, optimize, and troubleshoot queries.
• Experience with IBM Cognos Analytics or a comparable business intelligence/reporting tool (e.g., Tableau, Power BI, SAS).
• Master’s degree in Computer Science, Data Science, Business Administration, Information Systems, or a closely related field. 

Verification of Education and Experience:

Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Review SF Careers Employment Applications for considerations taken when reviewing applications.

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://careers.sf.gov/knowledge/experience-education/.

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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

Additional Information:

Selection Procedure:

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 database and data management principles;
• Ability to establish and maintain effective working relationships with staff, vendors, and stakeholders;
• Ability to prepare clear, concise, and well-organized reports.

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

To find Departments which use this classification, please see the city’s Position Counts by Job Codes and Departments.

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

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.

• Information About the Hiring Process
• 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

Where to Apply

All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit https://careers.sf.gov/ to begin your application process.

Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor and at the City Career Center at City Hall, 1 Dr. Carlton B. Goodlett Place, Room 110.

Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and preferred names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.

Applicants will receive a confirmation email from [email protected] 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 have any questions, you may contact Linda Muir at [email protected].

Recruitment ID: PBT-1052-159931

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.