Advanced Metering Infrastructure (AMI) System Analyst (IS Business Analyst) - Customer Services Bureau (SFPUC) (1052) (159931) at San Francisco Public Utilities Commission in San Francisco, CA | USD111,878-140,738 | Kablio

Role

Description

tech research

data analysis

uat execution

troubleshooting

system monitoring

reporting

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

Requirements

sql

cognos

bi tools

master’s

reporting

stakeholder relationships

Ability to establish and maintain effective working relationships with staff, vendors, and stakeholders;
Verifiable and recent experience in SQL structured query language to access SQL server databases (12 months) AND
Knowledge of database and data management principles;
Experience in designing and configuring IBM Cognos (12 months)
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.
Ability to prepare clear, concise, and well-organized reports.

Benefits

ADA Accommodation
Seniority Credit in Promotional Exams

Training + Development

Information not given or found

Interview process

submit online application by the deadline.
if qualified, receive a link to complete the supplemental questionnaire examination (100% weight).
achieve a passing score on the questionnaire to remain in the selection process.
potentially complete additional position‑specific procedures such as interviews.

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded in 1932

Year of establishment

Originated during a push for municipal control, the agency began developing infrastructure to meet the growing needs of the city's population.

$700M Budget

Annual operating budget

Responsible for delivering water, treating sewage, and generating clean power through hydroelectric and solar initiatives.

100 Years of Power

Hydroelectric network history

The Hetch Hetchy Power system provides renewable energy to municipal services and the broader community through its century-old network.

It serves local retail water needs and supplies wholesale water to multiple Bay Area counties, supporting municipal buildings and transit systems.
It conducts large-scale infrastructure projects, such as pipeline construction, wastewater treatment modernization, and expanding the CleanPowerSF community-choice energy program.
It combines traditional utility planning with innovative pilot programs like stormwater retention and creek restoration to minimize runoff.
It uniquely integrates youth apprenticeships and workforce development across various trades, setting it apart from other utilities.
Its history is a testament to civic foresight, evolving from municipal takeovers of private water monopolies into a modern, sustainable public service provider.

Culture + Values

2,300 people

Team members

The team strives to work in harmony with environmental and community interests.

recognized throughout the world as a leading utility delivering high‑quality services through efficient, state‑of‑the‑art technologies
value our highly qualified and dedicated workforce ensuring vision becomes reality

Environment + Sustainability

100% Renewable Electricity

CleanPowerSF Achievement

Delivered to over 380,000 customers in 2023, two years ahead of the City’s 2025 target.

98% Emissions Reduction

GHG Reduction Progress

Achieved over nine years, cutting greenhouse gas emissions from electricity use by 98% from 1990 levels.

357M Gallons Recycled

Water Recycling Initiative

Treasure Island Water Resource Recovery Facility will recycle annually, reducing onsite water use by 98% and earning the Envision Platinum Award.

600+ Electric Parking Spaces

EV Charging Expansion

Electrified across 50+ projects through the EV Charge SF program.

Heat-pump water heater rebate providing $50/month credit for two years
Committed $80 million for Tuolumne River restoring 77 acres of salmon habitat and floodplain
Capture 1 billion gallons of stormwater annually via green infrastructure by 2050
Average water use per person is 42 gallons/day—about half the California average
City-wide net-zero sector-based greenhouse gas target by 2040

Inclusion & Diversity

SFPUC Community Benefits policy integrates environmental justice and workforce/economic development opportunities for diverse communities
Education of all staff on environmental justice and its integration into business decisions
Active member of Government Alliance for Racial Equity and host of racial equity training
Works with stakeholder boards/committees for diverse input and transparent accountability

Articles

Career Opportunities

SFPUC LinkedIn

Role

Description

tech research

data analysis

uat execution

troubleshooting

system monitoring

reporting

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

Requirements

sql

cognos

bi tools

master’s

reporting

stakeholder relationships

Ability to establish and maintain effective working relationships with staff, vendors, and stakeholders;
Verifiable and recent experience in SQL structured query language to access SQL server databases (12 months) AND
Knowledge of database and data management principles;
Experience in designing and configuring IBM Cognos (12 months)
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.
Ability to prepare clear, concise, and well-organized reports.

Benefits

ADA Accommodation
Seniority Credit in Promotional Exams

Training + Development

Information not given or found

Interview process

submit online application by the deadline.
if qualified, receive a link to complete the supplemental questionnaire examination (100% weight).
achieve a passing score on the questionnaire to remain in the selection process.
potentially complete additional position‑specific procedures such as interviews.

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded in 1932

Year of establishment

Originated during a push for municipal control, the agency began developing infrastructure to meet the growing needs of the city's population.

$700M Budget

Annual operating budget

Responsible for delivering water, treating sewage, and generating clean power through hydroelectric and solar initiatives.

100 Years of Power

Hydroelectric network history

The Hetch Hetchy Power system provides renewable energy to municipal services and the broader community through its century-old network.

It serves local retail water needs and supplies wholesale water to multiple Bay Area counties, supporting municipal buildings and transit systems.
It conducts large-scale infrastructure projects, such as pipeline construction, wastewater treatment modernization, and expanding the CleanPowerSF community-choice energy program.
It combines traditional utility planning with innovative pilot programs like stormwater retention and creek restoration to minimize runoff.
It uniquely integrates youth apprenticeships and workforce development across various trades, setting it apart from other utilities.
Its history is a testament to civic foresight, evolving from municipal takeovers of private water monopolies into a modern, sustainable public service provider.

Culture + Values

2,300 people

Team members

The team strives to work in harmony with environmental and community interests.

recognized throughout the world as a leading utility delivering high‑quality services through efficient, state‑of‑the‑art technologies
value our highly qualified and dedicated workforce ensuring vision becomes reality

Environment + Sustainability

100% Renewable Electricity

CleanPowerSF Achievement

Delivered to over 380,000 customers in 2023, two years ahead of the City’s 2025 target.

98% Emissions Reduction

GHG Reduction Progress

Achieved over nine years, cutting greenhouse gas emissions from electricity use by 98% from 1990 levels.

357M Gallons Recycled

Water Recycling Initiative

Treasure Island Water Resource Recovery Facility will recycle annually, reducing onsite water use by 98% and earning the Envision Platinum Award.

600+ Electric Parking Spaces

EV Charging Expansion

Electrified across 50+ projects through the EV Charge SF program.

Heat-pump water heater rebate providing $50/month credit for two years
Committed $80 million for Tuolumne River restoring 77 acres of salmon habitat and floodplain
Capture 1 billion gallons of stormwater annually via green infrastructure by 2050
Average water use per person is 42 gallons/day—about half the California average
City-wide net-zero sector-based greenhouse gas target by 2040

Inclusion & Diversity

SFPUC Community Benefits policy integrates environmental justice and workforce/economic development opportunities for diverse communities
Education of all staff on environmental justice and its integration into business decisions
Active member of Government Alliance for Racial Equity and host of racial equity training
Works with stakeholder boards/committees for diverse input and transparent accountability

Articles

Career Opportunities

SFPUC LinkedIn