Data Operations Analyst (MDMS, AMI, SMART METER)

Data Operations Analyst III

San Ramon, CA

6 months contract

*Even though this role is listed as remote, candidates will need to come onsite as needed.*

• Key Responsibilities:Provide support for high-volume Gas AMI head-end system operations
• Analyze and resolve complex data quality issues, system defects, and integration failures
• Monitor and troubleshoot system performance and failuresInvestigate and resolve complex application job failures, including missed runs, long-running processes, data delays, and upstream/downstream impacts
• Partner with vendor and infrastructure support teams to drive continuous improvement initiatives
• Oversee and support integrations between the Gas AMI head-end system and the Meter Data Management System (MDMS)
• Execute comprehensive testing cycles (functional, performance, and operational readiness testing) for system changes, defect fixes, and new functionality
• Develop and contribute to test strategies in collaboration with the testing team
• Participate in projects such as hardware lifecycle upgrades, software upgrades, and backhaul network enhancements
• Develop and maintain system documentation, runbooks, and operational standardsParticipate in incident management, including ticket creation, root cause analysis, and coordination with infrastructure partners/vendors for resolution
• Provide 24/7 on-call operational support
• Perform vulnerability management, including OS patch certification and managing vulnerability remediation tickets to meet SLAs
• Required QualificationsBachelors degree in Information Systems, Computer Science, Engineering, or a related field
• 5 years of hands-on experience with Windows, Linux, MS SQL, Oracle, Kafka, VB.NET, and IIS, including 24/7 on-call application support
• Experience supporting AMI systems in a utility environment
• Strong understanding of smart meter technologies, interval data, and utility business processesAdvanced SQL expertise for troubleshooting, reporting, and data validation
• Experience supporting California Consumer Privacy Act (CCPA) compliance, including access controls and change management
• Excellent written and verbal communication skills, including the ability to communicate with executive leadership

• Preferred QualificationsFamiliarity with Microsoft Azure, Kubernetes (open-source), and Python
• Experience with Enterprise Asset Management (EAM) systemsFamiliarity with ITIL standards and tools such as ServiceNow, PagerDuty, SCOM, SCCM, and SecureApp
• Knowledge of AMI head-end systems and communication networks
• Experience with large-scale AMI deployments, including simulation testingUnderstanding of cybersecurity compliance frameworks
• Technical SkillsStrong hands-on experience with MS SQL (performance tuning, T-SQL development, data validation, and troubleshooting)
• Experience supporting applications on Windows and Linux platforms, including job monitoring and log analysis
• Experience with Windows IIS, Kafka, and .NET applications
• Proficiency in scripting languages such as PowerShell and Python for automationStrong troubleshooting skills across application, database, and OS layers
• Experience with enterprise workload automation tools (e.g., UC4/Automic)
• Experience supporting business-critical batch processing and time-sensitive data flows
• Experience with data center disaster recovery, including DR testing and exercises

Applicant Notices & Disclaimers

• For information on benefits, equal opportunity employment, and location-specific applicant notices, click here

At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's pay range is is: $65/hr - $68.97/hr.