Utilities AMI Data Analyst (Staff Specialist-H)

City of Palo Alto; Palo Alto (CA); Remote; USD 125,000 - 150,000; Part time

Job summary

A municipal utilities department is seeking a part-time AMI Data Analyst to develop and maintain a SQL database containing metering information. Strong analytical skills and experience in SQL are essential. The role offers flexible hours and primarily remote work with occasional in-office requirements. Ideal for self-starters who can work independently and collaborate with cross-functional teams.

Qualifications

• Experience with AMI data analysis is highly preferred.
• Skills in writing queries and working with SQL databases required.

Responsibilities

• Develop and maintain a SQL Database containing AMI interval meter data.
• Write queries to extract and analyze data.
• Work with CPAU stakeholders to understand their informational needs.

Skills

Strong analytical skills

Creative problem-solving mindset

Skills in SQL database

Python

R

Excel

PowerPoint

Education

Bachelors degree in Data Science, Statistics, Engineering, or equivalent

Job description

The City of Palo Alto's Utilities Department (CPAU) is seeking a AMI Data Analyst (Staff Specialist-H) to assist with developing and maintaining an SQL database that will contain electric, water and natural gas metering information from CPAU’s Advanced Metering Infrastructure (AMI). The position will also support analysis of this information to guide decisions related to retail rate making, electric distribution system planning, and Distributed Energy Resource (DER) planning.

The ideal candidate is a self-starter with strong analytical skills and a creative problem-solving mindset, able to work independently while collaborating effectively with cross-functional teams.

Primary Responsibilities:

• Develop and maintain a SQL Database containing AMI interval meter data
• Write queries to extract and analyze data
• Work with CPAU stakeholders to understand their informational needs and provide data/analysis to meet their needs
• Work with non-AMI datasets as needed (e.g. SCADA, GIS, customer program data)

Minimum Qualifications:

• Bachelors degree in Data Science, Statistics, Engineering, or equivalent from an accredited University or College.
• Skills in using SQL database and writing queries, Python, R, Excel, PowerPoint.
• AMI data analysis experience highly preferred.

The position is part-time and on an on-call basis, with flexible work hours. The weekly time commitment will vary depending on project needs and the availability of the individual in this role. The position will primarily be remote, but the ability to come to our offices in Palo Alto periodically, as needed, is highly preferred. The initial term is 12 months, with the possibility of extension based on need and budget availability.

This is an SEIU Hourly (limited benefits) position that is budgeted to not exceed 1,000 hours per fiscal year.

The City of Palo Alto is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.