Business Analyst, Client and Securities Data Migration
Summary
Contract business analyst role in Düsseldorf doing discovery and specification for a custody/depositary book transfer: tracing client records across legacy German source systems, defining ETL rules, and reconciling migrated data between mainframe platforms. Needs fluent German and English plus securities services domain knowledge.
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.
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.