Share this Job

Expert, Data Scientist (Flexible Location)

San Ramon, CA, US, 94583

Requisition ID # 112149 

Job Category : Information Technology; Engineering / Science; Maintenance / Construction / Operations 

Job Level : Individual Contributor

Business Unit: Electric Operations

Job Location : San Ramon; Alameda; Alta; Angels Camp; Antioch; Auberry; Auburn; Avenal; Avila Beach; Bakersfield; Balch Camp; Bear Valley; Belden; Bellota; Belmont; Benicia; Berkeley; Brentwood; Brisbane; Buellton; Burney; Buttonwillow; Calistoga; Campbell; Canyon Dam; Capitola; Caruthers; Chico; Clearlake; Clovis; Coalinga; Colusa; Concord; Concord; Corcoran; Cottonwood; Cupertino; Daly City; Danville; Davis; Dinuba; Downieville; Dublin; Emeryville; Eureka; Fairfield; Folsom; Fort Bragg; Fortuna; Fremont; French Camp; Fresno; Fresno; Fulton; Garberville; Geyserville; Gilroy; Goodyear; Grass Valley; Guerneville; Half Moon Bay; Hayward; Hinkley; Hollister; Holt; Houston; Huron; Jackson; Kerman; King City; Lakeport; Lemoore; Lincoln; Linden; Livermore; Lodi; Loomis; Los Banos; Lower Lake; Madera; Magalia; Manteca; Manton; Mariposa; Martell; Marysville; Maxwell; Menlo Park; Merced; Meridian; Millbrae; Milpitas; Modesto; Monterey; Montgomery Creek; Morgan Hill; Morro Bay; Moss Landing; Mountain View; Napa; Needles; Newark; Newman; Non-PG&E Non-US Off Shore Work Location; Non-PG&E US Work Location; Novato; Oakdale; Oakhurst; Oakland; Oakley; Olema; Orinda; Orland; Oroville; Palo Alto; Palo Cedro; Paradise; Parkwood; Paso Robles; Petaluma; Pioneer; Pismo Beach; Pittsburg; Placerville; Pleasant Hill; Point Arena; Potter Valley; Quincy; Rancho Cordova; Red Bluff; Redding; Richmond; Ridgecrest; Rio Vista; Rocklin; Roseville; Round Mountain; Sacramento; Salinas; San Bruno; San Carlos; San Francisco; San Francisco; San Jose; San Luis Obispo; San Mateo; San Rafael; Sanger; Santa Cruz; Santa Maria; Santa Nella; Santa Rosa; Selma; Shaver Lake; Sonoma; Sonora; South San Francisco; Springville; Stockton; Storrie; Taft; Tracy; Turlock; Twain; Ukiah; Vacaville; Vallejo; Walnut Creek; Wasco; Washington; Watsonville; West Sacramento; Wheatland; Whitmore; Willits; Willow Creek; Willows; Winters; Woodland; Yuba City


Department Overview


Join a high-performing dynamic team within Pacific Gas & Electric Company that is working in an exciting operational environment where we are transforming electric grid technology to support smart grid. Within the Electric Grid Operations Business Applications organization, we are a team called Operational Business Intelligence (OBI). OBI ensures safe, reliable and efficient utility operations through Business Process Management (BPM) and Continuous Improvement (CI) with the use of innovative Business Intelligence (BI). OBI owns and maintains self-serve data platform products such as the PG&E Electric OSI PI platform and data warehouses, engages with internal customers to evaluate their business processes, and builds and deploys BI solutions to improve those processes. The data platform products are being enhanced on a continuous basis and the number of BI solutions is growing at a rapid rate. Additionally, the OBI team is responsible for charting the path for the data strategy of the overall Business Applications organization. The customer base of the team includes Electric Distribution Operations, Electric Distribution Planning, Electric Transmission Operations, Electric System Protection, Substation Asset Strategy, Substation Maintenance and Substation Automation. We are seeking a dynamic individual to join our team as an Expert Data Scientist.



Position Summary


The Data Scientist will be developing a career for himself/herself filled with excitement! The utility industry is in the middle of a massive transformation. Energy generation is going from 100% centralized to significantly distributed. Operational decision-making and control actions are going from largely manual to largely automated. Technologies such as energy storage, electric vehicle, autonomous vehicle, robots, drones and machine learning are either already changing or are poised to change the way electric utilities operate. Sophisticated software applications are at the heart of all these changes. And it’s the Business Applications team that develops and supports these applications. As part of the team, the Data Scientist will be responsible for developing and providing support for these applications. This role has a lot of opportunity to learn new things and to come up with creative solutions to difficult problems. The Data Scientist must be able to work with individual contributors as well as leaders at different levels, such as supervisors and managers, and gain credibility and trust of both leadership and peers. The successful candidate must be able to work closely with team members, peers within the organization, external partners/vendors, internal customers and the IT organization to deliver high quality support and solutions for business users. A strong sense of ownership and accountability are required, to ensure the infallible quality of support and solutioning that is necessary in electric operations.


This position offers a flexible work location within the PG&E service territory.




  • Understand user requirements
  • Understand the data in different systems, such as OSI PI, data warehouses and various transactional systems
  • Fix data issues in the OSI PI system
  • Develop and maintain (issue resolution and enhancement) ETL jobs from various systems including OSI PI into MS SQL Server
  • Develop and maintain (issue resolution and enhancement) BI reports
  • Come up with innovative ideas to solve business problems using data
  • Document all work





  • BA/BS in Business, Engineering, Computer Science/Information Systems or equivalent experience
  • Minimum of 8 years of relevant experience in data science or advanced analytics, OR Master’s Degree and 6 years relevant experience, OR Doctorate Degree.




  • 3-5 years of experience within any area of Electric Operations in the electric utility industry
  • 3-5 years of experience with scripting languages such as R, python, powershell
  • 5-7 years of mixed experience in OSISoft PI – architecture, development, system administration and end use
  • 3-5 years of experience in analyzing data and presenting the results
  • 3-5 years of experience in using relational databases – DML, DDL, DCL and TCL
  • 3-5 years of experience in developing and maintaining ETL jobs
  • 3-5 years of experience with Oracle Data Integrator (ODI)
  • 3-5 years of experience with SSIS
  • 1-3 years of experience with SSRS or Power BI
  • 1-3 years of experience in data quality improvement, especially in developing program to detect data quality issues
  • Understanding of data modeling concepts
  • 3-5 years of experience in Natural Language Processing (NLP)
  • Ability to work independently and to take accountability
  • Ability to be creative
  • Ability to communicate in a concise manner
  • Proficiency in Microsoft Word, Excel and PowerPoint



Pacific Gas and Electric Company (PG&E), a subsidiary of PG&E Corporation (NYSE:PCG), is one of the largest combined natural gas and electric companies in the United States. Based in San Francisco, our 24,000 employees deliver safe, reliable, affordable and clean energy to nearly 16 million people throughout our Northern and Central California service area, stretching from Eureka to Bakersfield and from the Pacific Ocean to the Sierra Nevada.

More About Our Company

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.

Employee Privacy Notice                                                                                                                                                                                                                                      The California Consumer Privacy Act (CCPA) goes into effect on January 1, 2020. CCPA grants new and far-reaching privacy rights to all California residents. The law also entitles  job applicants, employees and non-employee workers to be notified of what personal information PG&E collects and for what purpose. The Employee Privacy Notice can be accessed through the following link: Employee Privacy Notice

PG&E will consider qualified applicants with arrest and conviction records for employment in a manner consistent with all state and local laws.

Nearest Major Market: San Francisco
Nearest Secondary Market: Oakland