Senior Business Analyst

Job description / Role

Prepare annual consumer plan and forecasts:

Reporting to the BP&A Head, BP&A assistant manager is responsible for preparing the data and information needed the models for acquisitions, sales, runoffs, attritions 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.

Analysis:
- Monitoring business performances on its different products, analysing the issues if any and advising solutions.
- Tracking achievements vs. Plan for sales on a weekly basis and comparing this vs. the Plan on both MTD and YTD.
- Work on major expenditure plans in terms of data preparation and working closely with fiancé team on the detailed models for such projects

Incentive analysis:
- Data analysis for BMs, RMs, PBs / SPB, and DSU team and analysing how these schemes are effective and serve the purposes of having them to achieve the targets of the bank

Data mining:
- Extract reports that are needed for the analysis on both product and customer levels

JOB DESCRIPTION:
- Prepare main data and assumptions for the Plan models
- Prepare main data and assumptions for the quarterly forecasts models
- Track performance vs. Plan and producing the daily SBR
- Assist in analysis of sales and financials
- Assist in branch MEPs (Major Expenditure Plans)
- Analyse incentive schemes for consumer bank
- Data mining and extraction of various customer and product reports
- Analyse monthly Branch Profitability Reports
- 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 analysing 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 Finaliziing 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.
- Analyse incentive schemes for consumer bank
- Incentives calculations for BMs, RMs, and BPs are under the responsibilities of BP&A unit.
- BMs and RMs incentives are based on comparing their branch targets vs. actual which are submitted by finance team.
- Analysis needs to be conducted in order to see how the schemes are working fine and give the desired results.
- PBs is currently in the development stage as we are developing reports from the system to measure the performance
- 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
- Analyse 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

Requirements

- Minimum of a Bachelor’s degree, at least six years of experience in planning and analysis, modelling and general finance understanding

Minimum Experience:
- 2 to 4 years

Experience with:
- Spread sheets (MS office excel)
- Experience to demonstrate with good communication skills
- Strong analytical skills and observation to trends
- Financial awareness

Job specific Skills:
- Maintain management the plan and make sure of the tracking methods and reports are correct.
- Advise on problems with the performance and solutions for such problems.
- Strong technical knowledge of the tools that are used for modelling and tracking.

Generic Skills:
- Communicate effectively with the concerned parties in addressing the plan and the actual results.
- Ability to analyse business numbers in terms of sales and financials.

About the Company

In 2010, ADIB had introduced its new brand identity as a symbol of a new promise. For two years, we’ve conducted extensive research to identify ways to better meet your needs. You wanted banking to be simple, sensible and transparent, making everybody feel at home and respected. You wanted a bank that would be on your side, one that worked as if your success was the source of its own success.

You are seeking a bank that can deliver unique solutions because it is guided and inspired by the timeless rules and principles of Shari’a. These are the core pillars of the banking we want to deliver to you: Banking as it should be.

We have worked hard to implement these simple but powerful promises in the way we do business. We have introduced a number of new offerings and improvements already. We simplified a number of processes – from the way we open accounts to the way we deliver financing solutions. We have brought ADIB closer to you by rapidly expanding our network to 70 branches and 460 ATMs. We have extended branch opening hours in our in-mall branches and introduced a 24-hour branch at the Abu Dhabi Airport. We have launched an upgraded version of e-ADIB Internet Banking that is safer and more convenient. We have launched numerous products and services. But what won’t change is our priority, which remains your satisfaction.