Operations Data Analyst, Expert

Description

The Operations Data Analyst extracts and processes operational data to support leadership, ad‑hoc requests, and the broader analytics team. Responsibilities include managing data‑management projects from request through delivery, creating automated data routines for accurate reporting, handling complex data extracts and transfers, and using statistical tools to develop reports, trends, and profiles. The role also involves enhancing databases with new data sources and providing clear, actionable insights to internal stakeholders.

• Manage complex data analysis projects with limited supervision, from initial request to presenting results.
• Design and execute data analyses to achieve business objectives, process data, and tailor communications to specific audiences.
• Create automated data routines and processes to ensure accurate data manipulation, cleansing, and reporting.
• Oversee complex data extracts and list pulls, guaranteeing data accuracy and delivering data to analysts for operational analysis.
• Analyze data using advanced statistical tools to produce ad‑hoc reports, trends, and profiles.
• Provide innovative solutions to enhance databases with new data sources and improved processes.
• Develop comprehensive reports and deliver clear, concise, actionable insights to clients.
• Act as a subject‑matter expert, guiding and mentoring less experienced employees.
• Collaborate with directors and managers across functions to influence decisions.

Requirements

• Minimum: BA/BS in Marketing, Business, Computer Science, Engineering or related field (or equivalent experience) and 6 years of relevant experience.
• Desired: Master’s degree or equivalent experience.
• Familiarity with utility operations.
• Advanced Microsoft Excel/Access skills, including complex formulas, graphing, and VBA.
• Advanced SQL query writing using Oracle or Business Objects.
• Advanced UNIX shell programming (csh, awk, sed, vi).
• Strong knowledge of SAS and Python programming.
• Excellent organizational, prioritization, and multitasking abilities.
• Strong problem‑solving and influencing skills.
• Advanced project management experience leading cross‑functional teams.

Benefits

This hybrid position works from a remote office and an assigned PG&E location within the service territory, with occasional reporting to San Ramon as needed. The salary range for this role is $122,000–$194,000 in the Bay Area or $116,000–$184,000 in California, with eligibility for discretionary incentive compensation programs.

Training + Development

Interview process

Visa Sponsorship

Security clearance