Summary of functions/responsibilities
Working in the Private Investment Office & Institutional teams, the Data & Portfolio Reconciliations Analyst will carry out a daily data feed reconciliation function to identify, investigate and resolve any discrepancies across client portfolios and funds in APX, Addepar & Clearwater Analytics. The reconciliation function includes the reconciling and checking of data exception across all client portfolios on the Addepar & Clearwater Analytics platforms. This will include identifying issues and omissions from data feeds from external sources and flagging this to the PMs. Asset are held within segregated portfolios across multiple custodians and these assets include exchange traded assets such as equities, REITs, ETFs; debt instruments; funds; exchange traded derivatives; private equity; FX spot; FX forwards and cash. Client portfolios are to be reconciled to the custodian and/or APX for both cash and securities held where exceptions are apparent.
The role will include some data entry responsibilities to ensure transactions are correctly reflected until the data feed is corrected at source. Types of data entry will include dividends; coupon payments; interest Income; fees; fund subscriptions and fund redemptions and internal/external transfers. There will also be a requirement to review, verify and maintain a series of custom data fields that may apply to individuals securities (e.g. specific trading strategy classifications) and portfolios (e.g. maintaining trading groups and reporting aggregates).
Responsibilities will also include monitoring and managing benchmark data, setting up and adjusting compliance rules for individual portfolios and working the portfolio managers to complete the setup of new accounts on the Addepar & Clearwater Analytics systems - this includes the setup of client/portfolio reporting and bespoke report development functions in collaboration with portfolio managers.
The analyst resource will be responsible for sourcing statements from custodians and platforms from a variety of sources and formats:
* Online access directly to the custodian
* Receipt of paper statements emailed or posted to the reconciliations team from the custodian
* Data files sent by Custodians
Key Responsibilities / Accountabilities
* Responsible for the exception data entry where needed and reconciliation functions for an allocated list of clients on the Addepar & Clearwater Analytics platforms
* To allocate accounts on Addepar & Clearwater Analytics platforms to the correct client entity, groups and aggregates
* To monitor individual client portfolios on Addepar & Clearwater Analytics and manage security classifications specific to clients' asset allocations
* To monitor pricing exceptions on Addepar & Clearwater Analytics platforms and source updated pricing where needed (including updating fund pricing)
* Liaise as required with the relevant custodian to source client statements and investigate and resolve all discrepancies in order to carry out the reconciliation function
* Build and maintain good relationships with key internal company stakeholders across Operations, Front Office and external counterparties including custodians
Personal Experience and Requirements
* Familiarity with Addepar and/or Clearwater Analytics, or previous direct experience working with similar consolidated reporting platforms
* Experience in building performance and holdings reports
* Ideally, a minimum of 12 months direct reconciliations experience gained from a similar environment; Investment Banking/Asset Management/Wealth Management environment
* Prior experience of reconciling individual client portfolios
* Prior experience of reconciling funds would be an advantage
* Data entry experience
* Attention to detail
* Ability to work under pressure
* Self-disciplined and confident with the ability to work on own initiative and in a small team and take ownership of the tasks received
* Previous experience of working with Advent APX or Advent Axys would be an advantage but not essential
* Only candidates with previous reconciliations experience and knowledge should apply.
* Training will be given