Santa Margarita Water District

Systems Analyst I

Onsite - Rancho Santa Margarita, CA
Full-Time
Application Deadline: 7/12/24

Class specifications are intended to present a descriptive list of the range of duties performed by employees in the class. Specifications are not intended to reflect all duties performed by individual positions.

JOB SUMMARY 

 

Under supervision performs a variety of professional level duties related to technical and operational support, programing, and internal customer services for the District IT department; Implements and supports host systems, communications, business systems and network infrastructure; also performs technical tasks related to evaluating, introducing, and maintaining information technology systems. A business system in this role includes Geographical Information (GIS) systems, Financial Information (ERP) systems, Customer Service Information (CIS) systems, Maintenance & Asset Management (EAM) systems, Utility Billing (UB) systems, Water Information Systems (WIMS), and Capital Program Management (CPM) systems (among others).

 

DISTINGUISHING CHARACTERISTICS 

This is the entry level class in the System Analyst series. Positions in this class typically have intermediate work experience. The System Analyst I class is distinguished from the II level by the performance of less than the full range of duties assigned to the II level. This classification will work primarily on operational tasks and support project level tasks under direction. Incumbents work under general supervision while learning job tasks, progressing to direction as procedures and processes of assigned area of responsibility are learned.

 

SUPERVISION RECEIVED

Receives supervision from the Information Technology Manager.

 Essential Functions:The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this class.

 

  1. Performs a variety of specialized, highly technical and complex computer database system or network system duties in support of specialized functions or programs.
  2. Provides operational support to the District’s network and database infrastructure. This includes but is not limited to programming, building, analyzing, diagnosing, maintaining, securing and operating various systems. 
  3. Answers questions, responds to end-user requests in a timely manner; provides information, assistance and training to personnel and departments on technology-related issues.
  4. Coordinates information system activities with users; assists in the assessment of output requirements, data processing schedules, volume of transaction data and other factors to determine the level and type of computer information system support required. 
  5. Analyzes, diagnoses, tests, recommends, or provides appropriate solutions for problems with computer, mobile, E-mail, Internet, software, hardware, business system, telecommunications or other technology related issues.
  6. Supports the installation and maintenance of the network, server, and telecommunications infrastructure; monitors and maintains local and wide area computer network; manages network file and print server functions; creates and maintains user connectivity; creates user accounts based on established protocols; coordinates installation of network and application software. 
  7. Implements internal control, network security methodologies and other security systems for data, systems, and hardware protection and recovery procedures; ensures timely and accurate back-up of data; implements disaster recovery procedures as needed; maintains appropriate confidentiality of sensitive information.
  8. Installs, configures, programs and tests workstations, servers, network systems and other computer related software and hardware; monitors systems and network resources; performs appropriate testing functions as needed; coordinates network and software upgrades; 
  9. Maintains availability of network systems; reviews system logs and trouble shoots network malfunctions; allocates and monitors server disk storage space for users on the network; allocates and monitors server memory usage to insure efficient dynamic memory usage.
  10. Provides technical support for the database environment; plans, designs, develops, modifies, tests and implements all aspects of database administration and relational database management system support. This includes support of the District GIS, ERP, CIS, EAM, and CPM systems. 
  11. Prepares recommendations to users for the collection of data to be stored in tables; maintains/creates schematics, data models and/or schemas for databases; manages naming conventions and data dictionaries; performs routine maintenance to the District’s database tables as required.
  12. Implements and maintains database and data file security features and procedures to assure the integrity and security of data resources and maintains appropriate confidentiality of sensitive information. 
  13. Creates and maintains scheduled tasks to automate routine procedures and processes; develops test plans and scripts; monitors logs; Tests backup, restore and disaster recovery procedures.
  14. Monitors, supports and oversees vendor software release cycles and deployment activities; develops time and cost estimates for new updates and maintenance changes as needed. 
  15. Reviews database utilization and performs tuning to ensure optimal performance; conducts and reviews tests of database servers to verify performance objectives and quality standards.
  16. Creates tables, custom queries, and export/import data as needed; designs and creates reports. 
  17. Stays current with technology advancements; develops and presents instruction to District staff on relevant technology related information, new equipment, and software upgrades.
  18. Prepares and maintains documentation and instructions; maintains and updates manuals, templates, web and intranet pages and related documents; follows protocols and procedures. 
  19. Assists with research of solutions and the procurement of technology related equipment or services; researches specifications and costs; tests beta and experimental systems, applications, and equipment; and researches and prepares related reports with recommendations.
  20. Acts as liaison between vendors, technical support, and departments to resolve system problems; resolves user problems and maintains user contact to assess needs, answer questions and provide technical information. 
  21. May plan, prioritize, and review the work of consulting staff, develop schedules and methods to accomplish assignments, and provide and coordinate staff training. 
  22. Provides technical assistance for desktop and mobile support issues; interviews, analyzes and documents end-user work processes and accompanying system requirements. 
  23. Builds and maintains positive working relationships with co-workers, other District employees and the public using principles of good customer service.
  24. Performs related duties as assigned. 

 Requisite Abilities:QUALIFICATIONS

