Location: Vancouver, WA
Description:
General Position Overview:
The TOT Op Info team is a group providing data historian tools and analysis/regulatory reporting services to engineering staff and Transmission management. This document outlines a full-time contract position to fulfill a combination of software support and data analysis needs for the group.
General Requirements:
General Skill Requirements:
· Experience in data mining procedures for SCADA, metering, and outage data
· Familiarity and experience with electric utility operational data systems, preferably those of the company
· Possesses advanced skills and experience in the use of Microsoft Excel
· Familiarity and experience with the PI DataLink application of OSISoft, Inc
· Ability to perform SQL queries and create/modify stored procedures on Microsoft SQL server
· Experience in the use of Visual Studio and proficiency in using the C# programming language
· Good communication skills and ability to share knowledge with others
· Familiarity with the use of batch job schedulers
· Ability to produce results in a timely and efficient manner
· Ability to work as a team player with existing staff
Tasks:
Tasks may include but not limited to:
· Perform data mining and statistical analysis work on real-time SCADA data, hourly generation/interchange data, hourly metering data, and outage information.
· Utilize Microsoft Excel to produce periodic and ad-hoc reports for regulatory oversight bodies, management, and engineering personnel
· Provide assistant on use of Microsoft Excel for data analysis and charting
· Utilize OSISoft Data Link client to fetch a variety of information from our PI system
· Perform software and database maintenance on after-the-fact outage historian (OARS)
· Perform software and database maintenance on application that is used to reveal electrical restrictions in substation equipment (Bottleneck)
· Regularly check status on a variety of periodic automated batch jobs
· Other duties as assigned
Summary: To provide for the development of application system specifications; to provide support in the development of detailed design specifications for computer system routines and programs; to perform extensive testing of programs for program verification; and to apply company standards for program structure, implementation techniques, and quality assurance. These activities are necessary in order to provide programming support to customer management.
Typical Tasks may include but are not limited to:
• Defines applications problems, determines system specifications, recommends equipment changes and designs data processing procedures.
• Codes, tests, installs and documents detailed programs while applying applicable standards to all products.
• Prepares logic and other diagrams illustrating the program, system and application architecture.
• Controls and schedules assigned work to meet deadlines which may include providing technical guidance to other data processing staff.
• Interfaces with the customer to gather pertinent information to further define program and application specifications.
• Analyzes existing system and program logic and makes revisions.
• Applies applicable standards when defining computer systems.
• Performs other related duties of a comparable level as assigned.
Desired Skills:
• Current knowledge of third generation languages and an understanding of fourth generation languages and their application is required.
• An understanding of data structures, files and database and their applications is needed.
• Knowledge in system design techniques is necessary.
• Detailed knowledge of the system development life cycle is required.
Typical Work Activities may include any of the following:
• Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
• Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
• Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
• Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
• Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
• Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
• Communicating with Management, Peers, or Co-workers — Providing information to management, co-workers, and peers by telephone, in written form, e-mail, or in person.
• Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.
• Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.
• Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions
Knowledge, Skills and Abilities Requirements:
Knowledge – The specific position may require any or all of the following:
• Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
• Customer and Personal Service — Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
• Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
• Engineering and Technology — Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
• Administration and Management — Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Skills – The specific position may require any or all of the following:
• Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
• Reading Comprehension — Understanding written sentences and paragraphs in work related documents.
• Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
• Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
• Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
• Troubleshooting — Determining causes of operating errors and deciding what to do about it.
• Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
• Service Orientation — Actively looking for ways to help people.
• Time Management — Managing one's own time and the time of others.
• Quality Control Analysis — Conducting tests and inspections of products, services, or processes to evaluate quality or performance.
Abilities – The specific position may require any or all of the following:
• Information Ordering — The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
• Oral/Written Comprehension — The ability to listen/read and understand information and ideas presented through spoken words and in writing.
• Problem Sensitivity — The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
• Category Flexibility — The ability to generate or use different sets of rules for combining or grouping things
• Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense.
• Fluency of Ideas — The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
• Speech Clarity — The ability to speak clearly so others can understand you.
• Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
Education, Experience, Job Training:
• Requires relevant work experience with a Bachelor’s degree in a technical or computer-related field.
• Seven years of experience in the programming field may be substituted for the degree.
Work Styles
• Attention to Detail — Position requires being careful about detail and thorough in completing work tasks.
• Analytical Thinking — Position requires analyzing information and using logic to address work-related issues
• Dependability — Position requires being reliable, responsible, and dependable, and fulfilling obligations.
• Integrity — Position requires being honest and ethical.
• Adaptability/Flexibility — Position requires being open to change (positive or negative) and to considerable variety in the workplace.
• Innovation — Position requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
• Cooperation — Position requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
• Initiative — Position requires a willingness to take on responsibilities and challenges.
• Stress Tolerance — Position requires accepting criticism and dealing calmly and effectively with high stress.
• Persistence — Position requires persistence in the face of obstacles.
