Strategic Operations Data Analyst

Pacific Gas and Electric Company; Oakland (CA); Hybrid; USD 126,000 - 200,000; Full time

Job summary

Pacific Gas and Electric Company in Oakland, CA, is seeking an Operations Data Analyst to extract and analyze operations data, maintain data tools, and support leadership with ad hoc requests. The incumbent develops, maintains, and enhances operational metric database tools for the broader analytics team.

The Analyst identifies and solves data gaps to ensure fast, accurate responses. The position follows a hybrid work model with onsite days in Oakland and Dublin.

Qualifications

• BA/BS degree required or equivalent work experience.
• Six years of related work experience.
• Master’s degree preferred.
• Advanced project management skills to lead cross-functional teams.
• Familiarity with utility operations.
• Advanced Excel/Access skills.
• Advanced SQL querying abilities.
• UNIX shell programming knowledge.
• Programming languages such as Visual Basic, Perl, C.

Responsibilities

• Manages complex data analysis projects with limited supervision on only the most complicated projects, from initial requests to presenting data results, ensuring the project is completed within budget and on time.
• Designs data analysis to achieve business objectives, processes data, analyzes data, writes clear and concise data findings, and tailors communications to specific audiences. Creates automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation and cleansing.
• Manages very complex data extracts and list pulls, ensuring data accuracy. Manages data extraction and transfers the data from databases to various analysts to support operational analysis efforts.
• Analyzes data using advanced statistical tools to develop complex ad hoc reports, statistics, trends, and profiles.
• Demonstrates and utilizes broad expertise in data processing and analysis and applies this knowledge to several different issues.
• Provides new and innovative solutions and recommendations to enhance database(s) with new data sources and improved data processes.
• Develops comprehensive reports and communicates clear, concise, and actionable data analyses for clients.
• Acts as team lead and provides direction to less experienced employees.
• Works with Directors and Managers across functions to influence decisions.

Skills

Project management

Stakeholder communication

Data analysis

Statistical tools

Leadership

Education

BA/BS Degree in Marketing, Business, Computer Science, Engineering, or related field

Six years of related work experience

Tools

Excel/Access

SQL queries (Oracle/Business Objects)

UNIX shell scripting

SAS

Visual Basic, Perl, C

Job description

Pacific Gas and Electric Company in Oakland, CA, is seeking an Operations Data Analyst to extract and analyze operations data, maintain data tools, and support leadership with ad hoc requests. The incumbent develops, maintains, and enhances operational metric database tools for the broader analytics team.

The Analyst identifies and solves data gaps to ensure fast, accurate responses. The position follows a hybrid work model with onsite days in Oakland and Dublin.