P&l Project Analyst - London, United Kingdom - RICHARD JAMES RECRUITMENT SPECIALISTS LTD

RICHARD JAMES RECRUITMENT SPECIALISTS LTD
RICHARD JAMES RECRUITMENT SPECIALISTS LTD
Verified Company
London, United Kingdom

2 weeks ago

Tom O´Connor

Posted by:

Tom O´Connor

beBee Recruiter
Description

Key objectives of the project:

  • Replacing Excel based reporting with system based reporting
  • Build out of a reporting tool to review, adjust and report the daily P&L for all trading books in the London portfolio
  • Implementation of a single valuation engine for Open & Accrued P&L for all trading instruments to replace the multiple valuation engines used at the moment
  • System based P&L Explain calculations and reporting on a consistent manner across all trading instruments
  • Implementation of a system based reporting workflow including formal trader signoff
  • System based T+0 flash P&L reporting by 5pm each business day
Main responsibilities

  • Assisting with the design and testing of the new system based P&L reporting tool. This involves both working on the requirements to be delivered by the IT team as well as detailed UAT testing of the tool to ensure those requirements are being met.
  • Regularly reconciling the P&L numbers reported by the new tool vs the existing P&L process. Identifying valuation differences that will need investigating and where required, working with the relevant IT team to remediate and resolve.
  • Supporting the migration process of ~400 trading books from the existing Excel based reporting process to the new reporting tool.
  • Supporting the development of P&L explain calculations to ensure P&L from all lifecycle events are accounted for.
  • Assisting in the development of a reporting workflow including formal trader signoff.
  • Adhoc analysis as required for the project or wider Product Control function.
Key requirements

  • Experience in Product Control (2+ years), preferably within Commodities and likely to also have 23 years' experience in a back office finance role such as treasury or settlements
  • Detailed understanding of valuation principles for different types of derivative instruments (Physicals, Swaps, Futures, Options) across their life cycle, and ability to break down the valuation of a trading instrument into underlying cashflows
  • Ability to perform P&L explain/attribution of a trading instrument across different life cycle events
  • Experience of working on projects within Product control or Finance space is desired but not essential
  • Ability to work independently, own and investigate issues to the point of resolution
  • Comfortable manipulating and reconciling large datasets in Excel
  • Proactive and highly motivated to learn
  • Analytically minded with fluent communication skills
  • VBA and experience with Alteryx preferred but not essential
Studied towards or passed the ACA is desirable but also not essential
More jobs from RICHARD JAMES RECRUITMENT SPECIALISTS LTD
See all jobs of RICHARD JAMES RECRUITMENT SPECIALISTS LTD