Financial Planning and Reporting Analyst

About Our Opportunity

On an individual rotation basis or part of a team effort, prepares the annual financial budget and long-range plan, financial and tax reports for management, shareholders, Board, Farm Credit Administration (FCA) and the Internal Revenue Service (IRS).  Supports Association's management and leaders by preparing financial analyses and models, and related verbal or written analyses.

Employee does not directly supervise other employees, but coaches others as part of the team environment. The basic function requires coordinating the efforts of, and communicating with, members of the finance team, senior management, Louisville office support leaders and retail leaders.

How You Will Spend Your Time

• Coordinates and executes a comprehensive program to produce a financial budget and long-range plan for the Association (annual and quarterly updates), working closely with senior management, finance team, Louisville office support leaders, retail leaders, and AgriBank. Validates the accuracy and completeness of budget data and provides a sound and reliable control environment around the process. Performs project management duties to assist in preparing annual budgets. Facilitates strategic thinking surrounding the planning process. 
• Completes annual, quarterly and monthly financial reports including footnote disclosures as required, working closely with the financial reporting group of AgriBank. Accurately reports and complies with Generally Accepted Accounting Principles (GAAP) and FCA regulations. Validates accuracy and completeness of financial reports, ensuring sound and reliable control environment around the process. Coordinates approval of quarterly and annual shareholder reports with the Audit Committee.
• Performs Profitability reporting and improves cost and revenue allocations utilizing new research findings.
• Serves as primary finance team contact to retail leaders or Louisville office support leaders, providing support and training as needed related to financial reporting and operations
• Performs, with responsiveness and timeliness, various and in-depth financial analyses and modeling, and related verbal or written analyses, to support management, leaders, Board and ALCO. Summarizes vast amount of data into meaningful and comprehensive reports, charts, and graphs to assist management and leaders in the decision-making process.
• Coordinates with senior management and prepares the quarterly model used in determining the loan loss provision, allowance for loan loss, and the allowance narrative. Coordinates review of this report with the Audit Committee and FCA. Prepares and distributes other chargeoff/recovery, allowance and provision data to senior management.
• Coordinates and prepares reports and assists external firms with the completion of the Association’s state income, franchise and federal income tax returns, including quarterly meeting to determine estimated tax payments. Reviews and prepares data to support and verify book/tax timing differences. Coordinates Louisville office audits conducted by taxing authorities.
• Prepares monthly analysis and management reporting of net interest margin and spread, and modeling / forecasting as needed. Prepares spread input for annual financial plan and interest rate shocks.
• Revises entity cost allocation tables, and perform annual analysis at year end to correct allocation in accordance with methodology established by the Cost Allocation Study. Coordinates data gathering from internal partners and analyzes results leading to the calculation of updated allocation rates needed to complete the Cost Allocation Study process for the association.
• Prepares general ledger reconciliations as assigned, and follows up on outstanding items. Provides support to Louisville office audits conducted by external auditors (Price Waterhouse-Coopers) and regulators (FCA) as needed. Provides support for financial operations as needed for internal control processes and compliance with Sarbanes-Oxley regulations.
• Maintain written procedures of processes, and reviews at least annually.

Minimum Education & Experience

Bachelor's Degree in finance or accounting is required, Master's Degree, MBA, Graduate degree or equivalent in finance, accounting, business or related field and professional certification (ex. CPA, CFA, CTP or CMA) is preferred. 4 years progressively responsible and related working experience. Strong Excel, Access, PowerPoint and Word skills. Experience in the financial services industry and experience with Enterprise Performance Management (EPM) software (i.e., Hyperion, Onestream, etc.) preferred. 

Mental & Physical Requirements

While engaged in this position, team members will routinely sit, use hands for tasks, and communicate orally. Standing or walking is frequently required, while occasional demands include reaching with hands and arms, and lifting or moving up to ten pounds. Vision requirements encompass close and distance vision. The work environment typically has a moderate noise level. This role may entail a blend of mental and physical capabilities, requiring strong mental acuity, problem-solving skills, and occasional physical tasks such as standing, lifting, or extended computer usage. Some roles may require physical or mental requirements related to driving, such as a valid driver's license, and the ability to drive a long-distance. Reasonable accommodations will be considered for individuals as requested.