Energy Billing & Data Analyst (Hybrid)

City of San Jose; San Jose (CA); Hybrid; USD 108,000 - 143,000; Full time

Job summary

City of San Jose is seeking an Energy Account Services Specialist I/II (Power Resources Specialist I/II) to join the Account Services, Marketing and Communications, and Customer Programs division. The role focuses on billing operations, data reporting, and rate support for San José Clean Energy (SJCE).

This hybrid position reports to the Senior Billing Operations & Data Manager and collaborates across departments.

Qualifications

• In-depth knowledge of California energy markets, utility rate structures, or similar.
• Strong analytical skills and ability to translate data into insights.
• Experience with data visualization, spreadsheet modeling, and report automation tools (Excel/SQL/Python/Power BI/Tableau).

Responsibilities

• Prepare and quality-check recurring reports for billing and customer programs.
• Develop dashboards and data visualizations to support cross-departmental decisions.
• Assemble and validate data for regulatory and compliance filings.
• Build and test automation for recurring reports and data pulls.
• Execute the annual solar true up process and coordinate billing analyses.
• Support program billing with SJCE’s billing service provider and data requests.

Skills

California energy markets

Data visualization

Spreadsheet modeling

Reporting automation

Education

Bachelor’s degree in a relevant field

Tools

Excel

SQL

Python

Power BI/Tableau

Job description

City of San Jose is seeking an Energy Account Services Specialist I/II (Power Resources Specialist I/II) to join the Account Services, Marketing and Communications, and Customer Programs division. The role focuses on billing operations, data reporting, and rate support for San José Clean Energy (SJCE).

This hybrid position reports to the Senior Billing Operations & Data Manager and collaborates across departments.