Trade Support - Excel at Phi Partners, London, to £400 per day

£300 - £400 per day
  • Contract Spy
  • London, UK
  • Nov 19, 2020
Duration not stated

Contract Description

Front Office Excel Strats Specialist

London, UK

Phi Partners are supporting the London based securities and investment banking arm of one of the top 20 financial banking groups in the world, who are headquartered in Tokyo and have operations across the Europe, Middle East, Americas and Asia, counting more than 50,000 employees. This client specialises in sales and trading, both in debt and equity securities, the underwriting of new issues and M&A advisory services, and aims at increasing the balance of individual customer assets under its management by 1.5-fold to ¥60 trillion in 10 years.

Overview of the Project Engagement

For 3 years now Phi have been continuously delivering projects and pieces of work for the Information Systems department of this client. These were spanning across areas such as Front Office and e-trading, where the client uses technologies such as ION MMI, as well as Middleware and Risk IT areas, working on in-house technology solutions that serve the global business of this client. Regulations such as IBOR replacement and FRTB requested change activities that have been reflecting on pricing libraries, risk areas and other Front Office components such as e-trading applications, affecting pricing, execution, booking and processing of trades to the business, which is monitored and used on the trading floors with Excel spreadsheets, that now require modifications and enhancements.

The role:

We are now looking for a Front Office Excel Strats Specialist who will be working on extending and supporting the complex spreadsheets associated with the client Rates Derivates and Cash (Rates & Credit) desks. The consultant will be responsible for:
  • Designing/developing complex trader spreadsheets used for pricing and position keeping,
  • Delivering to agreed requirements as well as analysing and maintain existing spreadsheets,
  • Support of all implemented solutions including incident, problem, and defect management,
  • Working alongside IT teams, Front Office traders, sales and research.
Required skills:
  • Experience working within the Front Office of Investment Banks,
  • Necessary skills, experience and attitude to gather, understand, and analyse functional requirements directly from the Front Office Trading and Sales desks,
  • Ability to design/develop complex trader spreadsheets,
  • Deep knowledge of Excel VBA, SQL database setup, writing stored procedures and business rules is crucial,
  • Knowledge of Fixed Income and eTrading platforms, ION, Bloomberg, analytic and vendor Add-ins,
  • Bonds product knowledge is essential, ideally along with IRS and cash products,
  • Great communication skills and ability to clearly document and communicate objectives, requirements and designs at different levels of abstraction
  • This is an opportunity to work in cooperation with some of the most brilliant technologists and business users in the world, working for a particularly fast paced, technologically fine and advanced client that on-boards only the most talented professionals. The role will give you the possibility of engaging in long term projects from initiation to completion, utilising modern delivery methodologies such as Agile, Containerisation and Continuous Integration, as well as exposure to various areas of the business along with complex (legacy, vendor and new in-house) technologies and innovative ideas.
If you believe that this is the role for you I am keen to receive your CV and schedule a call at your earliest convenience.