Operations Data Analyst

Axelon

San Ramon, CA

JOB DETAILS
SALARY
$60–$80 Per Hour
SKILLS
Acceptance Testing, Access Control, Analysis Skills, Business Processes, Business Support, Change Control, Change Management, Communication Skills, Computer Science, Computer Security, Computerized Maintenance Management System (CMMS), Continuous Improvement, Customer Support/Service, Data Analysis, Data Management, Data Processing, Data Quality, Disaster Recovery, Documentation, Functional Testing, Hardware Upgrades, ITIL (IT Infrastructure Library), Identify Issues, Incident Management, Information Technology & Information Systems, Internet Security, Leadership, Linux Operating System, Microsoft IIS Web Server (Internet Information Services), Microsoft SQL Server, Microsoft System Center Operations Manager (SCOM), Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic.NET, Microsoft Windows Azure, Microsoft Windows Operating System, Network Configuration Management, Network Operations Center, On Call, Open Source, Operating Systems, Operational Audit, Operational Support, Oracle Database, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Python Programming/Scripting Language, Root Cause Analysis, SQL (Structured Query Language), Service Level Agreement (SLA), ServiceNow, Simulation, Software Administration, Software Patches, Software Upgrades, System Center Configuration Manager (SCCM), System Integration (SI), System Operations, Systems Maintenance, Test Strategy, Testing, Workload Automation, Writing Skills
LOCATION
San Ramon, CA
POSTED
8 days ago

Summary:

  • Location: San Ramon, CA
  • Duration: 6 Months
  • Work Mode: Hybrid (Remote with onsite as needed)

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.

Requirements:

  • 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:

  • 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.
  • 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.
  • Experience with Windows IIS, Kafka, and .NET applications.
  • 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.
AXEL01

About the Company

A

Axelon