Business Analyst, Client and Securities Data Migration
Business Analyst, Client andSecurities Data Migration
Location: Düsseldorf,Germany. On site with the source system teams.
Contract: duration, rateand start date to be confirmed.
Languages: German and English, both fluent. Hardrequirement
The work........
A substantial custody anddepositary book is transferring between institutions. The client records,account structures and holdings behind that book sit across a legacyapplication estate built up over decades.
Before anything moves, everyclient and every record attached to them has to be found, understood andspecified for extract. That is this role. It is discovery and specificationwork, not delivery of a platform.
The people who know the sourcesystems are German speaking and based in Germany. Much of the documentation isold and written in German. The backend is mainframe on both sides of thetransfer. Downstream applications include in-house Java systems and Power Apps.
What you will do…..
- Trace clients and theirassociated records across the source application estate, and produce theevidence that the set is complete rather than asserting it.
- Work directly with the sourcesystem owners to establish what each system holds, how it is keyed, and wherethe same client appears under different identifiers.
- Read and interpret the existingsystem and process documentation, including legacy German language material,and turn it into something the migration team can work from.
- Define the extract, transform andload rules for client static data, account and fund structures, holdings andpositions.
- Reconcile migrated records backto source and produce the evidence that the book transferred intact.
- Work with the mainframe platformteams on both sides of the move, so the target receives data in the shape itexpects.
- Specify what the downstreamapplications need from the migrated data.
Requirements
- Fluent German and English,because the source system owners work in German and the legacy documentation isin German.
- Business analysis on a clientmigration or a data migration, inside a bank or a securities services business.
- Domain knowledge in custody,depositary, fund administration or securities operations, covering clientstatic data, account and fund structures, holdings and positions.
- Data analysis you have doneyourself: profiling, record counts, reconciliation, exception analysis, and theability to prove a number rather than report one.
- Enough mainframe familiarity towork with platform teams on data structures, file layouts and recorddefinitions. You will not be writing code.
- Experience of a book transfer ora business carve-out between institutions, rather than an internal platformupgrade, since the two are not the same job. ETL design and data lineagetooling. Depositary oversight or regulated reporting. SQL.
#J-18808-Ljbffr
