Business Systems Analyst II

Company Name: Franklin PUD
Phone Number: (509) 546-5949
City: Pasco
State/Provence: Washington
Zip: 99302
Job Title: Business Systems Analyst II
Number of Openings: 1
Position Type: Information Technology / IS and Application Support
Posting Start Date: July 11, 2018
Salary: $65,092.00 - $96,764.00
Salary Per: Per Year
Work Time: 40
Work Time Type: Hours


The Business Systems Analyst II is responsible for optimizing business applications and databases used by the District.  This position provides strategy, design, administration, maintenance, and support of District enterprise databases and business applications by providing technical expertise in the areas of Business Intelligence which include data management, data optimization, data warehousing, data analysis, data indexing, trouble-shooting, custom report writing and end user training.


  1. Accountable for the development of technology solutions for District problems and the maintenance and integration of business applications and systems that support the District’s business operations.
  2. Responsible for developing, maintaining, optimizing, testing, and assisting with work management solutions and integrations between core business applications.
  3. Manage security accounts, user roles, privileges and ensuring appropriate security and privacy measures are implemented on technology solutions to protect District data from intentional or accidental misuse.
  4. Responsible for evaluating, recommending, testing, debugging, training end users and supporting District software solutions.
  5. Have knowledge of the tools and programming languages required to develop, test, maintain and administer databases and business applications.
  6. Work with users and act as liaison for District departments to determine needs, cost effectiveness and viability of software solutions.
  7. Ensure that business critical applications are available for users.
  8. Create custom reports requested by District personnel.
  9. Professional behavior: Understands and follows the District’s and supervisor’s expectations regarding appropriate dress, attendance, punctuality, scheduled and unscheduled time off, and appropriate use of District time, equipment and resources.
  10. Teamwork: Supports IT department goals and helps promote a positive team environment. Participates in department meetings, internal committees, or work groups as requested. Actively and positively participates in these meetings to brainstorm, find solutions, and share information.
  11. Performs other duties as assigned.
Experience Required:


Education and experience: BA/BS in Management Information Systems, Computer Science or field related to functional area. A minimum of five years of specific functional support level experience with the relevant technologies is required. An equivalent combination of education and experience that would provide the necessary knowledge, skills and abilities to successfully perform the essential functions of the job may be substituted for the degree.

Knowledge, skills and abilities: Ability to stay current with technology and to apply training and experience to District related application solutions. Ability to learn functional work processes of electric utilities and manage multiple priorities. Aptitude and initiative to understand the inner workings of applications and databases. In-depth knowledge of relational database concepts, ETL methodologies, and client-server environment and virtualization technologies.  In-depth knowledge and experience working with web server application environments, system analysis, programming, design, Microsoft SQL and Oracle.  In-depth knowledge of IT principles and best practices including strong documentation skills.  Must have experience with database tools, monitoring software and operating system utilities. Experience in tracking work/trouble issues with ticketing systems.  Experience in documenting technical issues and maintaining knowledge bases.  Able to effectively communicate orally and in writing, able to develop an understanding of the District’s operations and procedures, to analyze business problems and opportunities and have strong analytical and problem resolution skills. Signs and understands IT Employee Confidentiality Agreement.

Character of supervision received: General guidance is provided by the Information Technology Manager. Receives work assignments and priorities, then works independently.

Character of supervision given: Is not responsible for the performance of other employees.

Responsibility for confidential matters: May have access to sensitive material created or stored on the District’s computer systems. Uses sound judgment to determine level of sensitivity; protects this material and/or keeps its content confidential, as appropriate. Notifies appropriate personnel if sensitive data was accessed by unauthorized employees. Signs and understands IT Employee Confidentiality Agreement.

Responsibility for accuracy and effect of errors: Maintains a high level of accuracy. Errors of judgment may result in loss of District revenue or important data, and breaches of confidentiality.

Responsibility for getting along with others: Has daily contact with District employees, in problem solving and application situations. Has periodic contact with outside computer support personnel. Maintains positive, professional working relationships with all. Works effectively in a team environment.

Pressure of work: Pressure may occur when multiple requests are received, when prioritizing tasks and when working under time constraints.

Travel/Unusual working conditions: May travel to attend training. Added or adjusted work hours may be required to accomplish project completion or system repair.

How to Apply:

For more information or to apply, please visit

Posting End Date: August 10, 2018