Heading

Oakland

Internship

Hybrid

$20.88/hr - $46.46/hr

Intern

Pacific Gas and Electric Company is seeking a Data Analysis, Insights & Automation Intern to support their Visual Management & Insight Services team. The role focuses on automating analytics and reporting workflows using the Microsoft Power Platform, while collaborating with stakeholders to enhance decision-making processes in Electric Risk & Compliance.

Apply Now

Responsibilities

Identify manual and repetitive analytical or reporting tasks within Electric Risk & Compliance
Design and build Power Automate flows to:
+ 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 to operating review cadence, leadership visibility, and compliance tracking
Document automated workflows, underlying logic, and dependencies to ensure long-term sustainment
Analyze Electric Risk & Compliance data to identify trends, risks, and improvement opportunities leveraging AI
Perform exploratory and ad hoc analysis to support stakeholder requests
Translate analytical findings into concise insights that can be operationalized or automated
Support root cause and trend analysis related to compliance performance
Use Power BI and Power Query to support automated data preparation and analysis
Support Power Apps (where applicable) to enable structured data input or workflow initiation
Partner with analysts to ensure automated outputs align with reporting and insight needs
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

Qualification

Required

Pursuing a Bachelor's, Master's or PhD degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Electric Engineering or related field 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

Preferred

Strong interest in automation, 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)
Experience identifying opportunities to replace manual processes with automated workflows
Strong analytical thinking with the ability to connect insights with automated processes
Strong communication skills to explain automated processes to nontechnical audiences
Comfortable collaborating with analysts and stakeholders to refine automation needs
Takes initiative and can work independently with minimal direction
Interest in risk, compliance, or regulated environments, particularly within electric utilities

Benefits

Pacific Gas and Electric Company, incorporated in California in 1905, is one of the largest combination natural gas and electric utilities in the United States.

Glassdoor