Financial Planning and Analysis Analyst - Hills Bank : Job Details

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 52235BENEFITS: 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