Financial Analyst

Overview

End Date:
3/21/2019
Date Posted:
2/21/2019
Job Code:
ExaminerH
Location:
City Hall
Address:
109 3rd Ave S
City:
Franklin
State:
TN
Country:
United States of America
Maximum Salary:
3347
Minimum Salary:
2370.77

Description

 

Purpose of Job

Under limited supervision, performs and/or reviews Finance functions and provides financial analysis. 

Essential Job Duties 

A.         Financial analysis and reporting

  • Analyzes Balance Sheet and Income Statement accounts to monitor and evaluate departmental spending and purchasing patterns.
  • Assists departments with general ledger coding for payments and receipts.
  • Performs a variety of financial tasks, which may include posting financial data, balancing accounts, tracking fund activity, and maintaining financial ledgers.
  • Prepares various financial reports and records including journal entries, payment documents, and other financial statements.
  • Performs budget and financial analysis and evaluates results to enhance completeness and accuracy of performance measures. 
  • Updates and maintains budget in City’s budgetary and financial systems.
  • Prepares weekly and monthly financial/budget reports for departments.
  • Performs cash monitoring and makes projections regarding cash requirements.
  • Responsible for bidding investments and renewing investments; and maintaining a subsidiary.  Oversees the collateralization of the City’s investments to ensure compliance with state laws.
  • Reconciles general ledger accounts and creates journal entries to adjust or correct previous transactions.
  • Monitors budgetary expenditures for departments and answers questions pertaining to same.
  • Responsible for recording journal entries for various revenue/receivables and expenditure/liabilities activity (including property tax/industrial development district, local and state shared taxes, customer service/utility billing, deposits, bond payments, etc.).  
  • Assists with audit and preparation of Comprehensive Annual Financial Report (CAFR).
  • Responsible for recording journal entries for interdepartmental billings and inter-fund transfers.
  • Provides grants financial information to departments.

 

B.        Financial administration

  • Administers various grants, with regard to payments, compliance, and audits.  Ensures compliance with federal and state grant requirements.  Prepares required quarterly or annual financial reporting.  Prepares or assists departments with grant financial reporting.
  • Ensures proper close-out of grants.  Monitors usage of grants before end of grant period.
  • Assists with preparation of the City’s annual budget.  Meets with City Administrator & Department Directors to obtain budget information and to finalize budget numbers.  Analyze, monitor and provide budget information per line item encompassing prior, current/YTD estimates, and future budget year balances.  Meets with HR monthly to audit personnel and is responsible for ensuring all personnel orders are entered into the budgeting system.  Creates and tracks necessary budget amendments for personnel.  Serves as administrator of the budgeting system, to include: setting up the new fiscal year, training employees on the basics of the system, updating personnel in the Human Resources Master and importing the year to date expenses.
  • Updates and maintains Capital Assets in the Financial System.  Evaluates purchases to assure compliance with the City’s Capital Asset Policy.  Communicates with departments to obtain purchase and disposal information in a timely manner.  Compares Financial records to reports and/or inventories maintained at the department level.
  • Administers the City’s debt service (bonds/loans), with regard to payments, compliance, and audits.  Monitors spending of bond proceeds to ensure arbitrage spending deadlines are met.  Prepares outstanding debt service reports.
  • Administers the City’s leases, with regard to payments, compliance, and audits.  Prepares outstanding lease reports.
  • With financial managers, reconciles and evaluates the City’s bank accounts, revenue and expenditure accounts, and asset and liability subsidiary ledgers.
  • Administers performance maintenance bond and evidence trust bank accounts.
  • Ensures that cost and depreciation information for capital assets are available for audit, for departments and other interested parties, and for insurance purposes.
  • Performs periodic capital asset inventories
  • Ensures that cost information for financial inventory is available for audit, for departments and other interested parties, and for insurance purposes. Monitors and observes the annual physical inventory in applicable departments.
  • Records financial entries generated from the billing and receipting of Utility Billing, Payroll processing, Accounts Payable, and electronic (ACH) payments.
  • Creates and maintains vendor records in financial system, including information for tax purposes.

 

 

C.        Internal Controls

 

  • Responsible for Financial Systems Internal Controls including monitoring the Utility Billing Systems, the Court System and the Investment System.
  • Responsible for Payroll Internal Controls including backup preparer, reviewer, and recorder purposes.
  • Responsible for AP Internal Controls including backup preparer, reviewer, and recorder purposes.
  • Responsible for Unclaimed Property Internal Controls including ensuring accurate amounts, notifications and timely submittals to the State.
  • Responsible for Journal Entries Internal Controls including recording Purchasing Card transactions, Interdepartmental Billing, Wires and Deposits.
  • Responsible for General Ledger Setup Internal Controls including requesting and setup general ledger accounts in the billing system and financial report system.
  • Responsible for Bank Account Reconciliation Internal Controls including reconciling bank statements within 30-days of receipt.
  • Responsible for Investments Internal Controls including bidding and recording investment activities.
  • Responsible for Budget Compliance Internal Controls including budget tracking and reviewing.
  • Responsible for Grant Compliance Internal Controls including review and ensures grants receivable, revenue, and expenditures are accurate at each month-end. 
  • Responsible for Bond Compliance Internal Controls including post issuance continuing disclosure and arbitrage rebate requirements.
  • Responsible for Lease Compliance Internal Controls including review and ensures lease receivable, revenue, and expenditures are accurate at each month-end. 
  • Responsible for Financial Inventory Internal Controls including quarterly inventory balances.
  • Responsible for Capital Assets Internal Controls including quarterly capital asset balances.
  • Responsible for Quarterly Report Preparation Internal Controls including reconciling funds and accounts for quarterly reporting.
  • Responsible for Audit Preparation Internal Controls including answering audit inquiries.
  • Responsible for CAFR Preparation Internal Controls including grants, bonds, leases and other activity.
  • Complies with the 60-day deadline for closing the financial period and completion of financial statements, as required by the State.

D.        Auditing

  • Responsible for assisting external auditor with the audit of financial management systems; provides information to auditors as requested.
  • Performs internal audits as appropriate and timely.

E.        External Reporting

  • Responsible for submission and monitoring of any State or Federal grant received
  • Assists in preparation and review of the CAFR
  • Responsible for Continuing Debt Disclosure for the CAFR and Bond Issues

Minimum Requirements

 

Qualifications

Education and Experience: The required knowledge, skill, and abilities to satisfactorily perform job duties are normally acquired through obtaining a Bachelor’s or higher degree in accounting, finance, or business administration, plus a minimum of four (4) to six (6) years related experience and/or training; or an equivalent combination of education and experience. 

Certified Public Accountant (CPA), Certified Municipal Finance Officer (CMFO), or Certified Public Finance Officer (CPFO) certification preferred.