Pacific Gas & Electric Company Senior Business Analyst in Oakland, California
Requisition ID # 20640
Job Category : Business Operations / Strategy
Job Level : Individual Contributor
Business Unit: Electric Operations
Job Location : Oakland
Based in San Francisco, Pacific Gas and Electric Company, a subsidiary of PG&E Corporation (NYSE:PCG), is one of the largest combined natural gas and electric utilities in the United States. And we deliver some of the nation's cleanest energy to our customers in Northern and Central California. For PG&E, Together, Building a Better California is not just a slogan. It's the very core of our mission and the scale by which we measure our success. We know that the nearly 16 million people who do business with our company count on our more than 24,000 employees for far more than the delivery of utility services. They, along with every citizen of the state we call home, also expect PG&E to help improve their quality of life, the economic vitality of their communities, and the prospect for a better future fueled by clean, safe, reliable and affordable energy.
Pacific Gas and Electric Company is an Affirmative Action and Equal Employment Opportunity employer that actively pursues and hires a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, age, religion, physical or mental disability status, medical condition, protected veteran status, marital status, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information or any other factor that is not related to the job.
The men and women of Electric Operations ensure the delivery of safe and reliable electric service to our customers. Electric Operations is responsible for every aspect of PG&E's electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration and emergency response.
Design and generate recurring and ad-hoc reports from SAP and Business Warehouse for Pole Test and Treat’s management team. Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.
Performs analysis on complex data models requiring customized reports and data.
Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders.
Design and generate recurring and ad-hoc reports from SAP and Business Warehouse for Pole Test and Treat’s management team.
Utilize advanced Excel and Access skills to perform data analysis on historical data to assist in scheduling pole treatment projects as well as monitor YTD trends.
Extract pole data from SAP and apply complex SQL commands to remove incomplete and duplicate data prior to importing it into Esri ArcMap to build projects.
Use Esri ArcMap to perform spacial analysis on distribution pole assets and group them into inspection projects taking into consideration HFTD zones.
Load inspection projects into SAP.
Participate in weekly status meetings with MobileConnect team going over planned outages and upgrades to MobileConnect based PTT applications and related environments.
Work closely with the application development team describing current and new functionality, creating test data, and validating it.
Document and submit software defects (SAP, MobileConnect, and PQC).
Make changes to MobileConnect based PTT application’s UI elements.
Review and approve design specifications for enhancements and fixes to PTT’s MobileConnect based application and SAP environment.
Use Google Earth Pro to create KMZ file from pole data.
Respond in a timely manner to requests for pole inspection data from PTT management and other lines of business such as the Law Department.
Bachelors Degree in Business Administration or job-related discipline or equivalent experience
Job-related experience, 4 years
Advanced Skills in SAP, Business Warehouse, ArcMap, MobileConnect and PQC
Skill in making recommendations based on relevant expertise as needed to perform at the job level
Competency in using compelling arguments to gain the support and commitment of others
Knowledge of performance management theories, concepts, methods, best practices, and techniques as needed to perform at the job level
Competency in making sense of complex, high quantity, and sometimes contradictory information to effectively solve problems
Competency in creating new and better ways for the organization to be successful
Ability to solve simple and complex problems involving arithmetic.
Competency in developing and delivering multi-mode communications that convey a clear understanding of the
Ability to apply project management theories, concepts, methods, best practices, and techniques as needed to perform at the job level
Advanced Knowledge of Microsoft Office Products - for example Excel, Word, PowerPoint, Access