Utilities AMI Data Analyst (Staff Specialist-H)

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

Job summary

A municipal authority in Palo Alto is seeking a part-time AMI Data Analyst to develop and maintain an SQL database for metering information. The role involves strong analytical skills and collaboration with cross-functional teams. Candidates should have a Bachelor's degree in a related field and experience with SQL and data analysis. Flexible hours and remote work options are available.

Qualifications

• Strong analytical skills with a creative problem-solving mindset.
• Ability to work independently and collaboratively with teams.
• Experience with AMI data analysis highly preferred.

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

SQL database skills

Analytical skills

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. If you have problems while applying online, please contact NeoGov's Live Applicant Support at [phone] between 6:00 AM and 5:00 PM Pacific Time, Monday - Friday.

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.