David Evans and Associates is currently seeking a PI Developer to join our project team for our client based in Vancouver, WA.

Position Overview:

The OpInfo team (TOT) is a group providing data historian tools and analysis/regulatory reporting services to engineering staff and Transmission management.  This position will fulfill a combination of software support and data analysis needs within the team.  Skills required for this position require a diverse mix of Windows application development, Windows server administration, SQL database modeling, PI development, and PI server administration.

Position Responsibilities include but not limited to: 

• Assist statisticians in using Microsoft Excel VBA macros to expedite production of ad-hoc reports for regulatory oversight bodies, BPA management, and engineering personnel
• Utilize OSISoft Data Link and Process Book clients to query and present a variety of information from BPA’s PI system
• Design, code, and test complex applications that include batch, data access, data validation, and user interface components.  Design and create SQL database objects that support the application.
• Troubleshoot PI collective and interface nodes.  Keep PI server and interface software current with new vendor patches and releases.
• Perform PI archive fills from alternate data sources due to data loss events.
• Configure new web applications using Microsoft Server’s IIS administration tool.
• Set user access controls to minimum necessary for proper operation of the web application.
• Assist in the troubleshooting and maintenance of Windows servers. 
• Create scripts to automate maintenance, assure security controls remain intact, and help coordinate patching activities.
• Required to provide personal contact information (phone numbers only) for emergency call outs, carry a BPA supplied cell phone/pager (if applicable), and work non-core hours when requested. May be required to work on an after-hours on-call rotation with other team members

Qualifications:

Education/Experience

• Bachelors degree, preferably in computer science or related field is required
• 5-7 years relevant experience
• Minimum 2 years experience in administering a PI high-availability collective.
• Minimum 2 years experience administering Windows stand-alone and clustered servers.
• Minimum 2 years experience using the Visual Studio IDE (Integrated Development Environment) and high proficiency in using the C# programming language. 

Additional Requirements:

• Demonstrated solid understanding of object-oriented programming concepts and techniques.
• Experience in data mining procedures for Supervisory Control and Data Acquisition (SCADA), metering, and outage data
• Familiarity and experience with electric utility operational data systems is preferred,
• Possesses advanced skills and experience in the use of Microsoft Excel (MS Office 2010 proficiency required)
• Experience using and installing OSISoft PI Process Book and DataLink client applications
• Strong MSSQL query and data modeling skills.  Ability to design schemas for new applications and establish relevant relationships between fields in highly normalized data.
• Ability to plan, design, document, code, test, implement, and maintain complex applications including console executables, web forms with embedded code, web services, and Windows services.
• Good communication skills and ability to share knowledge with others
• Experience developing applications designed to run on enterprise batch job schedulers
• Ability to produce results in a timely and efficient manner
• Proven experience working both independently and in a team-oriented, collaborative environment is essential
• Must possess excellent leadership, persuasive and people management skills
• Ability to simultaneously handle multiple assignments
• Must be flexible, able to pay attention to detail, and work under pressure during periods of peak work volume
• Must be highly engaged, responsive and proactive

Training (BPA provided):

• Power System Essentials

Training required (Supplier provided):

• $5,000 training allowance (including tuition, labor and all travel costs) to be used within 2 years from assignment start date.  BPA to determine training courses to be attended per identified business needs for the position (as required to fully meet all Position Requirements and Responsibilities).
• Bill rate may be adjusted accordingly upon completion of the 2-year training requirement, based on market rates and candidate progress.

Note: This position may be eligible for situational offsite work, subject to the completion of a Supplemental Labor Offsite Work Memorandum of Understanding.