Operations Data Analyst, Expert

Pacific Gas And Electric Company•Oakland, CA

5d•$120,000 - $200,000•Hybrid

About The Position

The Operations Data Analyst extracts and analyzes operations data to support leadership and respond to ad hoc requests. The role maintains operations tools and databases, keeping them current with data from PG&E systems, and develops, maintains, and enhances operational metric database tools for analytics teams. The Analyst identifies and resolves gaps in data requirements and accessibility to enable fast, consistent responses to leadership inquiries. The position manages data analysis projects from initial request through presentation of results, creates automated data routines and reporting processes, manages complex data extracts and transfers, and analyzes data using statistical tools. It develops clear, concise, actionable reports and presentations tailored to clients and audiences. The role also provides innovative recommendations for improving databases and data processes, acts as a team lead for less experienced employees, and works with Directors and Managers across functions to influence decisions. This is a hybrid individual-contributor position in PG&E’s Energy Delivery business unit, located in Oakland. The stated salary ranges are $126,000–$200,000 for the Bay Area and $120,000–$190,000 for California. The posting also notes participation in discretionary incentive compensation programs may be included.

Requirements

BA/BS degree in Marketing, Business, Computer Science, Engineering, or another related field, or equivalent work experience.
Six years of related work experience.
Advanced project management skills to lead cross-functional teams.
Advanced skill in Microsoft Power BI, including reports, visuals, and dashboards.
Strong knowledge of Palantir Foundry tools and data architecture.
Strong organizational, prioritization, and multitasking skills.
Influence skills.
Strong problem-solving skills.
Strong knowledge of Python, including numpy, matplotlib, pandas, geopandas, and pyspark.
Advanced skill in Microsoft Excel, including complex formulas, graphing, and VBA.
Advanced skill writing SQL queries using Oracle or Business Objects.

Nice To Haves

Master’s degree.
Familiarity with utility operations.

Responsibilities

Manage complex data analysis projects from initial requests through presentation of results, ensuring completion within budget and on time.
Design data analysis to meet business objectives; process and analyze data; communicate findings clearly and tailor communications to specific audiences.
Create automated routines and processes for reporting and data delivery, ensuring accurate data manipulation and cleansing.
Manage complex data extracts and list pulls, ensuring data accuracy, and transfer data from databases to analysts supporting operational analysis.
Use advanced statistical tools to develop complex ad hoc reports, statistics, trends, and profiles.
Apply broad expertise in data processing and analysis across different issues.
Recommend innovative solutions to enhance databases with new data sources and improved data processes.
Develop comprehensive reports and communicate clear, concise, actionable analyses for clients.
Prepare presentation materials that include analytics results, visualizations, and recommendations.
Act as team lead and provide direction to less experienced employees.
Work with Directors and Managers across functions to influence decisions.