Stem, Inc.

Operations

• Execute and monitor daily imports of utility interval meter data and billing data from California utilities (SCE, PG&E, SDG&E) and other utility sources including UtilityAPI, Green Button, APX, and MV90 systems
• Ensure data completeness, accuracy, and timeliness of all data feeds
• Run systematic data quality checks on live systems to identify missing data, anomalies, or data feed interruptions
• Document issues and coordinate resolution with utilities and internal teams
• Monitor automated email alerts and respond to data quality flags
• Coordinate with Customer Operations to facilitate utility data authorizations
• Work with utility representatives to set up new data connections, verify Service Account IDs (SAIDs), and configure Usage Point UUIDs in Salesforce for Green Button authorizations
• Serve as a point of contact for utility partners, particularly California IOUs
• Coordinate with utility account representatives to troubleshoot SFTP connections, resolve data delivery delays, and maintain positive working relationships
• Work with EC2 servers, GroveStreams, and Python/SQL scripts to execute data import processes
• Maintain and update Confluence documentation for data import workflows, utility contact information, and troubleshooting procedures

Data Operations Analyst