Data Operations Analyst

About Stem - Driven by human and artificial intelligence – Stem is unlocking energy intelligence.

Stem is a global leader reimagining technology to support the energy transition. Turning complexity into clarity, and potential into performance.
We help asset owners, operators and stakeholders benefit from the full value of their energy portfolio by enabling the intelligent development, deployment, and operation of clean energy assets. Our integrated software suite, PowerTrack, is the industry standard and best-in-class for asset monitoring, supported by professional and managed services, under one roof. Meant to tackle challenges as seamlessly as possible, Stem shows the information needed clearly and accurately and helps harness raw data to inform actionable insight. With global projects managed in 55 countries – from Germany to Japan and across North America – customers have relied on Stem for nearly 20 years to maximize the value of their clean energy projects.

Stem’s culture embodies diversity & inclusion beyond the traditional facets of gender, ethnicity, age, disabilities, and sexual orientation to include experience, personality, communication, workstyles, and more. At our core, Stem is at the momentous intersection of clean energy and software technology where diverse ideas, experiences, and professional skills converge to make the inclusive culture we have today. Together, we are turning old school thoughts about software and energy into progressive, collaborative, and innovative solutions. By joining our team, you will be collaborating with data scientists, energy experts, skilled salespeople, thought-leading executives and more from a range of backgrounds. This intersection of ideas, beliefs, and skills is what makes us unique enough to lead the world’s largest network of digitally connected energy storage systems.

What we are looking for:

Stem is seeking a detail-oriented and technically minded Data Operations Analyst to join our rapidly growing business operations team. The accuracy and timeliness of our data services is fundamental to Stem's service offering. You will play a key role in daily operations of our fleet of distributed energy resources by managing critical data imports from utility partners and ensuring data quality across all systems. This role offers significant opportunity to learn the energy storage business and develop expertise in utility data operations, while working with cutting-edge clean energy technology platforms.

Responsibilities:

• Daily Utility Data Imports: 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.
• Data Quality Monitoring: 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.
• Utility Authorization Management: 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.
• Utility Relationship Management: 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. Respond to utility communications regarding system changes or data format updates.
• Technical Operations Support: Work with EC2 servers, GroveStreams, and Python/SQL scripts to execute data import processes. Learn to use tools like Postman, WinSCP, and MySQL Workbench. Support ad-hoc data backfills when needed.
• Process Documentation: Maintain and update Confluence documentation for data import workflows, utility contact information, and troubleshooting procedures. Create training materials for team members on utility-specific import processes.
• Go-Live Support: Perform data quality validations for new sites preparing to go live. Verify meter provisioning and data availability before systems enter commercial operation.
• Performance analysis:  Learn and support Stem’s on-going performance analysis process and annual Performance Guarantee process; Take the lead in identifying opportunities for improvement in processes, tools, and contract language.

Required Qualifications:

• 1-3 years of experience in data operations, data analysis, or related technical roles
• Strong technical aptitude with ability to learn Python, SQL, and Linux/command line tools
• Technical experience with advanced Excel modeling including formulas, pivot tables, and data validation
• Exceptional attention to detail with demonstrated high degree of speed and data accuracy
• Strong quantitative analytical skills with demonstrated proficiency with technical concepts
• Strong organizational skills with ability to manage multiple daily tasks and coordinate across different utility timelines
• Excellent written and verbal communication skills for coordinating with utility partners and internal stakeholders
• Ability to work independently on routine tasks while knowing when to escalate issues
• Problem-solving mindset with systematic approach to troubleshooting data issues
• Willingness to learn about electricity markets, utility tariffs, and time-series data

Preferred Qualifications:

• Experience working with large datasets and data analysis using Python, SQL, Salesforce.com, Tableau and reporting tools
• Experience working with external partners or vendors
• Understanding and demonstrated interest in time-series data, electrical utilities, utility tariffs, and renewable energy
• Passion for leveraging AI to improve processes and data quality.

Education Requirements:

• Bachelor's degree in Engineering, Mathematics, Economics, Physics, Data Science, or related field, or equivalent experience

Location: US Remote in the Pacific or Mountain Time Zones

Salary Range

What We Offer: 

At Stem, you will work in a growing, innovative, mission-driven company with talented colleagues that have a passion for building renewable energy systems. Stem offers competitive compensation as well as a comprehensive set of benefits to support the health and wellness of our employee including:  

• A competitive compensation package, including eligibility for a bonus or commission based on the role, and equity
• Full health benefits on the first day of employment (several medical plan options-HDHP and PPO, dental plans, FSA/HSA-with employer contribution, employer paid vision/LTD/STD/Life, variety of voluntary coverage)
• 401k (pre- or post-tax) on first day of employment
• 12 paid calendar holidays per year
• Flexible time-off

Learn More

To learn more about Stem, visit our stem.com where you’ll find information about our solutions, technology, partners, case studies, resources, latest news and more. Here are some relevant links:

• Company Overview
• Newsroom
• Case Studies
• LinkedIn

Stem, Inc. is an equal opportunity employer committed to diversity in the workplace and does not discriminate against any employee or applicant for employment because of race, color, sex, pregnancy, religion, national origin, ethnicity, citizenship, sexual orientation, gender identity, age, marital status, disability, genetic information, military status, protected veteran status or any other factor protected by applicable federal, state or local laws.