Analyst 3 - Grant Services
Pima Community College

Pima Community College

Pima Community College Named Top University/College Employer in Arizona

Position Title: Analyst 3 - Grant Services

Department: Grants - District Office

Starting Rate: Band 6 - $59,500 - $67,700

Benefits: Summary

Closed Date: May 6, 2024, 5:00 PM Arizona Time

Position Summary:

The Analyst 3-Grant Services (to be determined by HR) Grant Accountant performs a variety of accounting and financial reporting functions for all types of awards executed by the College. Requires extensive knowledge of accounting practices, internal control management, interpretation of the Code of Federal Regulations (e-CFR), Government Accountability Office (GAO) requirements, Office of Federal Financial Management (OFFM), and Office of Management and Budget (OMB) requirements for federal awards. Assists with College fiscal year-end audit, award audits, and financial inquiries. Prepares comprehensive financial reports for federal, state, and other agencies. Reconciles actual expenditures against grant and other award budgets, prepares adjusting journal entries, completes cash draws and invoicing on behalf of the College for all grant funds using thirteen different funding systems (attached).

The work schedule for this position is flexible and may include working evenings and weekends.

Duties and Responsibilities:

• Reviews and understands each award and subaward agreement executed by the This includes all federal and state compliance requirements. Understands financial requirements required by the type of award and grant record retention and how it applies to audits
• Reviews and understands all District Office financial service areas (Procurement, Contracts, Financial Aid, and Finance) within the College to assist and guide program managers working on different awards
• Monitors and reconciles the general ledger for all grant funds utilizing the College ERP Banner Reviews monthly and inception to date grant expenditure reporting to determine if expense transfers (expense, payroll, revenue) need to be made. Completes cash draws and invoicing on behalf of the College for all grant funds using thirteen different funding systems
• Performs grant close outs by college fiscal year and funder period of performance (POP). Includes reconciling final fund reporting with the College Banner System, including completing the final cash draw or invoicing for the College
• In the Banner ERP System, maintains the setup of each grant to comply with approved, indirect cost rate assignment, matching fund requirement, agency code setup, budget setup, and budget adjustments thereafter from the funder. Includes verifying funder modifications and amendments with information in the Banner ERP System. The Analyst 3-Grant Services and Director for Grant Services must approve new fund number requests
• Reviews all award purchases over $5,000 to ensure they comply with College Procurement Policy, Code of Federal Regulations, and approved award budgets. All purchases over $5,000 must be approved by the Analyst 3-Grant Services prior to requisition set Expense Transfers for purchases and payroll adjustments must also be approved by the Analyst 3-Grant Services and Director for Grant Services
• Prepares comprehensive financial reports for federal, state, and other agencies. Reconciles actual expenditures against grant and other award budgets, prepares adjusting journal entries, and prepares monthly grant invoicing of reimbursable expenses. This includes the FFR SF425, Arizona State Final Completion Reports, and required monthly, quarterly, and annual reporting
• Assists Grant Services by providing financial reporting data on the Schedule of Expenditures of Federal Award (SEFA) to the College Financial Services Department and supports evidence collection for grant audits
• Performs a minimum of two Fiscal Training for all new grant program managers. This includes understanding monthly financial reports (Effort Certification of Payroll, Monthly Expenditures, and Inception to Date Management of the budget allocation)
• Assists with the development of internal fiscal process guides for grants and participates in the Banner financial system testing of forms utilized by grants annually
• Performs all other duties and responsibilities as assigned or directed by the supervisor

• Bachelor's degree in a closely related field of study and
• Three to five years of related technical experience and current certifications

• An equivalent combination of certification, education and experience sufficient to successfully perform the essential duties of the job such as those listed above

• Master's degree in or a closely related field of study
• Five to eight years of related experience