64 applicants

Company

Original Job Post

Pacific Gas and Electric Company · 2 days ago

Operations Data Analyst, Expert

Oakland, CA

Full-time

Hybrid

Senior Level

$122K/yr - $194K/yr

6+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

EnergyEnergy Efficiency

Insider Connection @Pacific Gas and Electric Company

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Works with Directors and Managers across functions to influence decisions.

Manages and ensures accuracy of very complex data extracts and list pulls, from initial request to presenting data results, with limited supervision.

Ability to pull and make sense of conflicting data from various data platforms such as Electric Grid Interconnection (EGI), the Advanced Billing System (ABS), and Teradata to quickly investigate customer escalations and to identify implementation defects/IT enhancements required to accurately bill customers on the complex solar tariffs.

Demonstrates and uses broad expertise in data processing and data analysis and applies this knowledge to a number of different issues.

Analyzes data using various advanced statistical tools to develop complex ad hoc reports, statistics, trends, profiles.

Designs data analysis to achieve business objectives, process data, analyze data, write clear and concise data findings and tailor communications to specific audiences.

Creates automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.

Organizational skills to develop a 'data dictionary' of where common solar characteristics are stored across the various databases mentioned above, to create a standardized intake process for data requests, and to effectively document how data was pulled in case of future related requests.

Provides new and innovative solutions and recommendations to enhance databases with new data sources and improved data processes.

Ability to drive change and write business requirements to get commonly used solar data characteristics into a singular location (Teradata).

Develops comprehensive reports and communicates clear, concise and actionable data analyses for clients.

Ability to create and maintain new self-serve reports in PowerBI.

Ability to modify existing Tableau self-serve tools.

Ability to develop solar customer forecasts which will inform critical business decisions like call center staffing and cost shift analysis related to rate implementation delays.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Job-related experienceSQLOracleBusiness ObjectsPG&E Solar InterconnectionBilling CharacteristicsMicrosoft ExcelMicrosoft AccessComplex FormulasGraphingVBABase-SASVisual BasicPerlCTableauPowerBIMasters DegreeProblem SolvingOrganizational SkillsPrioritizationMulti-tasking

Required

Bachelors Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience

Job-related experience, 6 years

Preferred

Advanced skill in writing SQL queries using Oracle or Business Objects

Strong problem solving skills

Familiarity with PG&E solar interconnection and billing characteristics

Advanced skill in Microsoft Excel/Access (complex formulas, graphing, VBA)

Strong knowledge of base-SAS and programming language (such as Visual Basic, Perl, C)

Intermediate knowledge of Tableau or PowerBI

Strong organizational, prioritization, and multi-tasking skills

Masters Degree or equivalent experience

Job-related experience, 8 years

Company

Pacific Gas and Electric Company

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.

Founded in 1905

San Francisco, California, USA

10,001+ employees