Posts Tagged ‘SQL’

Senior Middle Office Professional (Stamford, CT)

May 25, 2010

Senior Middle Office Analyst

 This Investment group manages a fund (1X and 2X) with effective AUM of approx $1 billion.  Growth has been very strong as 2009 ended with $400MM AUM.  Almost $600mm AUM has been added.  The key to this role is futures or commodities experience.  Greeks essential!

Position Overview:

This role in a hedge fund specialized in soft commodities (mainly agricultural commodities). Your role is important to the whole organization. You will be responsible for calculating the NAV (Net Asset Value) on a daily basis. You will also reconcile daily the trades in our systems, comparing the broker’s statements with what is showing in our internal position management system. We expect you to be able to automate your tasks so it makes your job more efficient. That is why we will consider a strong VBA knowledge as an important positive point.

The Middle-Office function in our fund has two main components: NAV calculation, RISK calculation. Your job will concentrate mainly on the NAV calculation. The job will offer you the ability to expand your knowledge as we plan to open different funds in the medium term. The reconciliation process means you will have daily contacts with the traders and deliver for them. We want you to be a self-starter as management time will be limited. Hence after a few weeks/months spent to understand fully the tools you are working with, we want you to be pro-active and find ways to improve them. We have a one team approach, so you will most likely assume other people’s responsibilities (when they are away for instance), this represents a good opportunity to widen your skills (in market risk analysis for instance).

Key Functions and Responsibilities:

  • Reconciling trades on a daily basis
  • Calculate the NAV daily.
  • Reconcile our NAV with the administrator NAV monthly
  • Reconcile FX movements across the books.
  • Identifying all major risks associated with the company’s ongoing operations and conduct of its business and evaluating the potential risks being undertaken as a result of business growth and development.
  • Check with traders that the reported positions are accurate and that the NAV makes sense.
  • Have a thorough knowledge of our systems (from Front-Office to Back-Office).
  • Contribute to the ongoing improvement of our systems
  • Ensure inputs to the risk system (both positions and prices) are accurate and timely
  • Improve the internal reporting procedures.
  • Provide assistance with ongoing development of the current databases
  • Analyze the reported figures and contribute to the enforcement of Stop Loss Limits
  • Monitor portfolio intra day / provide real time updates to Portfolio managers as Greek’s change  / risks within portfolio change
  • Ad-hoc analysis

Key Competencies:

  • Attention to details with a strong focus on accuracy of information.
  • Logical, analytical, numerical ability.
  • Willingness and ability to work with and improve existing procedures
  • Strong interpersonal skills. Ability to resolve issues and liaise with Portfolio managers / Risk officer and management globally.
  • Positive attitude and enthusiastic approach. Ability to work in a team environment and meet deadlines.
  • Strong IT skills. Excel required, good VBA knowledge beneficial, PowerPoint, SQL, and Access.
  • Self-starter, Self motivated and a quick learner
  • Strong English language
  • Able to work easily in a multi-cultural environment
  • Good presentation skills.


  • Previous exposure in a trading environment, middle-office, risk management or related function within a trading environment.
  • Knowledge of physical soft commodity markets or futures is a MUST.
  • Exposure to VaR useful, in addition to MtM / PnL


  • To COO located internationally…