Operations Data Analyst, Expert

PG&E•Oakland, CA

3d•Hybrid

About The Position

The Operations Data Analyst extracts operations data for analysis, leadership support, and 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 addresses gaps in data requirements and accessibility to enable fast, consistent responses to leadership inquiries. The position manages data projects from request through presentation of results; creates automated reporting and delivery processes; extracts and transfers data to support analysts; analyzes data using statistical tools; and communicates actionable findings. At the expert level, the analyst handles complex projects with limited supervision, develops innovative database and data-process improvements, prepares analytics presentations and visualizations, leads and directs less experienced employees, and works with Directors and Managers across functions to influence decisions.

Requirements

Bachelor’s degree in Marketing, Business, Computer Science, Engineering, or a related field, or equivalent work experience.
Six years of related work experience.

Nice To Haves

Master’s degree.
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.
Familiarity with utility operations.

Responsibilities

Manage complex data analysis projects from initial request through presentation of results, ensuring completion within budget and on time.
Design data analyses to meet business objectives; process and analyze data; write clear findings; 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.
Extract 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 data-processing and analysis expertise to a range of issues.
Recommend innovative database enhancements, including new data sources and improved processes.
Develop comprehensive reports and communicate clear, concise, actionable analyses to clients.
Prepare presentation materials containing 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.