Operations Data Analyst: Power BI & Automation Specialist

Spectraforce Technologies; Oakland (CA); Hybrid; USD 48,000 - 83,000; Full time

Job summary

Spectraforce Technologies is seeking an Operations Data Analyst in Oakland, CA for a hybrid role. This contract position emphasizes dashboards, data governance, and analytics to support operational insights.

You will work with Power BI, SQL, Excel/Access, and SAS in a collaborative environment, delivering accurate reports and actionable recommendations. You will gather requirements, build data models, and help maintain KPI tracking while navigating ambiguity in a dynamic utility-like operations

Qualifications

• BA/BS in marketing, business, CS, eng or related field or equivalent work experience.
• 2 years of related work experience.
• Familiarity with utility operations.
• Excel/Access skills (complex formulas, graphing, VBA).
• SQL queries using Oracle or Business Objects.
• Develop dashboards with Power BI.
• Report metrics and KPIs.
• UNIX shell programming (csh, awk, sed, vi).
• Base SAS and VB/Perl/C programming knowledge.
• Able to analyze and interpret data and communicate findings.

Responsibilities

• Manage standard data analysis projects from request to results.
• Create automated data routines for reporting and data delivery.
• Transfer data from databases to analysts to support ops analysis.
• Analyze data using statistical tools to develop reports and trends.
• Develop clear, concise, actionable data analyses for clients.
• Maintain data governance and audit-ready documentation.

Skills

Data analysis

Problem solving

Critical thinking

Communication of findings

Ambiguity navigation

Excel basics

Education

BA/BS in related field

Tools

Excel/Access

SQL

Power BI

UNIX shell

SAS

Visual Basic/Perl/C

Oracle/Business Objects

Job description

Spectraforce Technologies is seeking an Operations Data Analyst in Oakland, CA for a hybrid role. This contract position emphasizes dashboards, data governance, and analytics to support operational insights.

You will work with Power BI, SQL, Excel/Access, and SAS in a collaborative environment, delivering accurate reports and actionable recommendations. You will gather requirements, build data models, and help maintain KPI tracking while navigating ambiguity in a dynamic utility-like operations