Financial Planning & Analysis Analyst II

Responsibilities

• Modeling
• 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.
• Aid in development and maintenance of long-term forecast, working closely with department leadership to formulate business’s medium to long-term financial and strategic plans.
• Analyze financial and operational results to better understand company performance including evaluating whether the company’s current assets and investments are the best use of the company’s excess working capital, by looking at return on investment (ROI) and comparisons with other ways the company might utilize its cash flow (e.g., other possible investments).
• 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.
• Aid in the Annual Operating Plan (AOP), or budget, process to include interaction with key stakeholders and business units to develop key performance indicators (KPI) to help enhance their budgeting process.
• Review and analyze various aspects of the AOP 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 senior stakeholders around financial modelling, forecasts, and profitability. Present the monthly and quarterly financial reports of various units and departments.
• Develop a detailed rolling income statement forecast that can be integrated into the Annual Operating Plan and various department models.
• Prepare and automate reports and presentations for Senior Management and the Board of Directors to include financial statements, variance reporting, ratios, slides, and other analysis.
• Take ownership of long-term planning exercises including tracking variances, back-testing results, reporting and sensitivity analysis.
• Develop and enhance models for branch expansion efforts to include pro-forma statements and other reports to assist management in strategic initiatives.
• Assist in balance sheet updates and deposit pricing recommendations for presentation to the Asset-Liability Committee (ALCO).
• Develop and incorporate funds transfer pricing (FTP) in profitability reporting for business units and products.
• Maintain, enhance, and develop models to assess performance of branches and other delivery channels to assist Sr. Management in decision making.
• Review the quarterly peer analysis reports for presentation to 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.
• Responsible for continued process improvement and compliance with State and NCUA regulations in all areas.
• Create, maintain, and enhance various models to assist the FRM team with liquidity reporting and asset-liability management.
• Extract data from business intelligence databases or other sources using data mining tools such as SQL, VBA, Crystal Reports, Power BI, Adaptive Planning, or other methods.
• Takes initiative in supporting changes needed in FP&A functions related to impacts from strategic initiatives such as M&A and new lines of business.
• Ad-hoc business performance reporting.
• Perform special projects or initiatives as assigned.
• Financial Decision Support & Reporting
• Analytical and statistical examination skills.
• Exhibits advanced knowledge of profitability concepts, systems and reporting including Funds-Transfer Pricing, activity-based costing, and allocations.
• Takes initiative in supporting analysis and models for both the FP&A and FRM functions.
• 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.
• Documents all work processes and models used for FP&A functions.
• Takes initiative in supporting changes needed in FP&A functions related to impacts from strategic initiatives such as M&A and new lines of business.
• Effectively supports the Finance team with requirements for the annual regulatory examination by the State of Florida and NCUA.

Qualifications

• Education
• Bachelor’s degree in Finance, Accounting, Economics, or related area.
• Masters of Business Administration (MBA) or Master’s Degree in a Quantitative or finance discipline is preferred.
• Experience
• 4-7 years of related experience.
• 2+ years of functional experience with budgeting, profitability, and data mining activities.
• 2+ years of experience in statistical/quantitative analysis tools such as SQL, Power BI SPSS, or other tools.
• 2+ years of experience in Financial Analytics/Modeling using Adaptive Planning or other budgeting, forecasting, or profitability systems.

Knowledge, Skills, & Abilities

• Knowledge of credit union/bank products and services.
• Proficiency in data analytics.
• Advanced skills in Excel, PowerPoint, and Word.
• Avid and positive team player that works well across multi-disciplined organization.
• Ability to work with both finance and non-finance professionals.
• Strong analytical capabilities with knowledge of accounting/financial reporting and financial modeling.
• Ability to coach and mentor other analysts.
• Strong communication skills including presentation, interpersonal and writing skills.
• Ability to work independently and is a self-starter.
• Exhibits flexibility and willingness to take on new responsibilities and assignments.
• Working knowledge of profitability/corporate performance management (CPM) software such as IBM TM1, SAS or others.
• Working knowledge of Data Analysis programming languages such as SQL, VBA, Python, Power BI or others.
• Ability to understand regulatory compliance issuances and incorporate them into the FP&A functions.

Disclaimers and Work Environment

• Nothing in this position description is an implied contract for employment. The position description is intended to be an accurate account of the essential functions. The functions are not all encompassing and are subject to change at any time by management.
• The work environment characteristics described are representative of those that an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• VyStar Credit Union is not seeking outside assistance or accepting unsolicited resumes from staffing agencies or search firms for employment or contractor opportunities. Any resumes submitted by an outside vendor to any employee at VyStar via e-mail, internet, or directly to hiring managers without a valid written search agreement with the Talent Acquisition / HR department will be deemed the sole property of VyStar Credit Union.
• No placement fee will be paid if a candidate is hired as a result of the referral, or through other means.