Key responsibilities – P&L Reconciliations
STEP 1
- Reconcile P&L for individual traders or desks between internal system and service provider (Experience with Pershing an advantage)
- Understanding of Equity trading flow process – ESSENTIAL
- Experience of interacting with Traders
- Ability to communicate with finance teams
- Process system improvement
STEP 2
- Manage internal CRM
- IT Integration
- Data quality management
- Build and use Excel models to aggregate and compute results
- Ensure calculations align with accounting standards and internal methodologies
Reconciliations (Excel-heavy)
- Reconcile calculated P&L against:
- Front office (trading systems)
- Back office / finance systems
- Identify and resolve breaks
Data Integrity & Controls
- Ensure trade capture and market data are correct
- Perform checks on inputs feeding into P&L
- Reduce risk of misstatement
Stakeholder Interaction
- Work with traders, finance, tech teams and external providers to:
- Confirm P&L numbers
- Resolve discrepancies
- Improve reporting accuracy
Process Improvement
- Automate P&L calculation and reconciliation processes (Excel)
- Improve speed and accuracy of reporting
- Suggest improvements in the overall process – important
Key skills required
- Advanced Excel (core tool for trader P&L)
- Strong understanding of Equity Trading Process
- Ability to work under pressure (tight daily deadlines)
- Strong communication (especially with front office)
- High attention to detail
…
