Job Location: San Ramon, CA
Job Detail:
TOP THINGS:
– Oracle Advanced Analytics
– Oracle Data Mining
– Oracle query performance tuning and indexing
PLEASE NOTE: The HM DOES NOT WANT to see profiles that do not have Oracle data mining experience. He absolutely DOES NOT NEED python-based data science experience. PLEASE DO NOT HIGHLIGHT PYTHON BASED EXPERIENCE WHEN SUBMITTING.
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.
Qualifications
Minimum
• 2-4 years of professional experience in Oracle Data Mining
• 3-5 years of experience in performing advanced analytics inside Oracle
• 3-5 years of experience in Natural Language Processing (NLP)
• BA/BS in Business, Engineering, Computer Science/Information Systems or equivalent
• 3-5 years of experience in using relational databases – DML, DDL, DCL and TCL
• 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
• 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
Desired
• 3-5 years of experience within any area of Electric Operations in the electric utility industry
• Understanding of normal form data modeling and dimensional data modeling concepts
• 5-7 years of mixed experience in OSISoft PI – architecture, development, system administration and end use
• 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
Responsibilities
• Understand business requirements
• Understand the data in different systems, such as Aveva/OSI PI, data warehouses and various transactional systems
• Come up with innovative ideas to solve business problems using data
• Develop and maintain analytics – from rules based deterministic analytics to heuristic analytics such as classification and Natural Language Processing
• Tune database queries, to achieve optimal performance
• Develop and maintain BI reports
- • Document all work
Submit CV To All Data Science Job Consultants Across United States For Free