Job Information
Hills Bank Financial Planning and Analysis Analyst in Hills, Iowa
SCHEDULE: Full-time; Exempt; Typical Hours Are Monday through Friday (8:00 am-5:00 pm) Occasional Extended Hours
LOCATION: 131 East Main St, Hills, Iowa 52235
BENEFITS: Our employees are our most valuable assets, so we invest in them with a comprehensive and competitive benefits package. Our philosophy of taking care of the customer extends to taking care of our employees so that they, in turn, can take good care of themselves and their families. Join Hills Bank and let us surprise you with even more perks!
SCOPE:
The Financial Planning and Analysis Analyst will report directly to the CFO. The Financial Planning and Analysis (FP&A) function refers to the corporate finance and planning role. This includes aspects associated with planning, forecasting, analysis, and reporting to aid senior management with decision-making. This includes involvement in the annual budget process, profitability measurement of business units, delivery channels, products, and members/households. It also involves the preparation of ad-hoc analysis for new business initiatives, products, and expansion. Another area of involvement will be in the ALM function, as well as with deposit and loan pricing. These duties require building and maintaining various models using business intelligence tools and corporate financial management programs. The FP&A Analyst will work closely with the Controller and Accounting staff, as well as the Financial Reporting staff (both of which are within the Finance Business Unit), as well as individuals from other business units, and will report directly to the CFO.
ACCOUNTABILITIES:
Modeling and Data Analysis
Analyze and enhance historic and forecasted profitability models for business units, delivery channels, products and members/households including activity-based costing, transaction-driven cost allocations and sensitivity analysis.
Assist in development and maintenance of long-term forecast, working closely with CFO and department leadership to formulate business's medium to long-term financial and strategic plans. This includes producing and working with models to project long-term growth and determining the impacting business factors,
Analyze financial and operational results to better understand company performance
Review existing processes and procedures to develop recommendations for improvement efforts. Communicate results and recommendations to various stakeholders for improvements that will lead to cost reduction, revenue generation and streamlining operations.
Ability to drive a project from inception to delivery to include design, development, testing and implementation
Assist in the budget process to include interaction with key stakeholders and business units to develop key performance indicators (KPI) to help enhance their budgeting and performance measurement processes
Review and analyze various aspects of the budget for reasonability and create KPI dashboards.
Analyze the trends of Key Performance Indicators (KPIs) and identify the cause of any unexpected variances.
Provide insights to the CFO and certain other senior stakeholders around financial modelling, forecasts, and profitability.
Prepare and automate reports and presentations for Senior Management and the Board of Directors to include financial information, variance reporting, ratios, slides, and other analysis
Take ownership of long-term planning exercises including tracking variances, back-testing results, reporting and sensitivity analysis
Assist in balance sheet updates and deposit pricing recommendations for presentation to the Asset-Liability Committee (ALCO)
Develop and incorporate funds transfer pricing in profitability reporting for business units and products
Develop, maintain, and enhance models to assess performance of branches and other delivery channels to assist Sr. Management in decision making
Review the quarterly peer analysis reports for ALCO and define key variances
Analyze the monthly Return on Assets decomposition model and explain variances
Perform ad-hoc income and cost analysis to aid business units and management in decision making for new products, services, and business initiatives
Create, maintain, and enhance various models to assist the CFO with liquidity reporting and asset-liability management
Extract data from systems using data mining tools such as SQL, VBA, Crystal Reports, Power BI, Adaptive Planning, or other methods
Ad-hoc business performance reporting
Perform special projects or initiatives as assigned
Financial Decision Support & Reporting
Analytical and statistical examination skills
Exhibits knowledge of profitability concepts, systems and reporting including funds transfer pricing, activity-based costing, and allocations
Takes initiative in supporting analysis and models for the FP&A function
Excellent skills in ensuring reporting is complete, accurate and balances to the overall financial reports
Develops clear and concise written analysis of modeling results for presentation to business units, ALCO, senior management, and the Board of Directors. Key is the ability to provide analysis that is thoughtful, sound, clear, concise, and actionable.
Documents all work processes and models used for FP&A functions
Takes initiative in supporting changes needed in FP&A functions related to changes in the business and/or the competitive environment
EDUCATION AND SPECIAL REQUIREMENTS:
Bachelor's degree (B.A.) from a four-year college or university in the field of business, including specific courses in accounting, finance, and economics
Minimum of 3-5 years of banking/credit union experience
Master's Degree or MBA preferred but not required
CPA preferred but not required
Ability to work with and navigate US GAAP based financial reporting within the context of the FP&A function
Ability to read and analyze financial statements
Ability to retrieve and incorporate financial market and other data into analyses
Strong analytical capabilities with knowledge of accounting/financial reporting and financial modeling
Ability to understand regulatory compliance issuances and incorporate them into the FP&A function
Knowledge of credit union/bank products and services
Proficiency in data analytics
This job requires skills needed in a typical office environment. This includes computer skills, communications skills, as well as utilization of office equipment.
Position requires the ability to work before or after normal business hours, including Saturdays, to meet deadlines and attend various meetings.
EQUAL OPPORTUNITY EMPLOYER