Pacific Gas and Electric Company · 2 days ago
Operations Data Analyst, Expert
Wonder how qualified you are to the job?
Maximize your interview chances
EnergyEnergy Efficiency
Insider Connection @Pacific Gas and Electric Company
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 data bases 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 database(s) 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.
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.
Funding
Current Stage
Public CompanyTotal Funding
$12.9B2023-11-29Post Ipo Debt· $1.9B
2020-06-06Post Ipo Debt· $11B
1979-08-03IPO· nyse:PCG
Leadership Team
Recent News
Investing.com
2024-06-04
2024-06-04
Company data provided by crunchbase