Senior FP&A Analyst

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

Job summary

Heartland Bank and Trust Company in Illinois is seeking a Senior FP&A Analyst to lead interest rate risk modeling, budgeting and forecasting, and management reporting. You will collaborate with business line leaders to deliver timely insights, produce monthly income statements and balance sheets, and develop dashboards to monitor liquidity and overall performance for senior management.

Bachelor’s degree in Finance or Accounting with 5+ years in banking or corporate finance; strong Excel and

Qualifications

• The candidate has a Finance or Accounting degree and relevant banking/finance experience.
• Proven ability in budgeting, forecasting and variance analysis.
• Strong Excel, Cognos or Power BI skills and data visualization expertise.
• Experience with asset-liability modeling is desirable.

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.
• 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 and business unit leaders.

Skills

Advanced Excel skills

Pivot tables

Lookups

Complex formulas

Data visualization

Education

Bachelor’s Degree in Finance or Accounting

Tools

Jack Henry Silverlake

Cognos

Power BI

Planning/Forecasting model

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 to “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.