Job Details

Primary Job Title:
Operations Data Analyst

Alternate / Related Job Titles:
Senior Data Analyst
Business Data Analyst
Operations Reporting Analyst
Data & Analytics Specialist

Location & Onsite Flexibility:
Oakland, CA - Hybrid (Onsite 1 day per week required)
Only candidates currently local to and residing in the Oakland / Bay Area will be considered

Contract Details

Position Type: Contract
Contract Duration: 12 Months
Start: As Soon As Possible
Pay Rate: $40 - $48 per hour

Position Summary

The Operations Data Analyst (Senior-level) reports to the Manager of Smart Meter Programs. This role is responsible for extracting data, developing actionable insights, and supporting leadership initiatives through advanced analysis. The analyst will respond to ad hoc data requests and maintain operational tools and databases using data from multiple internal systems.

This position partners closely with accounting, program management, resource planning, field operations, and IT teams to deliver data-driven business solutions, automate workflows, and support project success across multiple domains.

Key Responsibilities

• Manage, monitor, and optimize ETL processes using SQL Server Integration Services (SSIS)
• Design and maintain complex automated data routines for reporting and data delivery, ensuring accurate data cleansing and transformation
• Analyze existing processes and recommend process improvements
• Maintain and enhance Power BI dashboards and reports used by multiple business units
• Perform root cause analysis with a strong debugger mindset to resolve data and system issues
• Translate technical issues and findings into clear, actionable insights for non-technical stakeholders
• Collaborate cross-functionally to gather requirements and deliver technical solutions
• Assist with database administration, performance tuning, and troubleshooting complex SQL queries
• Support data integrity, data quality, and data governance initiatives
• Maintain and update technical documentation for knowledge sharing and compliance

Top Skills & Experience Required

Required Skills

• SQL Server (Advanced T-SQL)
• SSIS package development
• Data cleaning and transformation
• ETL process management
• Power BI reporting and dashboard development
• Root cause analysis and troubleshooting
• Strong communication and stakeholder collaboration skills

Preferred / Desired Skills

• Power Automate
• Power Apps
• Python

Additional Qualifications

• BA/BS in Computer Science, Information Systems, Business, Engineering, or related field
  OR equivalent professional experience
• Minimum 3+ years of hands-on experience working with relational databases (SQL Server preferred)

Equipment & Work Requirements

• Company laptop will be issued
• Any additional equipment is the responsibility of the supplier
• With manager approval, a pre-determined monthly stipend for cell phone and internet may be expensed

Benefits

• Medical Insurance
• Dental Insurance
• Vision Insurance
• 401(k) Retirement Plan

About the Company

A leading natural gas and electric energy provider serving millions of customers across the United States. The organization is committed to reliable energy delivery, operational excellence, and fostering a collaborative, community-focused work environment.

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company based in Alaska. GTT proudly supports diverse and inclusive workplaces and partners with Fortune 500 organizations across banking, financial services, technology, utilities, life sciences, biotech, and retail sectors throughout the U.S. and Canada.

Job Number:
26-00524