BP&A Senior Business Analyst is responsible for preparing the data and information needed the models for acquisitions, sales, runoffs, attrition and balances that will lead to the final plan and the forecast and validating assumptions.
The role also focuses on the overall strategy of the consumer bank, this is a key requirement as all the data assumptions needs very good understanding of over all strategy of the bank.
Key Accountabilities;
Prepare main data and assumptions for the Plan models
Work closely with BP&A and products team on their key assumptions for their sales/revenues/expenses and apply these assumptions to the Plan models and assist in the submission of the planned volumes and balances to finance team
Prepare main data and assumptions for the quarterly forecasts models
Work closely with BP&A and products team on their key assumptions for their sales/revenues/expenses and apply these assumptions to the forecast models and assist in the submission of the volumes and balances to finance team
Track performance vs. Plan and producing the daily SBR
This is mainly done through daily, weekly, and monthly tracking using reports generated from the BO and comparing the results vs. The MTD and YTD plan and communicating this to the consumer team.
Assist in analysis for sales and financials
This is done by analyzing the components of the balances for each product like for example on assets we need to know which scheme did we sell on and the runoffs of the base and if there is any spikes in the normal trends and investigate with the products team the reason for such spikes, also on the financials in terms of revenues and expenses, this is tracked line by line.
Assist in Finalizing branch MEPs(Major Expenditure Plans)
MEPs are the financials of the new branches that will be opened or the ones that will be renovation, the process requires working closely with finance and premises team to generate a full 3 years plan for the new or renovated branch that shows the breakeven and payback months.
Analise incentive schemes for consumer bank
Incentives calculations for BMs, RMs, and BPs are under the responsibilities of BP&A unit.
Data mining and extraction of various customer and products reports
Work on the data mining tools to produce reliable reports that would help in understanding the business trends and comparing actual numbers against plan.
Also reports that would help in monitoring and understanding the customer base and behaviour
Analise Branch Profitability reports
Conduct analysis on a monthly bases for the branch profitability in terms of balances, expenses, revenues and contribution and what are the major changes and trends that lead to the numbers that are affecting the overall profitability of the branches