Senior FP&A Analyst

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

Wage Range: Min: $74,513, Mid: $97,454, Max: $120,394

A Brief Overview

The Senior FP&A Analyst executes interest rate risk, budgeting and forecasting modeling, while supporting management reporting and variance analysis. The role works closely with business line leaders to deliver timely, accurate, and actionable insights that drive performance.

What you will do

• 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 and present findings to management.
• Produce and distribute monthly management reporting, including income statement, balance sheet, and key performance metrics.
• Develop and maintain dashboards to monitor line-of-business performance, including liquidity monitoring and reporting.
• Respond to ad hoc analytical requests from senior management and business unit leaders.

Other Qualifications/Requirements

• Familiarity with Asset Liability Model and Planning/Forecasting Model.
• Familiarity with Jack Henry Silverlake core system.
• Familiarity with report writing tools such as Cognos or Power BI.
• Advanced Excel skills such as pivot tables, lookups, complex formulas, and visualizations.
• Bachelor’s Degree Finance or Accounting and Minimum 5 Years Bank or Corporate Finance Preferred or equivalent combination of education and experience

Who We Are

Heartland Bank and Trust Company is headquartered in Bloomington, Illinois. With 70+ locations throughout Illinois and Eastern Iowa, Heartland continues to grow and is committed to preserving strong ties to our communities, customers, employees, and shareholders.

Heartland Bank’s mission is “create value for the customer, earn a profit for the Bank, and have fun doing it!” At Heartland, employees have the opportunity to make a difference every day.

What We Offer

At Heartland Bank, we offer a competitive benefits package to provide you with peace of mind.

Physical Demands

• Regularly: Sitting, Feeling/Touching, Talking, Hearing, Vision - close peripheral, depth
• Frequently: Standing, Walking, Grasping/Reaching - with arms and hands, Repetitive Motions
• Occasionally: Climbing and/or Balancing, Stooping, Kneeling, Crouching, and/or Crawling, Lifting (30 lbs.)

Equal Opportunities and Accommodations Statement

Heartland Bank is deeply committed to creating a workplace where inclusion is not only valued but prioritized. We’re proud to be an equal opportunity employer, seeking to create a welcoming and diverse environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, family status, marital status, sexual orientation, national origin, genetics, disability, age, or any other non-merit based or legally protected grounds.

Salary Disclaimer

The salary range represents the range of possible compensation at the time of posting. Heartland Bank considers several factors when extending an offer, including but not limited to, the role and associated responsibilities, a candidate’s work experience, education/training, key skills, and internal equity.

The salary range minimum, midpoint, and maximum listed above represent a full range of career compensation growth over time in this position and pay grade. Starting pay typically starts between minimum and midpoint upon hire. The Bank offers compensation growth opportunities within its career architecture.