| JOB NAME |
Consultant, Analyst , Treasury and Markets (Business Support Treasury Planning Analytics Performance Management) [Cairo, Egypt]
POSTED BY: African Export and Import Bank AFREXIMBANK Egypt
REF:AFREXIM 2009
Date Published:Tuesday, September 24, 2024
Date of Expiration:Sunday, March 23, 2025
RECOMMEND THIS JOB ON FACEBOOK
|
|
|
| LOCATION OF THIS JOB |
 Egypt | CAIRO in Egypt |
| INDUSTRY |
| DEVELOPMENT FINANCE INSTITUTIONS
|
| JOB TYPE |
| Full-Time |
| MAIN JOB DESCRIPTION |
Working time Full-time
Posted 1 week ago
Location Cairo, Egypt
Deadline 09/30/2024
Reference CEBLR22
RESPONSIBILITIES:
1. 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.
2. The Candidate must be a self-starter and a financial mathematics and modelling enthusiast with excellent report writing skills and a finance and accounting background.
3. 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.
4. The candidate must demonstrate influence and credentials to effectively model the forward-looking balance sheet and other financial reports.
5. Treasury Planning Process
1) Assist in the treasury planning process and reporting processes
2) Work with Treasury Assets and Liabilities sub-units to analyse and plan strategic asset allocations for excess cash
3) Assist with all fund-raising 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.
6. Treasury Financial Data Modelling and Analysis
1) Contribute to the building of data collection and sanitization templates
2) Collection and sanitization of date pre-analytics
3) Work with Finance and the wider Treasury function in modelling of the Balance
4) Sheet to reflect a plausible forward-looking perspective for ALCO purposes
5) 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
6) Maintain and enhance the cash models and monitor cash on a daily basis
7) Contribute to building models and business processes in respect of new activities (e.g. securitisation) that require modelling
7. Treasury Activities Analysis and Reporting
1) Assist in the preparation of key treasury reports (daily, weekly, monthly, quarterly, semi-annual and annual)
2) Analytics, spreadsheet work, model building, reporting, presentations and communications with third parties
3) Take ownership of liquidity reporting as required by Senior Management
4) Work with the Treasury Liquidity Management team in developing tailored reports on liquidity, funding and other relevant reports requested by different stakeholders
5) 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
6) Check and challenge risks reported by Treasury ALM Monitoring team as an added layer of defense control.
8. Treasury Business Improvement Processes
1) Ownership of all the Service Level Agreements with all key internal and external stakeholders
2) Ownership of the monitoring and reporting of all Service Level Agreements with all stakeholders
3) Ownership of the Treasury Processes and Procedures Manual and its relevant annual reviews and updates.
9. Credit Rating Process Management
1) 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
2) Prepare draft responses to all follow-up questions asked by all credit rating agencies
3) Develop and prepare monthly credit rating activities reports
4) Document matters raised by credit rating agencies in meetings required for action
5) Review ratings reports, research, and publications from rating agencies before publication
6) Review and validate credit rating information and data received from various functions of the Bank
7) Resolve data anomalies through analysis and discussion with data champions
8) Assist the Treasurer in arranging credit rating agency meetings and engagements
9) Maintain a question-and-answer bank of all credit rating process related questions asked by credit rating agencies
10) Produce meeting reports of all credit rating meetings
11) Assist in the building of credit rating methodologies predictive models to be used by the Bank for credit rating analytics.
10. Performance Management
1) Regularly update and ongoing monitoring of the division’s performance analytical tracking model
2) Prepare and present a performance management report to the Treasurer and the team at large
3) Analyse all lagging critical performance metrices that require attention and action to change their lagging status
4) Work with the SEVP’s office to update on all Treasury related performance on initiatives and various activities required for SEVP’s attention
5) Ownership of the preparation and submission of all divisional performance related evidence to substantiate performance metrices in the Balanced
6) Scorecard system (Quickscore)
7) Ownership of the end-to-end update process of performance data into the
8) Balanced Scorecard system (Quickscore)
9) Ownership of the end-to-end tracking of the Treasury division desks
10) performance metrices and present same during divisional meetings
11) Collection of supporting evidence for all measured Treasury Balance Scorecard performance measures and initiatives metrices.
11. Any other duties that may be assigned to the role holder by Senior Management from time to time
|
| REQUIREMENTS FOR THIS JOB |
QUALIFICATION AND SKILL
1. 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
2. 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
3. Excellent knowledge of accounting for treasury activities i.e. International Financial Reporting Standards (IFRS)
4. 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
5. Solid grounding in financial systems database methodologies and financial modelling
6. Solid experience in working with Treasury Management Systems shall be an added advantage
7. Operational experience in a finance department with significant systems exposure
8. Knowledge of treasury, debt capital markets, financial instruments and structures shall be an added advantage
9. Intermediate to advanced Excel skills and computer literacy (e.g. MS Office, SQL, Crystal Reports)
10. Excellent verbal and written communication skills in English. Knowledge of the Bank’s other working languages is an added advantage (French, Arabic and Portuguese)
11. Demonstrated personal leadership capabilities, including ability to organize and manage available resources.
Contractual information:
1. 1 Year Fixed Term Contract
2. Willing and able to relocate to Egypt for the opportunity
3. Suitably qualified candidates from all African & Caribbean nationalities are encouraged to apply
APPLICATION
If you wish to apply for the position, please send your CV to Caleb Ebrahim at cebrahim@caglobalint.com
|
|
English 
FRENCH
