Programmer Analyst – Engineering and GIS Systems

POSITION PURPOSE

Responsible for technical and analytical support to operations areas, developing engineering-based application solutions to operation problems, maintaining data integrity of dependent systems, supporting core software applications in use, consulting for new core applications being considered, and leading initiatives to improve processes and technologies.

DUTIES AND RESPONSIBILITIES

• Supports existing Company-developed desktop and Web-based engineering applications related to the Distribution and Outage Management Systems (DMS/OMS), Geospatial Information System (GIS), Gas and Electric Engineering Design Tools, and Work and Asset Management including system upgrades, integration, databases, software, and applications support.
• Maintains data system integrity, operational reliability, and system availability.
• Coordinates developing and implementing department policies and procedures to ensure all required computer application development, maintenance, and support practices are followed. This includes documentation, change management, version control, project definition, testing procedures, incident management, and security control.
• Maintains and configures vendor-supplied software solutions for applications used primarily by Electric and Gas Operations. Coordinates software releases, system integration, and upgrades.
• Acts as a consultant for other departments helping to interpret system operating procedures pertaining to operating computer systems.
• Provides technical direction to Operations personnel to allow better utilization of existing operational computer systems.
• Tests and debugs computer programs.
• Analyzes needs for computerization.
• Designs new or modifies existing systems and writes computer programs to implement the system.
• Collaborates with Gas and Electric Operations to identify candidate processes for efficiency improvements through automation or other technologies.
• Works with IMS to design and implement systems to realize those improvements.
• Performs advanced data analysis across multiple sources, formats, and platforms including DMS/OMS, GIS, and Work and Asset Management databases.
• Produces engineering and industry surveys and governmental agency reports, maps, and documentation including required regulatory reporting. Provides input for developing the strategic plan for departmental information technology responsibilities.
• Writes and maintains documentation describing program development, logic, coding, testing, changes, and corrections.
• Adheres to applicable standards for all supported systems and applications.
• Works with Data Analysts to ensure data quality control across various systems.
• May be subject to call-in or required to respond on short notice to systems operations-related emergencies.
• Leads in developing and implementing procedures and training programs for Operations personnel related to operating computer systems and processes.

QUALIFICATIONS

Education and Experience:

• Bachelor of Science in Computer Science or its equivalent from an accredited institution.

Knowledge and Skills:

• Problem-solving and analytical skills.
• Working knowledge of gas and electric distribution systems.
• Able to work independently taking ownership of project/task completion to meet scheduled due dates.
• Good oral and written communication skills.
• Able to develop and maintain collaborative, professional relationships with peers, management, professional groups, contractors, consultants, and customers.
• In-depth knowledge of relational databases and Structured Query Language (SQL).
• Applied knowledge of, but not limited to: Oracle database and PL/SQL, SQL Server, Microsoft .NET, HTML, IIS, and Microsoft Office.
• Able to solve practical problems and deal with a variety of situations where only limited standardization exists.
• Able to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.