Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to reconcile data and resolve discrepancies in client portfolios daily.
- Company: Be part of a dynamic Private Investment Office focused on innovative financial solutions.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: Gain hands-on experience in finance while collaborating with industry experts in a supportive environment.
- Qualifications: Previous reconciliation experience is essential; familiarity with Addepar or Clearwater Analytics is a plus.
- Other info: Training provided for candidates eager to learn and grow in the finance sector.
The predicted salary is between 36000 - 60000 £ per year.
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 exceptions 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.
Assets 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 individual 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 with 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.
Data & Portfolio Reconciliation Analyst - 6 Months Fixed Term Contract employer: W1M Wealth & Investment Management
Contact Detail:
W1M Wealth & Investment Management Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data & Portfolio Reconciliation Analyst - 6 Months Fixed Term Contract
✨Tip Number 1
Familiarise yourself with Addepar and Clearwater Analytics before applying. Understanding how these platforms work will give you a significant edge during the interview process, as you'll be able to discuss your insights and experiences confidently.
✨Tip Number 2
Network with professionals in the investment banking or asset management sectors. Engaging with individuals who have experience in reconciliations can provide you with valuable insights and potentially lead to referrals that could help you land the job.
✨Tip Number 3
Prepare to discuss specific examples of how you've resolved discrepancies in past roles. Being able to articulate your problem-solving skills and attention to detail will demonstrate your suitability for the role and impress the hiring managers.
✨Tip Number 4
Showcase your ability to work under pressure by sharing relevant experiences during interviews. Highlighting instances where you've successfully managed tight deadlines or complex tasks will illustrate your capability to thrive in a fast-paced environment.
We think you need these skills to ace Data & Portfolio Reconciliation Analyst - 6 Months Fixed Term Contract
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data reconciliation, particularly with platforms like Addepar and Clearwater Analytics. Emphasise any previous roles in investment banking or asset management that demonstrate your ability to handle similar responsibilities.
Craft a Strong Cover Letter: In your cover letter, explain why you are interested in the Data & Portfolio Reconciliation Analyst position. Mention specific skills that align with the job description, such as attention to detail and experience with data entry, and how they will benefit the company.
Showcase Relevant Experience: When detailing your work history, focus on your experience with reconciliations and any familiarity with financial instruments mentioned in the job description. Use quantifiable achievements to illustrate your impact in previous roles.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for this role.
How to prepare for a job interview at W1M Wealth & Investment Management
✨Know Your Platforms
Familiarise yourself with Addepar and Clearwater Analytics, as well as any similar reporting platforms. Be prepared to discuss your experience with these tools and how you've used them in previous roles.
✨Highlight Your Reconciliation Experience
Make sure to emphasise your direct experience in reconciliations, especially within investment banking or asset management. Prepare specific examples of discrepancies you've resolved and the processes you followed.
✨Demonstrate Attention to Detail
Since this role requires a keen eye for detail, be ready to showcase instances where your attention to detail made a significant impact. Discuss how you ensure accuracy in data entry and reconciliation tasks.
✨Build Relationships
The role involves liaising with various stakeholders, so be prepared to talk about your experience in building and maintaining professional relationships. Share examples of how you've collaborated with teams or external parties to resolve issues.
