Fund Accounting Data Migration Consultant - 6 month contract - £650-750pd (inside IR35)
Leading Investment Management client is seeking a Data Migration Consultant to join a team supporting the migration of their fund-accounting data, processes, reports and interfaces from an existing fund accounting platform to a future platform. The role will lead current-state discovery, data profiling, migration mapping, reconciliation and testing while the target solution is selected, and will support broader technology and production needs.
Hybrid working model - 3 days a week in office + 2 days working from home
Key responsibilities
- Inventory the current fund accounting platform environment, including data, configurations, calculations, processes, reports, interfaces, controls and downstream consumers.
- Work with Fund Accounting, Real Estate Debt, business and technology SMEs to document funds, vehicles, legal entities, investments, investors, ownership, transactions, commitments, cash flows, balances, valuations and history.
- Profile data for missing or inconsistent identifiers, incomplete fields, duplicate or orphaned records, invalid relationships, mapping issues and reporting differences.
- Create source-to-target mappings and transformation rules once the target platform and migration scope are confirmed.
- Develop SQL utilities for extraction, profiling, transformation, validation, reconciliation and exception reporting.
- Define repeatable reconciliations across fund, vehicle, legal entity, investment, loan, position, transaction, commitment, balance and reporting period.
- Support mock conversions, system and user testing, parallel processing, defect investigation, migration rehearsals and cut over.
- Support BAU priorities including SQL work, feed troubleshooting, accounting data analysis, reporting, reconciliation and production issues.
Required experience
- Advanced SQL Server and T-SQL development experience.
- Experience supporting fund-accounting, investment-accounting, financial-system or comparable data migrations.
- Working knowledge of fund accounting, multi-entity investment structures, transactions, balances, commitments and historical data.
- Experience with data profiling, source-to-target mapping, transformation rules, data quality and financial reconciliation.
- Experience identifying downstream reports, feeds, applications and business processes dependent on a source platform.
- Strong documentation, communication, stakeholder-management and knowledge-transfer skills.
Preferred experience
- Commercial real estate, investment management and/or CML experience.
- Direct experience with fund accounting software or comparable investment accounting platforms.
- Experience with MRI, RealINSIGHT, Aladdin, eFront, Pereview, Databricks, Power BI or SQL Server Reporting Services.