Business Analyst, Client and Securities Data Migration

Business Analyst, Client and Securities Data Migration

 Location: Düsseldorf, Germany. On site with the source system teams.

Contract: duration, rate and start date to be confirmed.

Languages: German and English, both fluent. Hard requirement

The work........

A substantial custody and depositary book is transferring between institutions. The client records, account structures and holdings behind that book sit across a legacy application estate built up over decades.

Before anything moves, every client and every record attached to them has to be found, understood and specified for extract. That is this role. It is discovery and specification work, not delivery of a platform.

The people who know the source systems are German speaking and based in Germany. Much of the documentation is old and written in German. The backend is mainframe on both sides of the transfer. Downstream applications include in-house Java systems and Power Apps.

What you will do…..

* Trace clients and their associated records across the source application estate, and produce the evidence that the set is complete rather than asserting it.

* Work directly with the source system owners to establish what each system holds, how it is keyed, and where the same client appears under different identifiers.

* Read and interpret the existing system and process documentation, including legacy German language material, and turn it into something the migration team can work from.

* Define the extract, transform and load rules for client static data, account and fund structures, holdings and positions.

* Reconcile migrated records back to source and produce the evidence that the book transferred intact.

* Work with the mainframe platform teams on both sides of the move, so the target receives data in the shape it expects.

* Specify what the downstream applications need from the migrated data.

Requirements

Essential

* Fluent German and English, because the source system owners work in German and the legacy documentation is in German.

* Business analysis on a client migration or a data migration, inside a bank or a securities services business.

* Domain knowledge in custody, depositary, fund administration or securities operations, covering client static data, account and fund structures, holdings and positions.

* Data analysis you have done yourself: profiling, record counts, reconciliation, exception analysis, and the ability to prove a number rather than report one.

* Enough mainframe familiarity to work with platform teams on data structures, file layouts and record definitions. You will not be writing code.

* Able to work on site in Düsseldorf.

 

Desirable

Experience of a book transfer or a business carve-out between institutions, rather than an internal platform upgrade, since the two are not the same job. ETL design and data lineage tooling. Depositary oversight or regulated reporting. SQL.