← back to jobs
> job detail
P
🧪Data Scientist

Programmer Analyst, Senior (Oakland, CA, US, 94612)

Pacific Gas And Electric Company · Oakland, CA, US, 94612
// classified as
Data Scientist (Modeling, experiments, research.)
posted
5d ago
location
Oakland, CA, US, 94612
languages
python, sql, typescript
tools
> stack
pythonsqltypescript
> description
<p>Requisition ID # 172151 </p> <p><p>Job Category: Information Technology </p> <p>Job Level: Individual Contributor</p> <p>Business Unit: Information Technology</p> <p>Work Type: Hybrid</p> <p>Job Location: Oakland</p> <p> <p> <p> <p><p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><strong><span style="font-family:Arial, sans-serif">Department Overview</span></strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">PG&amp;E IT is a unified organization composed of various departments which collaborate effectively to plan, deliver, and operate high quality technology solutions. Grid and Control Center technology department is in the process of embarking major transformation journey implementing ADMS (Advanced Distribution Management System), DERMS (Distributed Energy resource management system) and supports &amp; maintains legacy applications within Electric distribution &amp; transmission and Gas area to meet identified business goals and priorities.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><strong><span style="font-family:Arial, sans-serif">Position Summary</span></strong></span></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><span style="font-family:Arial, sans-serif">The Programmer/Analyst designs, develops, modifies, configures, debugs and evaluates application programs for functional business areas. Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs. Assist in the definition, development, and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analyst and other project team members. Consult with business analysts and architects to understand, anticipate, and meet current and future business needs. Modify and configure applications/systems as specified in the requirements and/or technical design document. Prepares and obtains approval of system and development documentation. Recommend changes in development, maintenance and system standards and processes. Anticipate client concerns and questions and provide timely, professional, straight forward (non-technical) communications. Provide on call support for production systems and provide timely solutions. Day-to-day tasks to ensure systems are up and running. Respond to ad-hoc questions and intra- departmental communications. Supports bug fixes, patches, minor enhancements, and service request.<br><br></span><span style="font-family:Arial, sans-serif">PG&amp;E is providing the full salary/pay range for this position. The actual amount paid to an individual will be based on multiple factors, including, but not limited to, internal equity,<strong> </strong>specific skills, education, licenses or certifications, experience, market value, and geographic location. <strong>The range to reasonably expect will be around the minimum and the midpoint $118,000 - $153,000. The final decision will be made on a case-by-case basis related to the factors above. </strong>This job is also eligible to participate in PG&amp;E’s discretionary incentive compensation programs. </span></span></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Bay Area Min: $ 118,000</span></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Bay Area Max: $ 188,000<br><br>This position is hybrid, working from your remote office and our Oakland, CA office approximately 1 - 2 days per week, or more, based on business needs.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><strong><span style="font-family:Arial, sans-serif">Responsibilities:</span></strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide primary technology support for all in-house environments with supported application platforms.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide IT hand holding support, technical expertise to infrastructure Build &amp; application Test teams as different activities are moved among environments.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Coordinate installation refresh of database incremental drops from application vendor.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide database support (SQL and application in-memory database) on all environments as different code sets and incremental updates are made available</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Manage and deploy vendor application updates (patches, hotfixes) and coordinate with internal teams for OS updates on all environments taking into consideration different ongoing activities</span></li> </ul> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:15.0pt;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Lead system integration and network design efforts, collaborating with Cyber Security SMEs to define secure architectures, design integration pipelines, and bridge gaps between program requirements and enterprise security standards.</span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:15.0pt;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Led complex data querying across ADMS, GIS, and enterprise systems, delivering actionable insights for difficult-to-access data and supporting critical decision-making.</span></li> </ul> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Manage access to all environment – onboarding users, changing authority and access control for different testing scenarios</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide infrastructure build &amp; configuration support to build teams as environments are deployed and fully integrated for regression tests</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide system support to cybersecurity build &amp; testing team</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Provide system support to system monitoring team to rationalize the number of events being monitored and assign priority for future support model development</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Manage data refresh from production environment to non-production environments</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Manage planned maintenance and planned outages across the three data centers</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Receive and track reports of application incidents, and support users throughout the triage and resolution process</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Receive and implement system and application configuration requests</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">As required, test and evaluate product upgrades, add-ons, etc. to validate product integrity, usability, and detect potential user issues, identify potential solutions and make recommendations for improvement.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Application performance analysis, proactive troubleshooting and capacity planning.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Update process documentation - ensure documentation of entire environment is current. Support the deployment of solutions and have a good understanding of solution methodology. Management of global systems users.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Understand business requirements and apply them to complex programming and analysis.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Follow and collaborate on existing Application Development Frameworks and Coding Standards.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Solid understanding of IT Delivery Methodology, compliance processes and impact to client projects.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Problem Solving: Lead complex system modifications. Assignments are based on extensive knowledge of concepts, principles or practices in a specific discipline, field or area of expertise, and require seasoned, experienced-based judgment in applying and adapting techniques.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Internal/External Contact: May attend client meetings on behalf of team or manager. Collaborate with Project Manager on complex project timelines, identifying critical path, resource assignments, risks, and dependencies representative.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Freedom of Action: Oversee, mentor, and provide guidance to less experienced programmer-analysts.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Awareness and good familiarity with tools / applications regularly used by electric distribution or transmission system Operators, Operating Engineers, and Planning Engineers such as: SCADA, Outage Management System (OMS), Distribution Management System (DMS), Power Flow based applications, State Estimation, FLISR, VVO etc</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Demonstrated skills and experience in maintaining SCADA, OMS/ DMS/ADMS or EMS software including relevant experience working on upgrade or replacement projects in the past</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Demonstrated experience in IT-OT integration </span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Expertise in understanding Data Models for OT applications </span></li> </ul> <p style="margin:0.0in 0.0in 0.0in 0.5in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><strong><span style="font-family:Arial, sans-serif">Qualification:</span></strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Minimum:</span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">BA/BS in Computer Science, Electrical Engineering/ or job-related discipline or equivalent experience </span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">5 years of programming analysis experience</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt"><strong><span style="font-family:Arial, sans-serif">Desired:</span></strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">At least 3-5 years Electric utility background (distribution or transmission Operational systems preferred)</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Strong interpersonal, verbal, and written communication skills with the ability to work in a collaborative environment and interact with all levels of management within the Business, IT groups besides the application Vendor</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Strong technical acumen with the ability to understand different Distribution Management System functions and platforms</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Ability to be creative, versatile, efficient and productive in the face of ambiguity</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Strong drive for results and continuous improvement including development of standards and process in line with utility best practices</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Strong problem determination and analytical skill to enhance large and interrelated systems.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Hands-on experiences in any programming languages/C/C#/Python/Java</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Experience with development including web, databases and building REST and RESTful API’S using ANGULAR, typescript, Node, Python, Kendo, and NoSQL.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Expertise in Database Systems, SQL, Oracle.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:12.0pt;font-family:Arial, sans-serif">Experience working in Agile / Scrum environment.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p>