VP, Finance and Business Analytics Manager - ILD

Bank OZK•Alpharetta, GA

1d•Onsite

About The Position

Responsible for providing analytical support and reviewing and evaluating data to determine objectives of business needs for the Indirect Lending Division (ILD).

Requirements

Knowledge of finance, accounting and statistical principles and practices.
Knowledge of Indirect Lending product and credit policy.
Knowledge of risk-based pricing.
Ability to research, manage, analyze, and interpret large amounts of data.
Ability to demonstrate strong organizational skills and the ability to manage multiple priorities on a consistent basis.
Ability to communicate effectively both verbally and in writing with internal and external clients.
Ability to maintain confidential information.
Ability to apply critical thinking skills and demonstrate sound judgment when decision-making and problem solving.
Ability to develop and maintain positive and effective working relationships with others.
Ability to troubleshoot and resolve complex issues.
Ability to work effectively in a team-oriented work environment.
Ability to train, mentor and lead other staff.
Skill in using Microsoft Windows and MS Office applications, including Excel, Word and PowerPoint.
Skill in using SQL Query for data extracts and structured report development through SSRS, Power BI, or similar tools.
Skill in using computer and Microsoft Office, including Word, Excel (including VLookup, Pivot Tables, Index Match, Conditional Formatting, Data Sets, Data Tables, Dashboards, Macros & Visual Basic for Applications (VBA), Advance Charting Techniques, and Data Manipulation), and Outlook.
Bachelor degree or commensurate work experience, preferably in accounting or finance, required.
Minimum of three (3) years of indirect lending/consumer lending underwriting work experience or equivalent financial institution work experience required.
Minimum of three (3) years of planning/budgeting work experience, including variance reporting and forecasting, required.
Prior experience with Index Match, Conditional Formatting, Data Sets, Data Tables, Dashboards, Macros & Visual Basic for Applications (VBA), Advance Charting Techniques and/or Data Manipulation, MS Power BI, or similar tools, required.
Prior experience in writing and optimizing SQL scripts and data manipulation techniques, required.

Nice To Haves

Minimum of one (1) year experience managing or supervising others preferred.
Financial services and/or lending experience, preferred.

Responsibilities

Oversees operational metric reporting for daily, monthly and quarterly MIS including, but not limited to, Daily Business Stats, Dealer Dashboard, Sales Dashboard, Monthly Liquidation, Past Due/Charge offs, Accelerate Reporting, and Quarterly Dealer Management Review Meeting reporting.
Analyzes market share by utilizing statistical survey data and other market analysis sources to understand ILD’s performance versus competition.
Performs gearing ratio analysis by analyzing financial/operational metric ratios to understand overall performance trends of the ILD business.
Assists in the management and execution of the data governance process for ILD to maintain optimum data integrity and usability of reporting.
Manages annual budgeting process for ILD (overall P&L, departmental expense) and serves as liaison to corporate finance on all budget template submissions.
Plans and manages forecast and long-range planning process by continually updating forecast with recent loan production trends, rate adjustments, liquidation adjustments, hiring plans, etc.
Manages ILD incentive compensation plans, including metric tracking and quarterly calculation of employee and dealer incentive payments, for both employees and dealers.
Oversees product profitability by building and maintaining product level P&Ls and refining product level allocations on an ongoing basis.
Oversees financial reporting, expense control and variance reporting by managing monthly ILD P&L reporting with comparisons to budget and forecast and collaborating with ILD management team on cost center level expenses.
Manages, trains and mentors business analysts of varying experience and ability.