Job SummaryThe purpose of this position is to lead in management of the accounting, financial reporting, and audits of the City’s Federal, State, and Local grant funded programs. This is accomplished through working directly with city staff, grant program managers and outside agencies in administering the City’s grant funding by setting up budgets, recording grant related transactions, performing grant reconciliations, and assisting as needed with billing and collections. This position also provides support for the annual audit including review and preparation of the Annual Comprehensive Financial (ACFR) and Schedule of Expenditures of Federal Awards (SEFA).
Essential Job FunctionsKey Responsibilities:- Understands multiple grant programs and contracts where each has its own laws, regulations and uniqueness that need to be adhered to for maximum fund reimbursement and compliance with the grant primary purpose.
- Creates and provides oversight to grant program managers on grant budgets.
- Serves as the Finance department lead in management of audits performed by granting agencies in coordination with grant program managers.
- Assists with preparation and review of annual reporting schedules including but not limited to tables and notes for the Annual Comprehensive Financial Report (ACFR) and the SEFA/ SESA for the Single Audit report.
- Works in conjunction with the external auditors on the yearly audit and provides all auditor requested information.
- Conduct daily and long-term special projects as assigned with limited direction.
- Special projects and other duties as assigned.
Compliance- Ensures compliance with generally accepted accounting principles as prescribed by GASB and maintains the integrity of the General Ledger (GL) through research, analysis, and reconciliation to subsidiary systems.
- Research and disseminate each granting agency’s unique regulations to gain understanding of allowable activity for grants. Advise and educate staff, grant program managers and external customers to ensure compliance.
- Review all required grant agency reports according to each grant’s unique regulations and requirements.
- Review required internal and external agency reporting requirements including monthly, quarterly, and yearly cost reimbursement review and submission.
- Train and guide staff according to established city policies, procedures and guidelines.
- Review and recommend updates to grants policies and procedures on an annual basis.
- Review and/or assist with council agenda items for all grants for Council approval.
Accounting- Understand and apply Generally Accepted Accounting Principles and GASB for governmental funds, propriety funds, fiduciary funds.
- Manage the full grant life cycle, including grant setup, budget line-item creation, financial tracking, and grant closing to ensure compliance and proper fund utilization.
- Monthly maintenance and reconciliation of grants and grant funds by reviewing, correcting recording of revenues, expenditures, assets, liabilities and equity.
- Review year-end accruals and adjust journal entries for all grants.
- Coordination of granting agency audits. Review of grant program manager and grant accounting staff workpapers.
Reporting- Prepare and review grant-related budgets and financial statements including Balance Sheets, Income Statements, and Statements of Cash Flow.
- Prepare ACFR/ Single Audit and other reports for City grant-related funds.
- Prepare grant-related supporting schedules and audit workpapers.
- Review and preparation of ad hoc and routine internal and external reporting.
- Oversee the submission of monthly, quarterly, and/ or yearly cost reimbursement reports to the granting agencies, ensuring that the City receives all reimbursements from the granting agencies on a monthly basis.
- Ad hoc and routine reporting for departmental grant program managers.
- Special requests from both Financial and other department management for information. This may require extensive research and analysis of past financial activity, locating transactions or documents, and presentation in an understandable format.
Communication- Develop strong working relationships with other Departments and agencies.
- Ensure processes and procedures are communicated, documented and that staff are properly trained to minimize audit findings.
- Research/review of potential grant opportunities, notifying departments of opportunities and documenting effort/results of application.
- Work with grant program managers and staff to provide technical guidance, direction, leadership and training to ensure funds are fiscally allocated accurately and in compliance with current grant laws and regulations.
- Meet with departments monthly to review grant performance (discuss progress, review budgets, make adjustments as needed, and advise on areas for improvement)
Minimum QualificationsAny combination equivalent to experience and training that would provide the required knowledge, skills, and abilities may qualify. A typical way to obtain the knowledge, skills and abilities would be:
- Education: Bachelor’s degree of equivalent.
- Experience: 3 years of related experience.
- Preferred Qualifications: Experience working in Lawson or other legacy systems, experience working, through financial software implementation, and professional certifications such as CPA or CMA.
- Licenses: Valid Texas Class C Driver's License.
- Certifications Required: None
Closing Date/Time: 5/2/2025 5:00 PM Central