Accounting Systems Analyst

Under the general direction of the Controller, the Accounting Systems Analyst develops and administers computer security and set up of the account structure and user access for the college’s business system. Develops policies and procedures for maintaining internal system controls of the college’s business system. Posts daily transactions, runs month-end and year-end reports and performs the month-end and fiscal year-end closing procedures. In addition, assists with database management for various accounting projects including budget development, unit cost study report, and the college’s fixed asset system. The Accounting Systems Analyst is dedicated to the learning college concepts by developing programs and facilitating activities that promote student success and lifelong learning.

1. Maintain the college’s account structure by setting up new funds, programs, budget codes, object codes, and user access.

2. Maintain the college’s financial system by inactivating and removing old accounts and removing access of employees upon departure from college.

3. Assist the Controller in defining data requirements and report specifications to meet identified information needs, with the help of an application developer.

4. Work with an applications developer to define and develop detailed specifications for programming solutions.

5. Write ad hoc reports using Synoptix software and Excel. Utilize advanced Excel functions to extract various data sets for analysis.

6. Work with other Accounting employees to coordinate projects and department procedures.

7. Prepare data file for budget developer program.

8. Maintain position salary database, update monthly with salary changes, extract data for budget process.

9. Post daily journal entries to the general ledger and review daily system-generated general ledger reports for accuracy.

10. Complete month end close including posting all month-end journal entries and running closing procedures. Generate month-end board reports to be reviewed by the Controller.

11. Assist with the College’s audit by running year-end reports, prepare journal entries including year-end accruals, and create other documents as needed. Prepare state reports required by ICCB.

12. Complete fiscal year-end closing procedures at the conclusion of the audit.

13. Provide technical support to finance personnel and serve as liaison in implementing, monitoring, and refining systems related to budgeting, accounting, accounts payable, capital assets, and grants management.

14. Work as a liaison between all College departments and Finance office for account access.

15. Assist with other reporting requests as necessary.

In addition to the above requirements, to perform this job successfully, an individual must be able to perform each essential duty satisfactorily.