Market / Data Risk Analyst (Middle Office) recruitment
This role will specifically concentrate on commodities. However the role will also be used to help out on equities, interest rate and FX products. We are seeking for a candidate with Advanced/ Strong Excel, as they will be building modules and pie charts from scratch. VBA and SQL skills and experience must be advanced.
The Data Steward team works in delivering risk reporting (VaR) across asset classes on a daily basis. Data stewards manage data to allow risk managers to manage risk.
The team works on the data validation of feeds and monitoring of feed times so VaR figures are ready for risk managers, senior management and the desks in a timely fashion. The team is also responsible for the monthly PV reconciliation - this is to confirm that all trades are flowing into the risk system.
Main Function
- Completion on monthly reconciliation process to ensure completeness of risk as compared to finance. The process involves comparing the two sources and investigating any differences.
- Assisting in production of daily risk reports (VaR) that are sent to senior management, front office and GMRM, for commodities, ensuring governance around all risk reporting is maintained to a high standard
- Ensuring completeness of risk reporting and building and maintaining relationships across the bank to maintain the completeness and capture and resolve exceptions.
- Produce management information (MI) on exceptions and reconciliation of those exceptions
- Building and running data integrity checks around the risk reporting systems
- To be the main point of contact with the commodities risk management team, working on feed issues.
- Managing relationships with other operations teams that are responsible for maintaining data (book information etc)
- Periodic detailed reviews of risk for specific businesses to improve confidence in reporting
- Assist with monitoring and management of controls around all data used in the reports e.g. feed data
- Assisting rates and currencies and equities teams where required on specific projects.
Experience
- Degree or Professional Qualification in a numerate a subject (i.e. finance, mathematics)
- Excellent data analysis skills using spreadsheets and databases to detect issues.
- Must have Advanced Excel/VBA skills and preferably SQL skills to build and maintain tools that will help in carrying out the responsibilities in this role
- Prior experience in either market risk, risk reporting or data validation
- Knowledge in commodities products preferable.
- Ability to communicate effectively with the team and various teams within the bank to get results
- A team player who is ambitious and focused
- Self-motivated, takes ownership of responsibilities assigned to him/her
- Proven ability to deliver high quality work in a relatively unsupervised environment, while working under pressure