Skill/Ability to: 

  • Perform a variety of professional level duties related to technical and operational support, programming, and internal customer service for District departments. 

 

  • Work efficiently and effectively with various software, hardware, operating systems, databases, network systems, business functional systems, and telecommunications systems. This includes the installation, upgrade, maintenance and troubleshooting of these systems. 

 

  • Write and perform programming functions in appropriate computer languages in a clear and well-documented style.

 

  • Monitor computer information system utilization and recommend appropriate revisions to processes. 

 

  • Develop and test programs; prepare test data, and test and debug application programs. 

 

  • Establish and maintain effective working relationships with those contacted in the course of work. This includes the ability to always exhibit a positive customer service attitude. 

 

  • Communicate clearly and concisely, both orally and in writing. This includes a strong understanding or proper business communications.

 

  • Safeguard confidential and private information in the course of business. This includes understanding the proper and improper ways to distribute information in the course of business. Exhibits appropriate business professionalism.

 

  • Know and understand all aspects of the job; 

 

  • Intermittently analyze work papers, reports and special projects; 

 

  • Identity and interpret technical and numerical information; 

 

  • Observe and follow operational and technical policy and procedures. 

 

  • On a continuous basis, sit at a desk for long periods of time; 

 

  • Intermittently twist to reach equipment surrounding desk; 

 

  • Lift or carry weight of 25 pounds or less.

 

 

Education, Training and Experience: 

Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A bachelor’s degree and a combination of experience and training is preferred. However, experience, certification, and training that would provide the required knowledge and abilities are qualifying. A typical way to obtain the required knowledge and abilities would be:

 

General Experience:

 

Three years of professional level information technology technical and operational support is desirable. 

 

Education:

 

A bachelor’s degree from an accredited college or university in computer science, information systems, engineering or a related field is preferred.

 

Software and Hardware Experience:

 

Experiences with the following technologies are preferred:

 

Microsoft Visio

ESRI ArcGIS Server Infrastructure

Tylertech MUNIS or similar business (ERP) system

Advanced Utility CIS Infinity or similar utility billing (CIS) system

CityWorks, Cartegraph or similar Enterprise Asset Management system

Aqua Informatics WIMS

Windows 10/11+ Operating System

Windows Server 2022+ Operating System

VMWare vSphere 7.x+ Hypervisor

Enterprise Storage (SAN) Administration (NetApp preferred)

Microsoft Exchange and SharePoint Online Administration

Microsoft System Center Configuration Manager

Microsoft Active Directory and Group Policy Administration

Microsoft Teams Telephony VOIP Administration

Microsoft SharePoint Development and Support

Cisco IOS: switches and routers

Palo Alto Networks Firewalls

 

Licenses; Certificates; Special Requirements: 

 

Possession of or the ability to obtain a valid California Class C driver’s license and the ability to maintain insurability under the District’s vehicle insurance program.

 Qualifications Guidelines:PHYSICAL AND MENTAL DEMANDS 

The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this class. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

Physical Demands 

Position requires the ability to communicate in a professional manner with District management, coworkers, the public, inter-agency, and elected officials through verbal and written communication in face-to-face, one-on-one, and group settings. This is primarily a sedentary office classification although standing in work areas and walking between work areas may be required; must have the ability to lift, carry, push, and pull materials and objects up to 25 pounds. Requires vision to read printed materials and computer screens; hearing and speech to communicate in person and over the telephone; and finger dexterity to access, enter, and retrieve data using a computer keyboard, copy machine, telephone, and other standard office equipment. Position requires ability to operate a motor vehicle and travel to conduct District business.

Mental Demands 

While performing the duties of this class, an employee uses written and oral communication skills; reads and interprets data, information, and documents; analyzes and solves problems; uses a math; learns and applies new information and skills; responds to emergency situations; and interacts with others encountered in the course of work, including frequent contact with customers and/or the public.

WORK ENVIRONMENT

The employee works in an office environment and may be required to work various hours at night, on weekends and holidays as needed.