Compliance Analyst, Finance & Banking

Job responsibilities at the City of Franklin are many and varied, challenging and rewarding.

Part Time | Starting Pay: $37.58 - $40.89/Hourly

• Reviews and approves contractor’s transit invoices for payment by the City.
• Maintains and updates the Authority’s Comprehensive Review Guide and the Contractor Oversight Checklist that is signed by the Franklin Transit Authority chair.
• Establishes and maintains effective internal control over the federal awards that provides reasonable assurance management of the Federal award follows Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should follow guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).
• Provides City’s Finance Department information needed for the required Single Audit, performed by the City’s external auditor. Consults with Federal Transit to ensure compliance with this federal regulation for reporting awards and sub‑awards in the Schedule of Expenditures of Federal Awards (SEFA) in Single Audits.
• Reviews the County’s annual Single Audit reports to ensure they are completed timely and determining if any findings are cited that pertain to Federal Transit funded programs. The results of these reviews should be documented. Ensure that monitoring policies prepared by contractor are followed.
• Analyzes and reports current or projected 5307 expenditures to the Authority for approval, as identified in the contractor’s sub‑recipient monitoring procedures manual.
• Analyzes and reports ridership numbers to the Authority for approval, as identified in the contractor’s sub‑recipient monitoring procedures manual.
• Assist in the competitive process for selecting the transit contractor.
• Ensures that monthly statements of activities provided by the contractor are separated for the activities of the recipient (Franklin Transit Authority), the contractor (The TMA Group), and sub‑recipient (Williamson County).
• Tracks Franklin Transit Authority’s assets to ensure they are used solely for authorized purposes. Provides the list to City’s Finance Department at each fiscal year end for annual audit.
• Assists in developing an approved federally recognized indirect cost rate negotiated with the Federal Government or help determine the appropriate rate if no approved rate exists. This will ensure the proper inclusion and application of indirect costs to federal award expenditures.
• Before submitted, reviews the financial and performance reports proposed by the contractor. This includes the Federal Financial Report (FFR) and NTO (National Transit Database (NTD). Ensures information used to report expenditures in the FFRs and NTD is consistent with the information used to report expenditures in other annual reports.
• Ensures the contractor has entered sub‑awards exceeding $25,000 in the federal registry at www.usaspending.gov in accordance with FFATA after the grant has been awarded.
• Analyzes vanpool numbers reported at Authority meetings. Topics include NTD numbers (vehicles in operation, unlinked passenger trips, vehicle revenue miles VR hours), routes ended and started, employer visits, issues related to the fleet, maintenance issues, marketing initiatives, and any procurements (when applicable).
• At least quarterly, review written procedures for requesting federal reimbursements to ensure meets federal guidance on proper procedures, including allowability of costs.
• At least quarterly, review farebox revenue documentation to enhance the process for monitoring fare revenue collections. Ensure that source documentation for fare collections is maintained by contractor’s finance personnel.
• At least quarterly, review the contractor’s timesheets to ensure they were signed or initialed prior to giving them to the Chief Financial Officer for payroll processing.
• May assist with ongoing or future projects and will be included in all capital projects as part of the project team.

Performs other job…