Performs information systems support and analysis for a specified function or area within a department and ensures that all concerns are addressed and closed within the prescribed practices and required timeline.

• Performs systems analysis and provides systems support in a specified application area

• Develops, oversees, and maintains information systems

• Produces various reports for functional areas

• Consults with staff from functional areas and users to determine information processing needs and to design/identify specific training programs

• Designs technical systems specifications describing information processing functions required by the users

• Evaluates and recommends use of commercial software in application area

• Provides input to consultants regarding user needs and acceptability of alternatives for development of assigned systems

• Coordinates with systems programmers

• Evaluates systems to ensure that user requirements are properly satisfied

• Troubleshoots, analyzes, and resolves user and systems problems

• Monitors system performance and integrity

• Designs and implements upgrades to user interface

• Communicates system upgrade needs to ITS (Information Technology Services)

• Responds to system emergencies

• Researches and prepares reports, systems training manuals, and technical systems documentation

• Monitors historic data to ensure proper records retention

• Participates in the department's information security, disaster recovery, and safety programs

• Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out

  
  May be required to perform other related job duties

Knowledge of (defined as a learned body of information that is required for and applied in the performance of job tasks)

• Theories, principles, and practices of specified application areas and systems analysis and design

• Applicable software, such as Crystal Reports, .NET Framework, etc.

• Analysis, research procedures, and reconciliation of information

• Capabilities of large-scale computer systems

• Personal computer hardware and software

• System administration, security practices, and user management

• Query generation, data organization, and database design

• Statistical analysis and data interpretation

Skill in (defined as the proficient manual, verbal, or mental utilization of data, people, or things)

• Analyzing and designing information systems in a specified application area

• Listening to users, interpreting needs, and providing support

• Managing database information and developing data warehouses, using systems such as Oracle Database

• Application utilization, maintenance, planning, troubleshooting, and upgrades, such as Crystal Reports

• Basic programming languages, such as SQL (Structured Query Language), Crystal Syntax, etc.

• Troubleshooting system problems and developing solutions

• Preparing easily consumable reports, professional e-mails, and correspondence

• Exercising sound judgment and creativity in making decisions

• Communicating effectively orally and in writing

• Interacting professionally with various levels of Metro employees and outside representatives

Ability to (defined as a present competence to perform an observable behavior or produce an observable result)

• Compile, analyze, and communicate system information and data

• Think and act independently

• Find creative solutions to problems

• Handle highly confidential information

• Meet tight time constraints and deadlines

• Read, understand, interpret, clarify, and apply laws, rules, regulations, policies, procedures, contracts, budgets, and labor/management agreements

• Train users in implemented systems

• Read, write, speak, and understand English

A combination of education and/or experience that provides the required knowledge, skills, and abilities to perform the essential functions of the position. Additional experience, as outlined below, may be substituted for required education on a year-for-year basis. A typical combination includes:

Education

• Bachelor's Degree in Computer Science, Information Systems, or a related field

Experience

• One year of relevant experience performing work within a department leading to an understanding of systems for computerization or programming in FOCUS and other user-oriented languages

Certifications/Licenses/Special Requirements

• A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions

The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job. Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions.

Working Conditions

• Typical office situation

• Close exposure to computer monitors and video screen

Physical Effort Required

• Sitting at a desk or table

• Operate a telephone or other telecommunications device and communicate through the medium

• Type and use a keyboard and mouse to perform necessary computer-based functions

• Communicating through speech in the English language required