JOB DESCRIPTION

 

 

JOB TITLE:  Fiscal Systems Administrator

 

MAINTENANCE REVIEW DATE:  May 1999

 

ORG/POS #:  1110/2743

 

JOB OBJECTIVE:  To ensure the accuracy and synchronization of on-line and off-line financial and payroll system account balances; to direct the conversion, implementation, maintenance, security, and user training for assigned computer systems.

 

ACCOUNTABILITY:  Receives general supervision from the City Controller.

 

ESSENTIAL JOB FUNCTIONS:

 

1.         Analyzes existing data processing applications to determine the capability of existing systems to meet departmental needs; provides information to the Department of Management Support relative to changes or additions to the existing systems necessary to improve efficiency and meet the needs of the Finance Department.

 

2.         Supervises the testing of finance and payroll system updates; ensures testing is completed according to established schedules.

 

3.         Plans and presents user training programs for City department employees regarding finance and personnel computer systems.

 

4.         Ensures the accuracy of on-line and off-line financial accounts by verifying financial system printouts; researches all discrepancies between on-line and off-line data processing reports including financial status; determines and documents errors and requests reruns after corrections have been made.

 

5.         Assigns and changes user access codes to financial and payroll data; maintains a security file of all codes.

 

6.         Transfers finance and payroll system data from mainframe computer system onto diskettes for processing on microcomputers; provides assistance to other Finance Department employees by transferring finance and payroll systems data from the mainframe computer system into microcomputer software applications used for budget purposes.

 

7.         Provides assistance in maintaining Finance Department computers by troubleshooting problems with the Department of Management Support personnel.

 

8.         Maintains finance server and connections to City network; coordinates user access to network.

 

JOB TITLE:  Fiscal Systems Administrator

JOB DESCRIPTION - CONTINUED

 

 

SECONDARY DUTIES AND RESPONSIBILITIES:

 

1.         Researches available materials to determine data processing applications required to meet accounting or financial needs and requirements; recommends new systems or changes to existing systems to meet current or anticipated data processing needs.

 

2.         Operates a microcomputer and related data processing equipment to compile, analyze and prepare financial reports and conduct research; designs customized reports utilizing the finance and payroll system.

 

3.         Serves as Project Manager as assigned by planning and directing computer system conversions or implementations.

 

4.         Maintains contact with data processing and finance personnel in other cities to compare system designs and provide a resource for implementation problems.

 

5.         Develops and maintains procedure manuals for the finance and payroll computer systems; updates manuals as required to ensure current procedures are followed by all persons entering data.

 

6.         Provides general working supervision to personnel assigned on a project basis.

 

7.         Performs other related duties as required.

 

SUPERVISORY RESPONSIBILITIES:

 

None.

JOB SPECIFICATION

FISCAL SYSTEMS ADMINISTRATOR

 

 

GENERAL STATEMENT OF DUTIES:  Performs work of considerable difficulty in ensuring the accuracy and synchronization of on-line and off-line financial and payroll system account balances, and in directing the conversion, implementation, maintenance, security, and user training for assigned computer systems.

 

MAINTENANCE REVIEW DATE:  May 1999

 

EXAMPLES OF WORK:  (Illustrative)

 

Analyzes existing data processing applications to determine the capability of existing systems to meet departmental needs; provides information to the Department of Management Support relative to changes or additions to the existing systems necessary to improve efficiency and meet the needs of the Finance Department.

 

Supervises the testing of finance and payroll system updates; ensures testing is completed according to established schedules.

 

Plans and presents user training programs for City department employees regarding finance and personnel computer systems.

 

Ensures the accuracy of on-line and off-line financial accounts by verifying financial system printouts; researches all discrepancies between on-line and off-line data processing reports including financial status; determines and documents errors and requests reruns after corrections have been made.

 

Assigns and changes user access codes to financial and payroll data; maintains a security file of all codes.

 

Transfers finance and payroll system data from mainframe computer system onto diskettes for processing on microcomputers; provides assistance to other Finance Department employees by transferring finance and payroll systems data from the mainframe computer system into microcomputer software applications used for budget purposes.

 

Provides assistance in maintaining Finance Department computers by troubleshooting problems with the Department of Management Support personnel.

 

Maintains finance server and connections to City network; coordinates user access to network.

 

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:

 

Considerable knowledge of electronic information processing systems, including operating systems, database systems, and system applications related to financial and accounting areas.

 

Considerable knowledge of accounting and finance principles and practices.

 

Good knowledge of COBOL computer language.

 

JOB TITLE:  Fiscal Systems Administrator

JOB SPECIFICATION - CONTINUED

 

 

Good knowledge of research methods and techniques.

 

Good knowledge of the budget process.

 

Good knowledge of descriptive and inferential statistics.

 

Good knowledge of AFIN accounting and financial mainframe computer systems, or a similar mainframe accounting and financial system.

 

Skill in the operation of a microcomputer and peripheral equipment.

 

Skill in the operation of a computer terminal.

 

Ability to design and implement new database systems based on accounting, financial, and payroll/personnel needs.

 

Ability to develop procedural guidelines related to the finance and payroll/personnel computer systems.

 

Ability to design and extract computer reports from the payroll/personnel and finance computer systems.

 

Ability to develop and implement plans for conversion and/or upgrading computer systems, including ongoing user training.

 

Ability to code and debug business applications, programs, and structured COBOL.

 

Ability to analyze and interpret research findings.

 

Ability to read and interpret complex financial reports.

 

Ability to prepare detailed narrative and statistical reports.

 

Ability to communicate effectively, both orally and in writing.

 

ACCEPTABLE EXPERIENCE AND TRAINING: 

 

Completion of a Bachelor’s Degree in Accounting, Finance, or a related area; at least two (2) years of experience in accounting, finance, or a related area; at least two (2) years of experience in mainframe computer programming related to finance or accounting systems; at least two (2) years of experience utilizing AFIN accounting and financial mainframe computer system, or a similar mainframe accounting and financial system, or a related area; OR any equivalent combination of experience and training which provides the required knowledge, skills, and abilities.

JOB TITLE:  Fiscal Systems Administrator

JOB SPECIFICATION - CONTINUED

 

 

PHYSICAL REQUIREMENTS:  The physical demands marked below are representative of those that will be required to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

                                                                            YES                                                                            NO

Lifting (lbs.)	25
Carrying (lbs.)	25
Stooping, Bending		ü
Kneeling, Squatting	ü
Walking	ü
Standing	ü
Sitting	ü
Climbing, Balancing (e.g., climbing and working from ladder)		ü
Use of Hands to Finger, Handle, or Feel	ü
Physical Coordination (sequential or simultaneous use of hands, arms, feet, and legs)		ü
Eye-Hand Coordination	ü
Close Vision (clear vision at 20" or less)	ü
Distance Vision (clear vision at 20' or more)		ü
Color Vision (ability to identify and distinguish colors)		ü
Depth Perception (ability to judge distance spatial relationships)		ü
Hearing	ü

 

WORK ENVIRONMENT:

 

The environmental conditions marked below are common to this job:

 

                                                                            YES                                                                            NO

Outdoor Weather Conditions		ü
Wet, Humid Conditions (non-weather)		ü
Work Near Moving Mechanical Parts		ü
Work in High, Precarious Places		ü
Fumes or Dust		ü
Toxic or Caustic Chemicals		ü
Extreme Heat (non-weather over 90º F.)	ü
Low Noise (e.g., business office)		ü
Moderate Noise (e.g., light motorized equipment such as lawn mowers)		ü
Loud Noise (e.g., jackhammer, heavy motorized equipment)		ü