2A68
PAY RANGE: EP24
INFORMATION SYSTEMS AUDIT SUPERVISOR
This is supervisory information systems auditing work utilizing computer equipment, data files and applications programs to assist the Post Audit Division in conducting financial, compliance, performance and departmental audits for City of Philadelphia and the School District of Philadelphia and in providing reports in response to requests for data analysis from other divisions of the Controller’s Office. An employee in this class supervises a staff of full performance information systems auditors engaged in planning, selecting, modifying, and writing programs in order to analyze and audit data maintained on system-wide and departmental computer based management information systems. Work includes utilizing the more difficult applications programs and performing the most difficult analyses. Contact with information management personnel and administrators is an important aspect of the work. Work is performed under the direction of an administrative superior.
ALLOCATING FACTORS: (The following conditions must be met for a position to be approved for this class.)
· The position must be located in the City Controller's Office.
· The position must be responsible for supervising full performance Information Systems Auditors in analyzing and auditing electronic data and developing reports to effectively meet user needs.
TYPICAL EXAMPLES OF WORK (ILLUSTRATIVE ONLY)
Plans, assigns, and reviews the work of a staff of information systems auditors engaged in examining system-wide and departmental computer based financial information systems and related records; assists in training staff in the use of hardware and software packages, flow-charting conventions, and programming techniques; evaluates performance of assigned staff.
Plans, implements, maintains and updates software and hardware for departmental information systems run in a network and mainframe environment; monitors system performance and develops recommendations for correction or improvement; implements and maintains strategies for data security; assigns user rights for accessing citywide systems.
Selects appropriate programs to perform desired analysis; modifies programs to meet specific criteria; analyzes objectives and prepares flow charts in order to write new applications programs; determines if correct file has been accessed and program is running correctly; reviews resulting output ; identifies and documents exceptions for unresolved discrepancies ; prepares work paper documentation, and writes summary reports indicating the nature of the request, work performed, findings, and conclusions. Selects, modifies, and writes applications programs; calculates sample size and generates sample printouts for use in attribute and substantive tests of transactions.
Performs a variety of system-wide computerized financial and payroll audits; examines selected pay periods for correct payroll calculations, accurate tax and benefit deductions, and correct coding; compares selected cash receipts footings against established totals; compares monthly inventory balances with prior month's balance and annotated changes by commodity category; examines and re-calculates selected daily system-wide accounting records; randomly selects taxpayers to establish accuracy of unpaid account totals.
Performs database maintenance activities; reviews electronic data to verify accuracy; reconciles computer-error discrepancies; notes exceptions and orders data files copied and stored; creates databases in order to prepare trend analysis of system-wide financial and payroll data over extended time periods; runs multiple queries on departmental databases to identify target populations; provides technical assistance to personal computer users; corrects minor technical problems with equipment; transfers files, when applicable, between mainframe, servers and personal computers; assists with software maintenance
Familiarizes superiors and staff in technical updates to current software, new software specifications, and changes in system-wide data processing procedures; performs research and analysis on software and hardware under consideration: makes recommendations on the purchase of new software and hardware packages; participates in the selection, training and development of Information Systems Auditors; participates in data processing and auditing continuing education programs.
Performs related work as required.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
KNOWLEDGE OF:
· generally accepted auditing standards and accounting principles
· the functions, goals and objectives of a large governmental organization
· the current uses and capabilities of electronic data processing equipment with particular emphasis on mainframe, and personal computers
· principles, methods and techniques used in computer programming and systems analysis and design
· the principles, methods and concepts used in data extraction and data base management
· the conventions used in systems flowcharting
· the programming principles of major software packages used in auditing computer based data
SKILL IN:
· reviewing financial and accounting documents and methods of internal control for conformance to governmental and private accounting standards, noting exceptions, and making recommendations for correction
· adopting major software packages to the audit process
ABILITY TO:
· direct and supervise information systems auditors engaged in the analysis and audit of electronic data for a variety of operations and agencies
· prepare a variety of ad hoc reports to meet the needs of users
· analyze and evaluate proficiency, work flow, and staff utilization to increase efficiency
· simultaneously perform numerous IT related duties
· organize and prioritize multiple tasks
· establish and maintain effective working relationships with associates and representatives of agencies being audited
· communicate effectively both orally and in writing
MINIMUM ACCEPTABLE TRAINING AND EXPERIENCE (The following statement represents the minimum training and experience standards which will be used to admit or reject applicants for tests. Applications submitted by candidates for this class will be reviewed based on training and experience requirements as approved on 8/15.)
EDUCATION:
Completion of a bachelor's degree program at an accredited college or university with a major in accounting or certification as a Certified Public Accountant by the Commonwealth of Pennsylvania.
AND
GENERAL EXPERIENCE:
Two years of experience auditing a variety of fiscal operations and records.
SPECIFIC EXPERIENCE:
Two years of specialized information systems auditing experience which includes the use of applications programming and use of computer systems to facilitate auditing tasks.
OR
One year of advanced level specialized data processing and auditing work utilizing digital data files and computer application programs to assist in conducting financial, compliance, performance and departmental audits.
Or any equivalent combination of education and experience determined to be acceptable by the Office of Human Resources that has included the specific experience.
PHYSICAL AND MEDICAL REQUIREMENTS
Ability to physically perform the duties and to work in the environmental conditions required of a position in this class.
CSC - 7/02
Ad. Board - 9/02
CSC – 2/10
Ad. Board - 3/10
Latest Spec. Revision
CSC – 8/15
Ad. Board – 8/15
JL