Hybrid Operations Data Analyst: Excel, SQL & Power BI

Pacific Gas and Electric Company; San Ramon (CA); Hybrid; USD 90,000 - 136,000; Full time

Job summary

Pacific Gas and Electric Company is seeking an Operations Data Analyst in San Ramon for a hybrid role. You will extract and analyze operations data, maintain data tools, and respond to leadership inquiries with clear metrics.

The role requires a BA/BS and 2 years of experience, with advanced Excel/Access, Power BI, SQL, and Python skills. You will work with data teams to develop reliable data pipelines and actionable insights for stakeholders.

Qualifications

• BA/BS degree in Marketing, Business, Computer Science, Engineering or related field or equivalent work experience.
• 2 years of job-related experience.

Responsibilities

• Manage standard, routine data analysis projects with limited supervision from initial request to presenting data results ensuring that the project is completed within budget and on-time.
• Work with other Data Management Analysts to process data, analyze data and report findings. Create automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
• Manages standard data extracts and list pulls ensuring accurate data. Transfers the data from databases to various analysts to support operational analysis efforts.
• Demonstrates full understanding of data processing and analysis techniques. Analyzes data using various statistical tools to develop ad hoc reports, statistics, trends and profiles.
• Develops and communicates clear, concise and actionable data analyses for clients.

Skills

Excel/Access

Power BI

SQL

Python

Data analysis

Project management

Communication

Education

BA/BS or related field

Tools

Snowflake

Foundry

Job description

Pacific Gas and Electric Company is seeking an Operations Data Analyst in San Ramon for a hybrid role. You will extract and analyze operations data, maintain data tools, and respond to leadership inquiries with clear metrics.

The role requires a BA/BS and 2 years of experience, with advanced Excel/Access, Power BI, SQL, and Python skills. You will work with data teams to develop reliable data pipelines and actionable insights for stakeholders.