Closing: 8/19/2021 11:59pm EST
Hiring Range: $59,595 – $85,000 annually
The City of Raleigh is looking to hire a fiscal grant position as the American Rescue Plan Act (ARPA) funding released by the US Treasury will require incremental administrative and fiscal management efforts as the City works to make this once in a lifetime funding positively impact our community for years to come. These tasks include managing and overseeing the life cycle of the grant processes, monitoring and tracking costs, overseeing sub-recipients, collaborating with external and internal partners, filing periodic required reports with the Treasury and creating transparent reporting for City Council and the larger community.
The City of Raleigh is looking for a highly competent and motivated individual to oversee the City’s fiscal management activities associated with ARPA grants. Candidates will have the unique opportunity to collaborate with departments and positions throughout municipal government. The Grants Program Fiscal Manager (ARPA) serves as a subject matter expert providing consultation to fiscal services staff, directors, and the Grants Committee. This position helps support departments in the post-award phase of grants administration. The Grants Program Fiscal Manager (ARPA) is at the forefront to analyze, monitor, and track grant activity through the life cycle of the grant. This position ensures the City adheres to fiscal standards and requirement set by regulatory agencies as well as City policies and procedures. The Grants Program Fiscal Manager (ARPA) also supports interim and year-end reporting for ARPA grants in and the preparation of Single Audit schedules supporting ARPA grants. This position affords opportunities to apply professional judgment and initiative through participation in the City-wide grants program.
Duties & Responsibilities:
- Performs advanced professional financial analysis and program oversight for the City’s ARPA grant, ensuring compliance with applicable policies, procedures, regulations, and requirements.
- Evaluates the effectiveness of internal controls and helps develop, recommend, and implement program enhancements. Coordinate with budget and finance staff for policy and procedural changes.
- Functions as a technical liaison with internal and external customers, program stakeholders, and internal and external auditors. Maintains a master tracker and inventory files for department expenses associated with the City’s ARPA grant funding and monitoring of costs to ensure critical deliverables are retained and maintained through the life of the grant and available for compliance testing and reporting to City management and City Council as needed.
- Audits departmental expenditures on a regular basis, including grant expenditure reports, monitoring the spending of the Treasury cash, and prepares and reviews all federal required financial reports as outlined by the Treasury ARPA funds.
- Analyzes ARPA financial records and grant ledger activity for accuracy. Research discrepancies, coordinating journals for corrections with departments, as well as year-end accruals as deemed necessary.
- Ensures accurate and timely monthly, quarterly and year end reporting in conformance with applicable laws and GAAP accounting standards and in compliance with Treasury grant provisions.
- Supports the City’s Schedule of Expenditures of Federal and State Awards (SEFSA), supports Single Audit testing, and prepares grant fund reporting in the City’s Annual Comprehensive Financial Report (ACFR) as activities relate to the City’s ARPA grant funding. Verifies that activity has been appropriately captured and reconciled to federal confirmations.
- Supports as necessary internal and external auditors, helping to coordinate with departments for audit deliverables and inquiries surrounding the City’s ARPA grant funding.
- Other duties and Committee appointments as assigned.
Education and Experience
Bachelor’s degree in accounting, finance, business or public administration and five years of professional finance, budget analysis or accounting experience. Strongly preferred experience includes:
- Prior working knowledge of annual reporting process and financial statement preparation.
- Background shall include direct grants fiscal management experience with knowledge of SEFSA annual reporting in accordance with Single Audit and Uniform Guidance.
- Prior working knowledge of an Enterprise-Wide Financial System
- Valid North Carolina Driver’s License or the ability to attend off site meetings as needed.
- Certified Public Accountant (CPA) preferred.
Knowledge, Skills, and Abilities:
- Pertinent federal, state and local laws, codes and regulation, particularly those applicable to accounting, grant compliance, and Single Audit requirements.
- Principles and practices of general accounting theory, financial reporting, and fiscal management.
- Preparing complex financial statements, supporting schedules, and footnote disclosures.
- Internal control frameworks and ability to assess and monitor financial controls.
- Enterprise-wide software programs (ERP General Ledger and all associated modules)
- Techniques and methods for organizing, prioritizing, and monitoring work as needed.
- Practices and methods of coaching and coordinating work with others.
- Principles and methods of qualitative and quantitative research.
- Principles and techniques of effective oral presentations.
- Customer service principles.
- Carrying out job responsibilities in a self-directed and autonomous manner.
- Good record keeping and fiscal planning.
- Project management, including post-award grant administration, monitoring, and compliance.
- Interpreting and applying applicable laws, codes, and regulations.
- Overseeing the implementation and adherence to quality assurance and standards.
- Gathering data, analyzing findings, and applying critical thinking. Articulating issues/recommendations.
- Interpreting and preparing complex analytical, financial, and administrative data.
- Authoring and preparing original reports, documents and presentations.
- Researching industry trends, solutions and best practices. Ability to provide program enhancements.
- Excel functions with at least an intermediate skillset, including pivot tables, V-lookup, and formulas.
- Working effectively under pressure, with multiple deadlines. Balancing changing priorities and work demands.
- Facilitating group discussions and building consensus using persuasive reasoning.
- Providing technical guidance, direction, and education to program stakeholders.
- Maintaining cooperative working relationships in support of financial management.
- Exercising political acumen, tact, and diplomacy.