Data Analytics Intern

About Silicon Valley Clean Energy

Formed in 2016, Silicon Valley Clean Energy (SVCE) is a public Community Choice Energy service provider serving approximately 270,000 residential and commercial customer accounts in thirteen Santa Clara County communities. SVCE's mission is to provide customers with renewable and carbon-free electricity at competitive rates, and further accelerate decarbonization through deployment of innovative local programs. Key program areas include: building electrification, electric vehicles and charging infrastructure, battery storage and demand management programs. Since the organization's service launch in 2017, SVCE has provided clean to all residential and commercial energy customers in SVCE's member communities, carbon-free electricity. SVCE has saved its customers more than $90M and dedicated $84M to customer offers, programs and services. SVCE is a joint-powers agency governed by a Board of Directors comprised of an elected official from each of SVCE's thirteen member communities.

By providing reliable and responsive carbon-free electricity service at competitive rates, SVCE maintains a 96+% customer participation rate and a strong financial foundation. Access to carbon-free electricity has helped our communities take a major step in fighting climate change, reducing local emissions by more than 30% from a 2015 baseline. Yet supplying clean electricity is just the start. It is essential that SVCE continues to proactively engage with our customers and community stakeholders in the electrification journey - helping to inspire, educate, and enable action in transitioning from fossil fuels to clean electricity – in homes, buildings, and transportation.

The SVCE Culture

Achieving SVCE's ambitious and urgent mission requires a team capable of meeting the tremendous challenges embedded in these goals. SVCE develops and fosters a diverse and talented team that thrives in a dynamic and fast-changing environment. As such, at SVCE we recruit and retain smart, passionate, innovative, and collaborative employees. Company employees contribute, as a team and as individuals, to continuously building and supporting a culture of collaboration and trust. SVCE employees encourage creativity and the free flow of ideas to spur innovation. The workplace environment is adaptable, and technology enabled to drive innovative solutions. SVCE emphasizes focus and prioritization across departments to achieve quality, rather than simply quantity of output. SVCE provides a rewarding workplace experience where productivity can be maintained across a variety of work environments. SVCE provides opportunities for growth, engagement, and support professional and personal development. SVCE offers opportunities that position their people, as well as SVCE, for success.

More information can be found at: www.svcleanenergy.org

About The Role

The Data Analyst Intern plays a key role within Risk, Analytics, and Data team supporting strategic analyses and reporting that will help guide decisions throughout the agency. The Intern's main tasks will be to develop 1-2 high impact reports in Microsoft PowerBI. To support this task, the Risk, Data, and Analytics Intern will leverage SVCE's cloud-based energy data warehouse (RADaR) that contains demand and supply side data as well as identify and obtain any other additional data sources. They will engage with key SVCE staff across departments to expand upon existing reporting or to develop a new user-friendly, interactive dashboard that marries key insights between the two sides of SVCE's functions.

Responsibilities will include leveraging data within SVCE's cloud-based energy data warehouse, identifying and obtaining other additional data sources, conducting analysis to answer a question or set of questions, and effectively synthesizing the data in a PowerBI dashboard. The following includes a list of sample analyses the intern may focus on during the internship.

• Location: this is a hybrid role in Sunnyvale, CA.
  
  

Sample Analyses

• Expanding the Greenhouse Gas Inventory reporting to include an interactive dashboard updating fugitive gas emissions methodology, and quantifying emissions associated with refrigerants within SVCE's service area
• Developing a prototype dashboard and conducting affordability analysis related to historical and projected rates, changing electricity bills overtime, and energy consumption
• Analyzing interconnection technology adoption in SVCE territory throughout time
• Characterizing load profile shapes for different groupings of customers (member agency, rate, NEM status, EV preference, etc.)
• Creating interactive dashboards from SVCE's static slides which is a repository of data, maps, charts, and key stats describing SVCE's territory emissions, energy consumption, interconnectivity, equity, and more
  
  

Qualifications

Skills

• Proficiency in coding and analyzing complex, large data sets using R or Python to extract insights and trends
• Experience with SQL for extracting, manipulating, and aggregating data from databases
• Experience with data visualization tools such as PowerBI, Tableau, Looker Studio, Shiny/RShiny, etc.
• Familiarity with version control with Git/GitHub and coding best practices
• Experience with documenting analysis processes
• Ability to think creatively and critically while approaching data-driven analyses
• Self-directed and strong organizational skills to be successful within a fast-paced team
• Excellent written and oral communication skills, including distilling complex information in a simple and understandable manner
• Strives to achieve excellent competency in SVCE's core competences – collaboration, effectiveness, continuous learning, and stakeholder service
  
  

Education

• Rising senior, post-graduate, or graduate student in a relevant quantitative field such as:
• Engineering
• Math
• Science
• Economics
• or related field.
• Current students should be in good academic standing.
  

Physical and Working Conditions

The physical and mental demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.

Environment: Work is performed in a typical office setting with exposure to computer screens and at public events (fairs, meeting rooms, farmers' markets, etc.) with moderate noise and will require some evening and weekend work. The noise level in the work environment is usually typical of an office environment and public events.

Physical: While performing the duties of this class, employees are regularly required to sit, walk, and stand; talk or hear, in person and by telephone; reach with hands and arms. Employees are occasionally required to walk, and stand for prolonged periods; stoop, bend, kneel and twist; and may lift up to twenty pounds. Employees must be able to communicate in person, in writing, and by telephone with Board members, management, co-workers, vendors, consultants, and with the public in face-to-face, one-on one, and group settings.

Vision: See in the normal visual range with or without correction; vision sufficient to read computer screens and printed documents; and operate assigned equipment.

Hearing: Hear in the normal audio range with or without correction.

-----SVCE IS AN EQUAL OPPORTUNITY EMPLOYER-----

The Pay Range For This Role Is

$25 - 30 per hour (US)

PI267076992

Formed in 2016, Silicon Valley Clean Energy (SVCE) is a public Community Choice Energy service provider serving approximately 270,000 residential and commercial customer accounts in thirteen Santa Clara County communities. SVCE's mission is to provide customers with renewable and carbon-free electricity at competitive rates, and further accelerate decarbonization through deployment of innovative local programs.