Financial Accounting & Reporting Analyst
University Accounting & Financial Reporting
University of Illinois System
The University System Office seeks a Financial Accounting & Reporting Analyst to work under administrative direction, perform University Accounting functions related to Banner bank and fund reconciliations, data analysis, and customer service functions related to University Payroll finance transactions posted to Banner general and operating ledgers and provide highly specialized functional and technical support in other payroll, general ledger, and operating ledger areas; assist with the development of policies and procedures for assigned areas of responsibility in compliance with specialized university, state, and federal regulations. Additional responsibilities include:
Duties and Responsibilities:
1. Analyze and resolve payroll accounting associated issues related to Banner general and operating ledger transactions and balances. Includes complex analysis of operating and general ledger payroll data and communication with OBFS – University Payroll and Benefits and departmental fiscal officers and administrators to resolve resulting posting matters. Serve as a subject matter expert in the area of gross wage and fringe benefit payroll transactions in the general ledger. Serve as an advisor to units regarding labor redistributions.
2. Perform monthly reconciliations of bank accounts and subsidiary balances to general ledger balances. Reconciliation involves complex analysis of payroll and non-payroll related transactions, review for appropriateness of transactions, communication with departmental fiscal officers and administrators to determine appropriate ledger treatment of transactions, and posting required correcting entries to appropriate records. Reconciliations are highly specialized and complex due to the unique nature of State of Illinois regulations for higher education institutions, intricate nature and volume of transactions, and requires and in-depth understanding of the Banner payroll calculation processes and the various finance system modifications contained in the Banner HR/Finance interface.
3. Resolve encumbrance issues for departments, payroll and non-payroll related. This task involves analyzing the posting of encumbrances and determining the proper method of correction. This task also involves analyzing complex payroll data for current and future year labor encumbrance questions. This task requires an in-depth understanding of the labor and fringe encumbrance process, and various HR, finance, and grant data used in the calculations.
4. Assist in preparation of responses to audit requests, audit findings, special reports, and requests for information. Includes writing queries, preparation of reports, and/or working with campus departments to retrieve supporting documentation to justify calculations to auditors. This requires an in-depth understanding of specific earnings and deduction codes which impact the applicable gross wages for fringe benefit assessments.
5. Analyze Banner payroll related activity by fund type, including termination benefits, to determine its appropriateness and initiate necessary corrections. This requires an in-depth understanding of the rules and restrictions for each fund type at the University of Illinois.
6. Initiate and develop financial queries using database applications such as SQL and Microsoft Access to fulfill analytical review, reconciliation, and reporting requirements.
7. Participate in executing assignments to complete annual OBFS goals that require accounting, technical, data analysis, and business expertise. These activities include serving on project teams; researching, reviewing and documenting current processes; and developing, documenting, and implementing new processes.
8. Serve on University Accounting and Financial Reporting (UAFR) or OBFS committees/teams as a representative of UAFR as assigned (e.g. team to develop an accounted related certification program, OBFS website committee, UAFR Professional Development Implementation Team, etc.).
9. Develop and complete reports to meet financial reporting needs and fulfill State, University, and other fiduciary and regulatory requirements.
10. Assist with special projects, such as year-end data scrubbing, as assigned by the Associate Director.
11. Prepare technical documentation of accounting procedures and processes for inclusion in the University Accounting Services Accounting Operations Manual, which is used as a reference and training resource by staff. These processes and procedures include functions for which this position is directly responsible, as well as other areas as assigned.
12. Perform other assigned duties appropriate for a Financial Accounting and Reporting Analyst in the Accounting Associate classification.
Education and Experience:
A. Bachelor's degree with a major in Accountancy or a related field AND two (2) years of professional level accounting experience. OR
B. Possession of current registration as a Certified Public Accountant (CPA), Certified Management Accountant, or a valid license to practice Public Accounting (LPA). OR
C. Master's degree in Accountancy or a related field.
Knowledge, Skills and Abilities:
1. Working knowledge of accounting principles.
2. Demonstrated analytical skills to perform complex financial analysis of business transactions.
3. Ability to produce complex financial reports and provide detailed information with accuracy and clarity.
4. Ability to propose policies/procedures that improve and/or maintain the effectiveness of daily financial operations.
5. Strong verbal and written communications skills to effectively present information and respond to requests for guidance and/or clarification.
6. Ability to address and resolve difficult and complex issues/problems; strong interpersonal skills to establish and maintain effective working relationships.
7. Ability to multi-task and produce accurate, detail-oriented work to meet stringent deadlines; creativity in problem solving and exercising independent judgment and discretion.
8. Proficient computer skills including Microsoft Excel, OneNote, and Outlook.
9. Desire and ability to provide presentations and formal training to the University community.
10. Proficiency in database, query and reporting tools (e.g., MS Access, SQL, etc.).
11. Ability to work under pressure is required to perform a variety of responsibilities and ensure daily operational needs are met.
Work is performed in an office setting and is sedentary for the most part. No unusual physical exertion is required. Work environment has frequent interruptions and distractions that create an atmosphere ranging from calm to chaotic.
SALARY AND APPOINTMENT INFORMATION
This is a full-time Civil Service Accounting Associate position appointed on a 12 month service basis. The expected start date is as soon as possible after November 4, 2019. Salary is commensurate with experience.
Applications must be received by November 4, 2019. Apply for this position by using the “Apply for Position” button below. If you have not applied before, you must create your candidate profile at http://jobs.illinois.edu. If you already have a profile, you will be redirected to that existing profile via email notification. To complete the application process:
Step 1) Submit the Staff Vacancy Application.
Step 2) Submit the Voluntary Self-Identification of Disability forms.
Step 3) Upload your cover letter, resume (months and years of employment must be included), academic credentials (unofficial transcripts or diploma may be acceptable) and names/contact information for three references.
In order to be considered as a transfer candidate, you must apply for this position using the “Apply for Position” button below. Applications not submitted through this website will not be considered. For further information about this specific position, contact Melissa McMullen at firstname.lastname@example.org. For questions about the application process, please contact 217-333-2137.
The University of Illinois conducts criminal background checks on all job candidates upon acceptance of a contingent offer.
The University of Illinois is an Equal Opportunity, Affirmative Action employer. Minorities, women, veterans and individuals with disabilities are encouraged to apply. For more information, visit http://go.illinois.edu/EEO.
College Name or Administrative Unit:
Financial Accounting & Reporting Analyst (122732)
Univ Acct and Fin Report