Financial System Analyst
ESSENTIAL FUNCTIONS: (Essential functions, as defined under the Americans with Disabilities Act, may include the following tasks, knowledge, skills and other characteristics). This list is ILLUSTRATIVE ONLY and is not a comprehensive listing of all functions and tasks performed by incumbents of this class.DUTIES AND RESPONSIBILITIES: (which are not in any hierarchical order)
- Imports financial data files from financial applications and external sub-systems and posts to the general ledger. Analyzes data imported to ensure accuracy and that data has posted correctly.
- Monitors financial system performance to include identifying, diagnosing, and fixing system problems.
- Plans, schedules, and coordinates the implementation of system upgrades including all external systems interfacing to the general ledger.
- Participates in set-up and testing of new financial applications and upgrades of existing financial applications including new interfaces from new external systems to the general ledger.
- Sets up and imports annual budget documents to include establishing new year calendar, new accounting periods, setting up the new year budget organizations, budget ranges, account summary templates.
- Sets up data loader for automatic approval of all blanket purchase orders.
- Opens new accounting periods for all financial applications to include running system optimizer, updating summary account templates, and budget maintenance.
- Schedules and reviews nightly processing of accounts payable transactions, weekly processing of fixed assets and twice a month processing of inventory transactions. Closes accounting periods on a monthly basis to ensure an integrated month-end closing of the books.
- Produces senior management reports as requested.
- Researches applications, related questions and problems using a variety of resources. Changes system profiles or coordinates the implementation of a solution with appropriate party.
- Trains and assists users in the utilization and operation of financial management software applications. Develops and recommends procedures for the proper use of applications to include setting up new account segments, and assigning responsibilities to new users, and/or changing the responsibilities of current users.
- Reconciles daily the cash clearing accounts for payments received from multiple external sub-systems. Reconciles on a monthly basis all inventory accounts
- Knowledge of GAAP (Generally Accepted Accounting Principals).
- Knowledge of integrated database software to run financial applications.
- Knowledge of word processing, spreadsheet, and data base applications.
- Knowledge of financial management system software functions and capabilities.
- Knowledge of data storage and data manipulation techniques and practices.
- Knowledge of computer hardware and software diagnostic methods and techniques.
- Knowledge of the principles and practices of customer service.
- Knowledge of daily business functions of the organization and the system functions which process/control the data of the organization.
- Skill in using general office equipment such as telephone, fax, printers, copiers, calculators, and computers.
- Skill in controlling, prioritizing, tracking and completing multiple tasks, some with competing deadlines.
- Skill in researching application related questions and problems, arriving at a proposed solution, testing the solution and communicating the solution to others.
- Skill in reading, interpreting and applying concepts found in manuals, City regulations, standards and guidelines.
- Skill in setting up complex financial report formats to meet the needs of management.
- Skill in using computer applications such as word processing, spreadsheet, and database programs.
- Ability to communicate effectively both orally and in writing.
- Ability to establish and maintain effective working relationships with those contacted in the course of work.
MINIMUM QUALIFICATIONS: Bachelor’s degree from an accredited college or university with a major in Information Systems, Business Administration, Computer Science or closely related field with a minimum of two semesters of course work in accounting, and two (2) years experience setting up and maintaining financial management software applications, or any equivalent combination of training and experience. Completion of specialized software training is preferred and experience with Oracle financial applications is preferred.
Last revision: December 2006