Forecast Analyst

Supports the business decisions and financial processes of the bank through the preparation and interpretation of budgets, forecasts, division and product profitability analysis, capital stress tests and ad hoc analysis and reports.

Utilizes experience, industry and bank historical performance and leadership insights to perform various financial analyses and present findings / recommendations to senior management.

Helps develop, maintain, and update complex business solutions including data, reporting and business intelligence used in the analysis and reporting of company results.

Essential Functions :

• Builds the bank’s annual budget and five-year forecast in accordance with business plan objectives by working with department contacts to understand and build forecasts and budgets as well as evaluating historical trends.
• Prepares quarterly forecasts of balance sheet, income statement, and capital stress test for presentation to senior management and board
• Contribute to development and maintenance of models used for stress testing, A / L risk management, and Capital Planning as well as other areas as needed.
• Develops reports and presentation materials that effectively communicate financial performance, risks, and strategy recommendations.
• Engages and collaborates with others to provide support for subjects such as earnings forecasting, FTP, Economic Capital, Capital Planning, etc.
• Provides implementable statistical analytics for the support of portfolio modeling.
• Presents analysis to senior management in a clear, concise and actionable format, develop plans and recommendations for business strategies and tactics.
• Acts as a key resource by providing informed, proactive financial analysis with a forward-looking perspective to enable effective decision making and efficient resource utilization.
• Contributes to the achievement of business goals and objectives by acquiring and applying advanced knowledge of the business, its products, services and processes.
• Creates, maintains and presents bank activity and financial reports using enterprise business intelligence solutions.
• Extracts data from various bank systems for loading into analytical databases.

Additional Responsibilities :

Performs other related duties as assigned.

Knowledge, Skills, and Abilities :

• Excellent oral and written communication skills.
• Advanced knowledge of relevant technical discipline.
• Advance Knowledge of Microsoft Office and database products (Excel, PowerPoint, Word); SQL and / or SAS.
• Proven analytical and multi-project management skills.
• Ability to perform multiple projects with minimal supervision and attention to detail.
• Knowledge of data analysis / reporting tools and techniques.
• Advanced knowledge in developing analysis queries and procedures in SQL, SAS, BI tools or other analysis software.

Education and Experience :

• Bachelor’s degree in accounting finance, economics, mathematics or related field is required. Master’s Degree preferred.
• Five (5) years financial / accounting analysis or finance / accounting work experience.
• Expertise in SAS, SQL, Excel, Data Warehouses and business intelligence associated tools is required
• Two (2) years’ experience as a financial analyst in the banking industry a plus.
• Two (2) years’ experience with financial modeling; high proficiency with excel
1 hour ago