Afreximbank Associate Business Support Treasury Planning Analytics Performance Management Cairo Egypt

Responsibilities:

• The role requires a flexible thinking outside the box type of candidate who is ready to get his/her hands dirty and get things done. The Candidate must be a selfstarter and a financial mathematics and modelling enthusiast with excellent report writing skills and a finance and accounting background. The candidate will be expected to work closely and proactively with Senior Management the Treasurer Managers at all levels as well as liaising with other division and department representatives to focus on treasury analytics. The candidate must demonstrate influence and credentials to effectively model the forwardlooking balance sheet and other financial reports.
• Treasury Planning Process
  • Assist in the treasury planning process and reporting processes
  • Work with Treasury Assets and Liabilities subunits to analyse and plan strategic asset allocations for excess cash
  • Assist with all fundraising activities preparation including sensitivity analysis and evaluation of market risk and propose risk mitigation actions where necessary in liaison with the treasury function view at large.
• Treasury Financial Data Modelling and Analysis
  • Contribute to the building of data collection and sanitization templates
  • Collection and sanitization of date preanalytics
  • Work with Finance and the wider Treasury function in modelling of the Balance
  • Sheet to reflect a plausible forwardlooking perspective for ALCO purposes
  • Modelling of performance of deposits raised under the African Resource Mobilisation Initiative in order to determine their behavioral characteristics trend patterns and effects on the Bank's overall weighted average cost of funding and the residual liquidity risk that they present to the Bank
  • Maintain and enhance the cash models and monitor cash on a daily basis
  • Contribute to building models and business processes in respect of new activities (e.g. securitisation) that require modelling
• Treasury Activities Analysis and Reporting
  • Assist in the preparation of key treasury reports (daily weekly monthly quarterly semiannual and annual)
  • Analytics spreadsheet work model building reporting presentations and communications with third parties
  • Take ownership of liquidity reporting as required by Senior Management
  • Work with the Treasury Liquidity Management team in developing tailored reports on liquidity funding and other relevant reports requested by different stakeholders
  • Work with other Treasury team members to oversee daily monitoring of ALM Risks within the treasury function including early warning indicators and processes supporting the effective management of interest rate risk in the banking book
  • Check and challenge risks reported by Treasury ALM Monitoring team as an added layer of defense control.
• Treasury Business Improvement Processes
  • Ownership of all the Service Level Agreements with all key internal and external stakeholders
  • Ownership of the monitoring and reporting of all Service Level Agreements with all stakeholders
  • Ownership of the Treasury Processes and Procedures Manual and its relevant annual reviews and updates.
• Credit Rating Process Management
  • Provide support in all issues pertaining to credit rating process management such as data collection coordination with stakeholders data analytics and modelling report writing preparation of ratings book and summary presentations to rating agencies
  • Prepare draft responses to all followup questions asked by all credit rating agencies
  • Develop and prepare monthly credit rating activities reports
  • Document matters raised by credit rating agencies in meetings required for action
  • Review ratings reports research and publications from rating agencies before publication
  • Review and validate credit rating information and data received from various functions of the Bank
  • Resolve data anomalies through analysis and discussion with data champions
  • Assist the Treasurer in arranging credit rating agency meetings and engagements
  • Maintain a questionandanswer bank of all credit rating process related questions asked by credit rating agencies
  • Produce meeting reports of all credit rating meetings
  • Assist in the building of credit rating methodologies predictive models to be used by the Bank for credit rating analytics.
• Performance Management
  • Regularly update and ongoing monitoring of the division's performance analytical tracking model
  • Prepare and present a performance management report to the Treasurer and the team at large
  • Analyse all lagging critical performance metrices that require attention and action to change their lagging status
  • Work with the SEVP's office to update on all Treasury related performance on initiatives and various activities required for SEVP's attention
  • Ownership of the preparation and submission of all divisional performance related evidence to substantiate performance metrices in the Balanced
  • Scorecard system (Quickscore)
  • Ownership of the endtoend update process of performance data into the
  • Balanced Scorecard system (Quickscore)
  • Ownership of the endtoend tracking of the Treasury division desks
  • performance metrices and present same during divisional meetings
  • Collection of supporting evidence for all measured Treasury Balance Scorecard performance measures and initiatives metrices.
• Any other duties that may be assigned to the role holder by Senior Management from time to time

Requirements: Qualification and Skill

• A first degree in a relevant discipline i.e. accounting financial management economics numerical or other related disciplines and a postgraduate degree in a relevant field. Recognised professional certification in a relevant field may be acceptable in lieu of a post graduate degree
• Recognised Professional Qualification in Treasury AMCT CTP (US) ACT's Cert. in International Treasury Management ACT's Cert. in Cash Management ACT's Cert. in Risk Management ACT's Cert. Financial Mathematics & Modelling etc or Accounting (ACCA CIMA CPA or Equivalent) will be a strong added advantage but not a must however should be working towards achieving the aforementioned professional qualifications if not obtained already
• Excellent knowledge of accounting for treasury activities i.e. International Financial Reporting Standards (IFRS)
• A minimum of 5 years of experience working in either in an accounting firm and responsible for financial institutions or corporate institution preferably in the financial services industry
• Solid grounding in financial systems database methodologies and financial modelling
• Solid experience in working with Treasury Management Systems shall be an added advantage
• Operational experience in a finance department with significant systems exposure
• Knowledge of treasury debt capital markets financial instruments and structures shall be an added advantage
• Intermediate to advanced Excel skills and computer literacy (e.g. MS Office SQL Crystal Reports)
• Excellent verbal and written communication skills in English. Knowledge of the Bank's other working languages is an added advantage (French Arabic and Portuguese)
• Demonstrated personal leadership capabilities including ability to organize and manage available resources.

Contractual information:

• Permanent
• Willing and able to relocate to Egypt for the opportunity
• Suitably qualified candidates from all African & Caribbean nationalities are encouraged to apply

Caleb Ebrahim

Recruitment Consultant

Finance Fintech & IT

CA Global will respond to shortlisted candidates only. If you have not had any response in two weeks please consider your application unsuccessful however your CV will be kept on our database for any other suitable positions.