Operational Data Analyst

Spectraforce Technologies, Inc.; San Diego (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Spectraforce Technologies, Inc. is seeking an Operational Data Analyst in San Diego, CA, to work on complex electric distribution and outage analytics.

You will design data views, build dashboards, and translate technical findings into actionable business recommendations for leadership. Ideal candidates bring 5+ years in data analytics within utility or operational domains, strong SQL skills, and experience with Oracle Utilities Analytics, NMS, and Power BI to support strategic decisions and

Qualifications

• Five or more years of progressive experience in data analytics or related roles.
• Strong experience with SQL, Oracle tools, and BI/reporting.
• Ability to independently analyze complex data, reconcile data across systems, and translate findings into decisions.
• Experience leading requirements discussions and documenting specifications.

Responsibilities

• Lead complex data requests by understanding source data relationships and refining SQL queries.
• Own recurring outage data audits to improve notifications and data quality.
• Design and build reports and dashboards using outage, customer, and operational data.
• Support outage trackers and integrations with cloud components or AWS environments.
• Analyze data to identify opportunities to improve customer experience and outage communications.

Skills

Analytical skills

SQL skills

Independent work

Data validation

Anomaly detection

Data-driven recommendations

Outage management

Communication

Education

High school diploma

Tools

Oracle Utilities Analytics (OUA)

NMS

Power BI

Power Query

DAX

XML

PL/SQL

Oracle Database

Microsoft Fabric

AWS

Job description

• Strong analytical and SQL skills with the ability to work independently across complex operational data sets, validate results, identify anomalies, and translate findings into actionable recommendations.
• Utility operations or outage management experience (recommended not required), especially familiarity with outage management, customer outage notifications, external outage map analytics, reliability data, or related utility operations data.
• Clear, executive-ready communication and collaboration skills, with the ability to explain complex technical information to both technical and non-technical stakeholders and influence decisions through data-driven insights.
• High school diploma required, bachelor's not required

Job Title: Operational Data Analyst

Duration: 24 Months

Location: San Diego, CA, 92123

Manager Preferred Qualities:

• Strong analytical and SQL skills with the ability to work independently across complex operational data sets, validate results, identify anomalies, and translate findings into actionable recommendations.


• Utility operations or outage management experience (recommended not required), especially familiarity with outage management, customer outage notifications, external outage map analytics, reliability data, or related utility operations data.


• Clear, executive-ready communication and collaboration skills, with the ability to explain complex technical information to both technical and non-technical stakeholders and influence decisions through data-driven insights.


• High school diploma required, bachelor's not required

Responsibilities

• Lead complex electric distribution, Network Management System (NMS), Oracle Utilities Analytics (OUA), and Customer Success data requests by understanding source data relationships, building, and refining SQL queries, validating results, and translating findings into actionable recommendations.


• Own recurring outage data audits to identify gaps, trends, and opportunities to improve customer outage notifications, internal processes, data quality, and supporting technology.


• Design and build reports, dashboards, and data views using outage, customer, operational, and other relevant data sources to support leadership decisions and operational performance monitoring.


• Support development of internal and external outage trackers, including integration with cloud-hosted components or AWS-based environments where applicable.


• Analyze Customer Success, customer outage notification, and external outage map data to identify opportunities to improve customer experience, including developing options and recommendations related to crew status information and other customer-facing outage map enhancements.

Desired Skills and Experience

• 5 or more years of progressive experience in data analytics, business systems analysis, database development, BI/reporting, software development, or application/data support roles, preferably supporting complex operational systems. Strong candidates with 7 or more years of highly relevant utility, outage management, customer operations, or operational analytics experience may also be considered.


• Senior-level experience developing reports, dashboards, data extracts, or analytics using SQL, Oracle tools, Power BI, or similar platforms, with strong working knowledge of SQL, relational data models, and Oracle Database concepts.


• Ability to independently analyze complex operational data sets, reconcile data across systems, identify anomalies, validate results, evaluate options, and translate findings into actionable business insights and recommendations.


• Experience leading requirements discussions, documenting functional or technical specifications, supporting user acceptance testing, creating user-friendly documentation, and advising stakeholders on data-driven decisions.


• Familiarity with outage management, Customer Success, customer outage notifications, external outage map analytics, reliability data, Oracle Utilities Analytics (OUA), Network Management System (NMS), SQL Developer, or related utility operations data preferred.


• Experience with PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, cloud data warehousing, or AWS-based data environments preferred.


• Strong executive-ready communication skills, with the ability to explain complex technical information clearly, summarize findings, and influence decisions with technical and non-technical audiences.