Portfolio Data Migration Consultant (Contract)

Marks Sattin; Greater London; Hybrid; GBP 74,000 - 92,000; Full time

Job summary

Marks Sattin is seeking a Portfolio Data Migration Consultant for a 3-6 month contract in London, Hybrid. You will help migrate portfolio data to a new PMS, interrogate data, reconcile attributes, and ensure a reliable dataset ahead of migration.

You should bring experience in portfolio monitoring or fund operations within alternatives, strong Excel and data manipulation skills, and familiarity with SQL/Power Query; Dynamo experience is advantageous.

Qualifications

• Experience in portfolio monitoring, fund operations, or middle office in an alternative investment environment.
• Strong Excel and data manipulation skills; SQL/Power Query helpful.
• Experience with Portfolio Management System implementations, migrations, upgrades or data projects.
• Ability to reconcile system data against source documents and investigate discrepancies.

Responsibilities

• Assist in migrating portfolio data to the new PMS and ensure data accuracy.
• Identify inconsistencies and missing information; coordinate resolutions with relevant teams.
• Support reconciliation, testing and UAT post-migration to verify data integrity.

Skills

Excel

SQL

Power Query

Data reconciliation

Dynamo

Attention to detail

Cross-functional collaboration

Tools

Dynamo

Job description

Portfolio Data Migration Consultant - Alternative Investments (Contract)

3-6 Month Contract London Hybrid - 3-4 Days in Office ASAP Start
Day Rate £400-500 per day via umbrella

An established alternative investment firm is undertaking a significant upgrade of its portfolio management infrastructure (PMS) and is looking for an experienced Portfolio Data Migration Consultant to join the project on an interim basis.

Sitting at the intersection of investments, finance, operations and technology, the role will focus on ensuring the firm's investment data is accurate, complete and ready to migrate onto a new Portfolio Management System (PMS).
This is not simply a data-cleansing exercise. You will need to understand what sits behind the numbers.
Working across a portfolio spanning private equity and direct lending, you will interrogate investment data and reconcile key attributes back to underlying records and legal documentation. This could include reviewing loan characteristics, investment terms, transaction data, investment-period end dates and other critical portfolio information.
You will identify inconsistencies and missing information, work with the relevant teams to resolve them and help establish a reliable dataset ahead of migration. Following migration, you may also support reconciliation, testing and UAT to ensure information has transferred accurately and the new platform operates as intended.

What we are looking for:

You are likely to have gained your experience within portfolio monitoring, fund control, fund operations, investment operations or middle office in an alternative investment environment.

You should bring:

• Strong knowledge of alternative investment products, ideally including private equity and private credit/direct lending.
• Experience working with investment and portfolio data and the ability to understand the commercial meaning behind individual data points.
• Previous involvement in a Portfolio Management System implementation, migration, upgrade or data project.
• Excellent Excel and data-manipulation skills. SQL / Power Query skills would be useful.
• The ability to reconcile system data against source documentation and investigate discrepancies rather than simply flagging them.
• Exceptional attention to detail and a structured approach to data quality.
• Confidence working across investment, finance, operations, legal and technology teams.

Previous experience with Dynamo would be highly advantageous, although candidates who have worked on comparable alternative-investment PMS platforms will also be considered.