Allan Hancock CollegeClassified- Exempt

Human ResourcesRange 5

SYSTEMS ANALYST

DEFINITION:

Under supervision of the Director, Information Technology Services, this position supports enterprise resource planning (ERP) systems, associated databases, operating systems, and related software; performs configuration management tasks; builds and releases a functioning system; makes changes to existing programs; integrates new programs with existing programs; develops user and training documentation; provides direct support for functional users; and values and promotes the mission and vision of the college.

CLASS CHARACTERISTICS:

Under minimal supervision, this technical position will have a variety of professional and highly technical responsibilities in the development and support of enterprise systems from user and vendor specifications. The incumbent will interface with multiple vendors and users to manage and maintain a complex set of enterprise systems. In addition, the incumbent will have a high frequency of contact with other Allan Hancock College staff requiring tact and good communication skills.

ESSENTIAL FUNCTIONS:

  1. Performs the duties of senior level administration of enterprise resource planning (ERP) systems.
  2. Supports the database, applications and functions associated with the ERP system, including technical maintenance and upgrades, module installation, as well as being responsible for research and resolution of the day-to-day operating issues that affect processing services.
  3. Provisions and maintains ERP user accounts and security roles.
  4. Provides technical advice and support to users including troubleshooting issues, creating data extracts and reports, and data analysis.
  5. Configures system enhancements and software fixes; plans for and supports the processing of all upgrades, patches and major releases for these systems.
  6. Coordinates with functional users to develop a thorough and rigorous testing of software and database performance before new versions are put into production.
  7. Performs system analysis and design work for functional users.
  8. Analyzes database efficiency and applies basic tuning strategies that may involve researching and resolving day-to-day operating issues that impact effectiveness.
  9. Performs data extractions and develops integrations to other systems as required.
  10. Creates, modifies and maintains customizations.
  11. Assists other members of the information technology services staff with design, program logic, instruction and database structure.
  12. Debugs programs by preparing test data and evaluate computer output for valid results, satisfying user requests.
  13. Performs data refresh clones of production and test environments.
  14. Monitors database system and performance.
  15. Schedules and completes data submissions required by the Chancellor's Office MIS division.
  16. Coordinates with network administrator on protocols and security to connect the enterprise resource planning (ERP) system to the infrastructure.
  17. Performs other related duties as assigned.

MINIMUM QUALIFICATIONS

Knowledge of:

  • Server hardware, software and enterprise operating systems such as Linux and Microsoft Windows server;
  • Local and wide area networks;
  • Relational data base concepts, tools and techniques including the use of Structured Query Language (SQL) and Open Database Connectivity (ODBC);
  • Oracle or Microsoft SQLServer relational data base management system;
  • Enterprise ERP systems such as Ellucian Banner;
  • Programming languages such as PL/SQL compatible with computer systems in use;
  • General accounting, business procedures and statistical methods;
  • UNIX shell scripting language desirable;
  • Evisions reporting software (Argos, FormFusion, MAPS) desirable;
  • Java Virtual Machine development tools (e.g. Groovy) desirable.

Demonstrated ability to:

  • Develop and maintain databases and computer programs;
  • Prepare documentation and user instructions;
  • Assist in the development and analysis of conceptual and logical design of computer information systems;
  • Communicate verbally and in writing supporting complex system descriptions.

Education and Experience:

Equivalent to a bachelor's degree or higher in computer science, information systems or a related field and five years direct experience in computer information systems programming with hardware, software, and database management systems comparable with Allan Hancock College's ERP systems or equivalent combination of college education, training and experience may be considered.

Working Conditions:

  • This is a FLSA exempt position.
  • Duties are primarily performed in an office environment, at a desk, or at a computer.
  • The incumbent will experience interruptions while performing normal duties during the regular workday.
  • The incumbent will have contact, in person, by email or on the telephone, with executive, management, supervisory, academic, and classified staff and the general public.
  • Work requires travel to other offices or locations to attend meetings or conduct work.

Physical Demands:

  • Typically may sit for extended periods of time.
  • Operates a computer.
  • Communicates over the telephone, by email and in person.
  • May lift, carry, and/or move objects weighing up to 20 pounds.

Special Qualification:

A sensitivity to and understanding of the diverse academic, socioeconomic, cultural, and ethnic backgrounds of staff and students and to staff and students with disabilities.

Exempt 12/17

Restructure9/17

R 7/15

R5/10

R9/04

R6/01

7/90