City of Tampa

Accounting & Budget Systems Coordinator (#023400) N35

$37.42-$56.11 Hourly / $6,486.13-$9,725.73 Monthly / $77,833.60-$116,708.80 Yearly


Introduction

This is highly responsible administrative and professional work in managing, maintaining, developing and improving the accounting, budgeting and other records, processes, reporting and systems for the Revenue & Finance Department.

Nature Of Work

An employee in this class is responsible for the administration, configuration, and control of the City’s accounting, budgeting and billing systems (currently FAMIS, BPREP, FAACS, MSS, etc.) as well as providing various reports and data extracts to departments.  Work is of considerable difficulty and includes creating and maintaining configuration tables, parameters, accounting processes, and control/edit codes that govern all posting to the general ledger. It requires the application of knowledge of principles, practices, and procedures of accounting, budgeting, problem solving, management, federal and state laws and guidelines relating to financial transactions (e.g. public records law, internal controls, etc.), and computer applications.   This position is responsible for ensuring the integrity of the general ledger by testing and reviewing new accounting and budgeting procedures and processes as well as reviewing changes made to the accounting and budgeting tables by staff. The employee in this class administers and coordinates the training of personnel on Revenue & Finance Department systems, maintains security for the same, establishes policies and procedures and has general oversight over the department’s information and security systems, including (but not limited to) banking systems, E-payables, accounting processes, budget processes, etc.  Work involves the application of technical and functional knowledge and skill in accounting and budgeting administration, records maintenance, and accounting and budget resource system projects.  It also requires extensive initiative and independent judgement in coordinating with T&I and the various Payroll, Purchasing, Human Resources, Billing and other internal departments and external processes and systems and consulting with managers and employees regarding the application of accounting and budgeting policies and processes.  Work is performed under direction and reviewed by conferences, reports submitted, and results achieved.

Examples of Duties

Functions as FAMIS, BPREP, FAACS, etc. administrator including troubleshooting, assisting users, identification and documentation of reports, testing programs and resolving problems with software consultants; approves and maintains FAMIS, BRPEP, etc. security and system tables; develops FAMIS, BPREP, etc. reports; proposes system upgrades and procedural modifications. Provides security and configuration management for the accounting system (FAMIS), budgeting system (BPREP), fixed asset system (FAACS), ad-hoc report system (Systemwide), banking software (Bank of America Direct), credit card processing (Cybersource and Bank of America Works) and pension (JP Morgan Access);  creates and distributes annual accounting access security confirmation forms to all department heads and makes appropriate changes.  Reviews daily control reports; identifies items responsible for out of balance conditions and initiates corrective actions; coordinates with departmental users to complete or correct transaction errors in the system; reviews daily table maintenance log to verify table entries meet standards and verify that authorized users have made the updates.  Develops reports and data extracts using the ad-hoc reporting tools in the accounting and budgeting systems to support requests from the accounting and budget offices, auditors, other departments and public information requests; configures tables and run jobs that apply indirect costs to capital projects and reconciles output; executes batch jobs that distribute interest across sub-funds; runs and reconciles batch processes to generate reversal and reposts transactions to correct batch interface errors.  Develops systems calendar that provides deadlines for the accounting, budgeting and other systems for various processing events (weekly, bi-weekly, monthly, year-end); analyzes registers and reports and resolves discrepancies; coordinates, sets up, and executes year-end tests and production processes for annual closing of systems and roll over into new year; coordinates changes to control file maintenance with T&I and assures all data transactions are entered into the system; validates and documents accuracy of resulting output; executes processes to load the initial annual budget into the general ledger; opens and closes fiscal periods as needed to support closing entries.  Evaluates requests for changes to the accounting system configuration; determines potential impact of these changes to the general ledger as well as impact to external systems and processes such as payroll, budget, and cashiering; researches and tests usage of features that are in the current system and not currently implemented such as grant reporting, program accounting, and ACH payments; coordinates the interaction of the interfaces between accounting, budget fixed assets, and procurement.  Provides training, technical advice and guidance to staff; prepares reports and correspondence; serves as department contact for audit reporting and analysis needs; creates course material, schedules and regularly conducts computer training classes for departmental staff and new personnel on FAMIS, BREP, etc.; creates new forms for the Revenue & Finance Department and develops and implements methods for department feedback, surveys, etc.; designs and updates Revenue & Finance Department website; researches accounting and budgeting system trends, policies and procedures, etc. Consults with employees and departments on accounting and budgeting questions; consults with vendors as necessary. Performs related work as required. 

Knowledge, Skills & Abilities

Extensive knowledge of:  modern management practices and procedures; modern office practices, procedures, and equipment.   

Considerable knowledge of: accounting and budgeting systems, local government accounting and budgeting practices and control, GAAP and GASB accounting practices, budget best practices and audit procedures.   

Ability to: plan, organize, coordinate, and review the work of professional and clerical personnel analyze reports and statistics; organize and present factual findings in a clear and concise manner and make sound recommendations; create and follow procedures, policies, and standards; establish and maintain effective working relationships with other employees, officials, and the general public.

Minimum Qualifications

Graduation from an accredited college or university with a bachelor’s degree (master’s degree preferred) in business or public administration, accounting, information systems or related field and three (3) years of progressively responsible municipal accounting, budgeting or accounting information system experience,  and experience with FAMIS accounting software and BPREP budgeting software, information systems and computer applications and work processes; or an associate's degree in business or public administration, accounting, information systems or related field and five (5) years of progressively responsible municipal accounting, budgeting or accounting information system experience

Licenses or Certifications

Possession of a valid drivers license may be required.

Comments

Employees may be required to work rotating shifts, including nights, weekends, holidays and overtime as needed. During periods when the Mayor issues an emergency declaration for the City of Tampa, all employees may be required to work in preparation, response or recovery activities related to the stated emergency.

CLASS: 023400; EST: 8/7/2013; REV: 2/28/2018;