Overview

POSITION SUMMARY:

Financial Analyst supports Senior Financial Analyst and Treasurer and works with third party vendors and finance department to process and report asset liability and liquidity positions and execute strategies of the Bank and assists with administration of certain wholesale funding programs. FA completes periodic financial reporting to board and management, assists with preparation of annual financial statements, assists with schedule preparation for external audits and regulatory examinations, and generates certain ad-hoc financial reports.

 

DUTIES:

Asset/Liability, Liquidity and Contingency Funding Plan

  1. Interim liquidity and deposit reporting
  2. Track public fund rate changes
  3. Funding rate matrix
  4. Asset liability – assist with preparation of schedules and data submission and review of vendor reports, prepare a checklist as part of this process
  5. Responsible for monthly upload of Deposits 360 monthly data upload
  6. Responsible for preparation of monthly liquidity source and use statements in addition to quarterly stressed source and use statements
  7. Prepares and monitors various loan reports including weekly update of line analysis and monthly preparation of the loan pipeline
  8. Prepares and monitors Illinois public fund balances and assists with collateral reporting process
  9. Reviews and monitors callable Broker CDs along with updating monthly Broker CD reports
  10. Prepares various deposit monitoring reports including monthly HR update, CD maturity tables, assist with reports monitoring CD growth CD specials as needed
  11. Assist with wholesale deposit network relationships including DDM, CDARS and ICS
  12. Processes swap entries, and quarterly reports as needed
  13. Assist with biennial 3rd party review of ALCO process, works with vendor to gather data for the review and follow-up discussions
  14. Responsible for various monthly accruals including Broker CD’s, Step CD’s and various swap entries

Financial Reporting – Regulatory/External

  1. Assistance with external audit schedules
  2. Responsible for preparation of weekly FR 2900 report and annual Summary of Deposit report
  3. Assist with preparation of Quarterly PDIF Report
  4. Assist with preparation of financial statement footnotes

Financial Reporting – Internal

  1. Board reporting
    1. Prepare investment data for the Liquidity report
    2. Prepare the Liquidity report
    3. Prepare the Quarterly Derivative Report
  2. Assist with Peer Capital Report – Quarterly Report
  3. Assist with support for Investment Committee Packet and preparation of the quarterly Impairment report

Other duties:

  1. Preparation of certain general ledger account reconciliations as needed
  2. Responsible for preparation of monthly yields analysis and splits file
  3. Assist with weekly loan and deposit rate changes at least once a month
  4. Assist with external Swap reporting requirements
  5. Assist with maintenance of the Loan Pricing System
  6. Ad hoc financial analysis projects
  7. Process review projects as needed
  8. 12 to 18 hours of CPE annually
  9. Other duties as assigned

 

RELATIONSHIPS/QUALIFICATIONS:

  1. Responsible to the Senior vice President, Treasurer for the fulfillment of functions and responsibilities assigned
  2. A Bachelor’s degree in finance or accounting, or equivalent business experience with 2 to 5 years of progressively responsible experience in the financial services industry
  3. Strong verbal and written communication and interpersonal skills required
  4. Proficiency in spreadsheets computerized financial reporting systems required
  5. Strong analytical ability
  6. Effective planning and time management skills
  7. May be called on from time to time to participate with community organizations and community projects

 

WORKING CONDITIONS:

  1. Normal office environment
  2. Extended viewing of computer screens
  3. Moderate lifting up to 25 pounds
  4. Repetitive hand and arm movement

Tagged as: EARLY CAREER