Description

FINANCIAL ANALYST – CONVERSE

DEPARTMENT: Finance

CLASSIFICATION: Non-Exempt

REPORTS TO: Treasurer

SUPERVISES: None

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 assist in preparation of pipeline
8. Prepares and monitors Illinois public fund balances and 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 CD maturity tables, a review of new CDs issued monthly and when needed weekly reports to monitor CD specials
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
2. Assist with Peer Capital Report – Quarterly Report
3. Assist with support for Investment Committee Packet

Other duties:

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

Requirements

RELATIONSHIPS/QUALIFICATIONS:

1. Responsible to the 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