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.