Data Analysis, Insights & Automation Intern

Requisition ID# 170651

Job Category: Internship / Rotation; Administrative / Clerical

Job Level: Individual Contributor

Business Unit: Strategy & Growth

Work Type: Hybrid

Job Location: Oakland

Department Overview

TheVisual Management & Insight Servicesteam supportsElectric Risk & Complianceby analyzing data, generating insights, andautomating repeatable analytical and reporting workflows using the Microsoft Power Platform.

The team partners with Electric Risk, Compliance, Audit, and operational stakeholders to reduce manual effort, improve insight timeliness, and enable consistent, scalable decision support in a regulated electric utility environment.

Our focus isautomating how insights are produced, refreshed, anddelivered-not just creatingone-timeanalyses.

Position Summary

The Data Analysis, Insights & Automation Internship position is part of theVisual Management & Insight Servicesteam supportingElectric Risk & Compliance. This role isheavily focused on Power Automate-driven automation, supported by Power BI and related Power Platform tools.

The intern will help:

• Explore and apply emerging AI-enabled tools and techniques to help streamline analytics, improve insight generation, and reduce manual effort in recurring reporting and analytical workflows.

• Identifymanual, repetitive analytical and reporting tasks

• Design and implementPower Automate workflowsthat standardize and automate insight delivery

• Improve reliability, consistency, and timeliness of recurring analysis

PG&E isprovidingthe hourly rate range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual hourly rate paid to an individual will be based on multiple factors, including skills, education, experience, market value, geographic location, and internal equity.

The hourly rate for this position ranges from$20.88 to $36.42.

Responsibilities

Automation & Workflow Development

• Identifymanual and repetitive analytical or reporting taskswithin Electric Risk & Compliance

• Design and buildPower Automate flowsto:

• • Trigger recurring data refreshes or analysis

• • Automate notifications, reminders, and status updates

• • Move and structure data between systems and tools

• • Standardize recurring insight and reporting outputs

• Support automation tied tooperating review cadence, leadership visibility, and compliance tracking

• Document automated workflows,underlyinglogic, and dependencies toensure long-termsustainment

Analysis & Insight Development (Supporting Focus)

• Analyze Electric Risk & Compliance data toidentifytrends, risks, and improvement opportunitiesleveragingAI

• Perform exploratory and ad hoc analysis to support stakeholderrequests

• Translate analytical findings into concise insights that can be operationalized or automated

• Support rootcause and trend analysis related to compliance performance

Power Platform Integration

• UsePower BI and Power Queryto support automated data preparation and analysis

• SupportPower Apps(where applicable) to enable structured data input or workflow initiation

• Partner with analysts to ensure automated outputs align with reporting and insight needs

Stakeholder Communication

• Work with Electric Risk & Compliance partners to understand where automation adds value

• Explain automated solutions, insights, and outputs to nontechnical stakeholders

• Prepare short summaries or walkthroughs describing what is automated, why it matters, and how outputs are used

Travel may berequired; frequency depends on the assignment and is typically less than 10%.

Qualifications

Minimum:

• Pursuing aBachelor's or Master'sdegreein Data Analytics, Business Analytics, Information Systems, Industrial Engineering, Computer Science at an accredited University
• Students must be continuing their education towards degree during and/or after the internship
• Must have reliable transportation to and from work location

Desired:

• Strong interest inautomation, process improvement, and scalable analytics

• Hands on experience or coursework using Microsoft Power Platform, especially:

• • Power Automate(workflow design, triggers, actions)

• • Power BI / Power Query(analysis and data preparation)

• • Power Apps(basic familiarity or interest)

• Experienceidentifyingopportunities to replace manual processes with automated workflows

• Strong analyticalthinkingwith the ability to connect insightswithautomatedprocesses

• Strong communicationskillstoexplain automated processes to nontechnical audiences

• Comfortablecollaborating with analysts and stakeholders to refine automation needs

• Takes initiative and can work independently with minimal direction

• Interest inrisk, compliance, or regulated environments, particularly within electric utilities

PG&E is unable to provide VISA sponsorship to students on an F1, J1 or other student visa for thisposition.