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.
Skills Required
- Fluent German and English
- Business analysis experience in client migration or data migration within a bank or securities services business
- Domain knowledge in custody, depositary, fund administration, or securities operations
- Knowledge of client static data, account and fund structures, holdings, and positions
- Hands-on data analysis experience including profiling, record counts, reconciliation, and exception analysis
- Mainframe familiarity, including data structures, file layouts, and record definitions
- Ability to work on site in Düsseldorf, Germany
- Experience with book transfers or business carve-outs between institutions
- ETL design and data lineage tooling experience
- Depositary oversight or regulated reporting experience
- SQL experience
What We Do
Yadimen Consulting is a technology consulting firm focused on financial-services organizations. It delivers technology implementation and strategic consulting services, drawing on expertise in data engineering, fraud strategy, data science, enterprise platforms, and product implementation. The company operates across the US, UK, Nordic countries, and Western Europe, helping clients address sector-specific technology challenges and opportunities through tailored solutions for financial institutions and regulated businesses.
