Senior Ops Data Analyst - ETL & Dashboards (Hybrid, Oakland)

DataJobs; Oakland (CA); Hybrid; USD 69,000 - 96,000; Full time

Job summary

Global Software Resources is seeking a Senior Operations Data Analyst for a hybrid role based in Oakland, CA. The position supports operations-focused electrification planning across PG&E’s system through ETL development, automated reporting, and data analysis delivered via dashboards and ad hoc outputs.

You will build and maintain data pipelines spanning multiple core data environments, enabling screening and prioritization of electrification opportunities.

Qualifications

• BA/BS degree in Computer Science, Engineering, or related field, or equivalent work experience.
• 4 years of related work experience.
• Advanced Python skills (or similar languages) for data analysis and automation.
• Advanced SQL and database query skills to extract, transform, and analyze data from data environments.
• Advanced ETL design and maintenance experience for large datasets.
• Experience with data visualization and dashboarding tools.
• GIS experience preferred.
• Familiarity with utility operations.
• Ability to analyze and interpret data and effectively communicate findings.

Responsibilities

• Develop and maintain an ETL data pipeline across multiple core data environments to screen and prioritize electrification opportunities across PG&E’s system.
• Recommend ways to strengthen the data pipeline by introducing new data sources and improving data processes.
• Build automated data routines for reporting and data delivery, with a focus on accurate data manipulation and data cleansing.
• Create and communicate clear, concise, actionable analyses through dashboards and ad hoc reports.

Skills

Python

SQL

ETL design

Data visualization

Dashboards

GIS

Utility operations

Communication of findings

4 years experience

Education

BA/BS in CS/Engineering or related

Tools

Python

SQL

GIS

Job description

Global Software Resources is seeking a Senior Operations Data Analyst for a hybrid role based in Oakland, CA. The position supports operations-focused electrification planning across PG&E’s system through ETL development, automated reporting, and data analysis delivered via dashboards and ad hoc outputs.

You will build and maintain data pipelines spanning multiple core data environments, enabling screening and prioritization of electrification opportunities.