Operations Data Analyst

Job Title: Operations Data Analyst, Career

Location: Oakland, CA 94612 / Sacramento, CA

Duration: 3 Months

Pay Rate: $45–$53/hour on W2

Work Arrangement: Hybrid – 2–3 days onsite per week

Work Authorization: Local candidates only

Job Summary

We are seeking an Operations Data Analyst to support data analytics, business intelligence, reporting, data governance, and records management initiatives. The ideal candidate will have experience working with complex datasets, developing dashboards, validating data accuracy, identifying trends, and providing actionable insights to support operational and business decisions.

The candidate should be proficient in tools such as Power BI, SQL, Microsoft Excel, and Power Platform, with strong analytical, problem-solving, and communication skills. Experience in utility operations, compliance, risk management, or audit-related environments is highly preferred.

Key Responsibilities

• Manage routine data analysis projects from initial requirements gathering through analysis, reporting, and presentation of results.
• Develop and maintain dashboards, reports, KPIs, and performance metrics using Power BI and other analytical tools.
• Perform data extraction, cleansing, validation, and manipulation to ensure data accuracy and consistency.
• Write SQL queries and manage data extracts to support operational analysis and business reporting.
• Conduct trend analysis, root cause analysis, and data validation to identify risks, discrepancies, and improvement opportunities.
• Support data governance, records management, audit readiness, and documentation standards.
• Maintain accurate trackers, folder structures, data logs, and logging taxonomies.
• Identify opportunities to automate data logging, reporting routines, and recurring data delivery processes.
• Collaborate with data management teams and business stakeholders to understand requirements and deliver reliable analytical solutions.
• Translate technical findings into clear, concise, and actionable insights for business teams and leadership.
• Ensure analytical deliverables are completed accurately, on time, and within established project requirements.
• Navigate ambiguous business problems, investigate discrepancies, and recommend process improvements.

Required Qualifications

• Bachelor's degree in Business, Marketing, Computer Science, Engineering, or a related field, or equivalent work experience.
• Minimum of 2 years of relevant experience in data analytics, operations analysis, business intelligence, or reporting.
• Experience developing dashboards, reports, and KPIs using Power BI.
• Proficiency in SQL queries and data extraction.
• Strong Microsoft Excel skills, including complex formulas, data analysis, and charting.
• Understanding of data modeling, data cleansing, validation, and reporting processes.
• Experience maintaining accurate records, trackers, and audit-ready documentation.
• Strong analytical thinking, critical reasoning, problem-solving, and attention to detail.
• Excellent communication skills, including the ability to present findings to technical and nontechnical stakeholders.
• Ability to work independently, manage competing priorities, and navigate ambiguity.

Preferred Qualifications

• Experience in utility operations, compliance, risk management, or operational data management.
• Knowledge of Microsoft Power Platform, including Power Apps and related automation tools.
• Experience with Microsoft Access, VBA, Oracle, or Business Objects.
• Experience with data governance, audit support, records management, and process documentation.
• Familiarity with statistical analysis, trend reporting, and root cause investigation.
• Knowledge of UNIX shell scripting, including csh, awk, sed, and vi.
• Familiarity with SAS, Visual Basic, Perl, or C programming languages.

Key Skills

• Power BI Dashboards and Reporting
• SQL and Data Extraction
• Microsoft Excel and Data Analysis
• Power Platform / Power Apps
• Data Modeling and Data Cleansing
• Data Governance and Records Management
• Audit-Ready Documentation
• Tracker Accuracy and Data Validation
• Trend Analysis and Root Cause Analysis
• KPI Development and Performance Reporting
• Logging Automation and Process Improvement
• Critical Thinking and Problem-Solving
• Stakeholder Communication

Work Arrangement and Equipment

• Candidates must be local to the Sacramento area or the Bay Area and able to work onsite at a Sacramento office or Oakland General Office (OGO) 2–3 days per week.
• A laptop will be provided. If equipment is delayed, candidates may need to use a personal device with Citrix access until the company laptop becomes available.

Ideal Candidate Profile

The ideal candidate is a detail-oriented Operations Data Analyst with strong BI and technical analytics skills, particularly in Power BI, SQL, and Excel. They should be comfortable validating complex datasets, maintaining audit-ready records, automating reporting processes, and translating data into actionable business insights. Candidates with utility, compliance, operations, or risk management experience are strongly preferred.