Senior SysOps Engineer
Techdinamics Integrations Inc.
AWSCloudDockerKubernetesLinuxTerraformUnix
Data Operations Analyst
Stem, Inc.
full-time
Posted on:
Location Type: Remote
Location: Remote • Arizona, California, Colorado, Oregon, Utah, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $82,560 - $123,840 per year
Job Level
Junior
Tech Stack
EC2LinuxPythonSQL
About the role
- 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
Requirements
- 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
Benefits
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PythonSQLLinuxExcel modelingdata analysisdata operationsdata quality checksdata import processesSFTPdata validation
Soft skills
attention to detailorganizational skillscommunication skillsproblem-solvinganalytical skillsindependencecoordinationspeedtroubleshootingrelationship management
