Summer Intern, Account Services Data Analyst

Summer Internship, Account Services Data Analyst

Account Services - Redwood City, California (Hybrid)

Summer 2025

POSITION: Account Services Data Analyst Intern

Approximately 3 months duration

Open to Undergraduate ($25/hour) and Graduate students ($35/hour)

Peninsula Clean Energy has an Summer Internship opportunity available from June-September 2025 (exact dates in development). Requires CA residency and primary place of work to be within 100 miles of Redwood City, CA. Peninsula Clean Energy is a remote-first work environment. Employees will be expected to attend in-person meetings on a monthly to quarterly basis at the Peninsula Clean Energy office in Redwood City, CA. This position will also require periodic in-person meetings with representatives from commercial accounts and/or other stakeholders.

The Account Services Analyst Intern plays a key role within the PCE organization supporting customer operations. Responsibilities will include improving the function, usability, and design of Looker Studio dashboards for the Account Services team. This will support operations such as billing, key account management, and data analysis and will work closely with the Account Services team to understand their needs and incorporate their feedback into the dashboard design.

PROJECT DESCRIPTION

The goal of this project is to develop a comprehensive dashboard tool for the Account Services team. The tool will have various features that enable the Accounts Team to provide in-depth analysis and perform detailed comparisons, lookups, insights, and a variety of key metrics across Top200 strategic accounts, revenue, load usage, invoice billing, and volume pricing.

In this project, you will:

• Create a dynamic and interactive dashboard that aggregates and visualizes critical data for strategic accounts.
• Include detailed metrics such as revenue trends, usage volume, pricing models, and invoice/bill analysis.
• Enable easy access to data on each of the top strategic commercial customer accounts.
• Build a tool that improves decision-making, enhances customer relationship management, and enables performance analysis of key accounts.

QUALIFICATIONS

Essential Skills:

• Experience with SQL for extracting, manipulating, and aggregating data from databases.
• Ability to preprocess raw data and identify missing values or inconsistencies.
• Hands-on experience with visualization tools like Tableau, Power BI, or Looker.
• Ability to create dynamic, user-friendly interfaces for data presentation, including drill-down capabilities and multi-page dashboards.
• Ability to think critically about data problems and propose solutions to meet business needs.
• Strong focus on accuracy and consistency when working with large datasets and creating reports.
• Skill in documenting analysis processes and creating user-friendly guides for using the dashboard tool.

Desired Skills:

• Familiarity with data analysis libraries (e.g., pandas, matplotlib, seaborn) to conduct in-depth data analysis and create visualizations.
• Strong ability to analyze complex data sets and extract insights, trends, and patterns.
• Strong ability to identify Key Performance Indicators (KPIs).
• Familiarity with analyzing data related to customer accounts, including revenue, usage, and billing trends.

Education:

• Intern should be in progress of attaining a Bachelor's degree or Master’s degree in the field of sustainability, computer science, engineering or related field.

Application Deadline: Please submit by April 15, 2025. We will be holding interviews in April/May.

Application materials must include:

• Cover Letter

• Resume

We regret that we are unable to sponsor Visas at this time.

About Peninsula Clean Energy

Peninsula Clean Energy is the community choice energy program (known as a "CCA") for San Mateo County and portions of Merced County. Peninsula Clean Energy's customer base includes approximately 310,000 accounts, serving a population of 800,000, with a total electrical load of almost 4 million megawatt-hours.

Our mission is to reduce greenhouse gas emissions by expanding access to sustainable and affordable energy solutions. At Peninsula Clean Energy, we believe everyone deserves access to affordable, clean energy. We are committed to delivering electricity at lower rates to our local community while helping California build a more resilient, carbon-free power grid. We hold ourselves accountable to keep our energy rates stable and competitive, and we’re committed to a larger goal: provide our customers with 100% renewable electricity by 2030.

PCE is an Equal Opportunity Employer

PCE is committed to complying with applicable laws, including the Americans with Disability Act and Fair Employment and Housing Act, ensuring equal employment opportunities to qualified individuals with a disability. Peninsula Clean Energy prohibits unlawful discrimination based on age, sex or gender, genetic information or characteristics, gender identity, gender expression, race, color, ancestry, national origin, religion, creed, marital status, military or veteran status, sexual orientation, physical or mental disability, medical condition, or on any other basis prohibited by federal, state, or local laws.