Statistical programmer Empleos en Berkeley ca

Position Summary

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.

PG&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,specific skills, education, licenses or certifications, experience, market value, and geographic location. 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. This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.

Bay Area Min: $ 118,000

Bay Area Max: $ 188,000

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.

Responsibilities:

• Provide primary technology support for all in-house environments with supported application platforms.
• Provide IT hand holding support, technical expertise to infrastructure Build & application Test teams as different activities are moved among environments.
• Coordinate installation refresh of database incremental drops from application vendor.
• Provide database support (SQL and application in-memory database) on all environments as different code sets and incremental updates are made available
• 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
• 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.
• Led complex data querying across ADMS, GIS, and enterprise systems, delivering actionable insights for difficult-to-access data and supporting critical decision-making.
• Manage access to all environment – onboarding users, changing authority and access control for different testing scenarios
• Provide infrastructure build & configuration support to build teams as environments are deployed and fully integrated for regression tests
• Provide system support to cybersecurity build & testing team
• Provide system support to system monitoring team to rationalize the number of events being monitored and assign priority for future support model development
• Manage data refresh from production environment to non-production environments
• Manage planned maintenance and planned outages across the three data centers
• Receive and track reports of application incidents, and support users throughout the triage and resolution process
• Receive and implement system and application configuration requests
• 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.
• Application performance analysis, proactive troubleshooting and capacity planning.
• 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.
• Understand business requirements and apply them to complex programming and analysis.
• Follow and collaborate on existing Application Development Frameworks and Coding Standards.
• Solid understanding of IT Delivery Methodology, compliance processes and impact to client projects.
• 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.
• 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.
• Freedom of Action: Oversee, mentor, and provide guidance to less experienced programmer-analysts.
• 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
• 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
• Demonstrated experience in IT-OT integration
• Expertise in understanding Data Models for OT applications

Qualification:

Minimum:

• BA/BS in Computer Science, Electrical Engineering/ or job-related discipline or equivalent experience
• 5 years of programming analysis experience

Desired:

• At least 3-5 years Electric utility background (distribution or transmission Operational systems preferred)
• 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
• Strong technical acumen with the ability to understand different Distribution Management System functions and platforms
• Ability to be creative, versatile, efficient and productive in the face of ambiguity
• Strong drive for results and continuous improvement including development of standards and process in line with utility best practices
• Strong problem determination and analytical skill to enhance large and interrelated systems.
• Hands-on experiences in any programming languages/C/C#/Python/Java
• Experience with development including web, databases and building REST and RESTful API’S using ANGULAR, typescript, Node, Python, Kendo, and NoSQL.
• Expertise in Database Systems, SQL, Oracle.
• Experience working in Agile / Scrum environment.