Senior FP&A Analyst: Rate Risk & Forecasting Leader

Heartland Bank and Trust Company; Bloomington (IL); On-site; USD 75,000 - 120,000; Full time

Job summary

Heartland Bank and Trust Company in Bloomington, IL seeks a Senior FP&A Analyst to manage interest rate risk modeling, budgeting, forecasting, and management reporting. You will deliver timely insights to drive performance and support line-of-business leaders.

Responsibilities include maintaining the interest rate risk model, rolling forecast, annual budget, variance analysis, monthly financial reporting, and dashboards for liquidity and performance; requires advanced Excel and Power BI

Qualifications

• Bachelor's degree in Finance or Accounting required or equivalent experience.
• 5+ years banking or corporate finance preferred.
• Advanced Excel skills with pivot tables, lookups, and complex formulas.
• Familiarity with Asset Liability Management and planning/forecasting tools.
• Experience with report writing tools such as Cognos or Power BI.

Responsibilities

• Manage interest rate risk model and produce reports for interest rate scenarios.
• Administer planning model and reporting tools to prepare rolling forecast and annual budget.
• Analyze variances between actual results and budget/forecast; summarize key drivers for management.
• Produce and distribute monthly management reporting including income statement and balance sheet.
• Develop dashboards to monitor liquidity and line-of-business performance.
• Respond to ad hoc analytical requests from senior management.

Skills

Asset Liability Model

Planning/Forecasting Model

Power BI

Excel (Advanced)

Banking/Finance experience

Education

Bachelor's Degree Finance or Accounting

Tools

Jack Henry Silverlake

Cognos

Job description

Heartland Bank and Trust Company in Bloomington, IL seeks a Senior FP&A Analyst to manage interest rate risk modeling, budgeting, forecasting, and management reporting. You will deliver timely insights to drive performance and support line-of-business leaders.

Responsibilities include maintaining the interest rate risk model, rolling forecast, annual budget, variance analysis, monthly financial reporting, and dashboards for liquidity and performance; requires advanced Excel and Power BI