Operations Data Analyst

Core 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 failures Investigate 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 standards Participate 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 Skills/Experience (Must-Haves) Bachelor's 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 processes Advanced 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 Skills/Experience (Nice-to-Haves) Familiarity with Microsoft Azure, Kubernetes (open-source), and Python Experience with Enterprise Asset Management (EAM) systems Familiarity 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 testing Understanding of cybersecurity compliance frameworks Additional Skills Strong 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 Proficiency in scripting languages such as PowerShell and Python for automation Strong 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 Proactive Problem Solving Collaboration and Stakeholder Partnership Accountability and Operational Excellence Location: San Ramon, CA Pay Range: The approximate pay range for this position is between $60.00 and $69.00 per hour. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums. Employee-Owned Profit Sharing (ESOP) 401K offered #J-18808-Ljbffr KellyMitchell Group