Business Analyst, Client and Securities Data Migration

Yadimen Consulting Limited; Düsseldorf; Vor Ort; EUR 65.000 - 95.000; Vollzeit

Zusammenfassung

Yadimen Consulting Limited is seeking a Business Analyst for client and securities data migration in Düsseldorf, Germany. This on-site role focuses on discovery and specification rather than platform delivery, with German-speaking stakeholders and legacy German documents.

You will map data, define ETL rules, and verify records across mainframe and downstream applications. Fluency in German and English is required, and prior bank or securities services experience with custody or depositary data

Qualifikationen

• Fluent German and English, as source system owners work in German.
• Experience in business analysis for client/data migrations in banking or securities services.
• Domain knowledge in custody, depositary, fund administration or securities operations.
• Data analysis experience including profiling, counting, reconciliation, and exception analysis.
• Familiarity with mainframe data structures; no coding required.
• Experience of book transfers or business carve-outs; ETL design and data lineage tooling.

Aufgaben

• Trace clients and relevant records across source systems and prove completeness.
• Collaborate with source-system owners to map keys and cross-identifiers.
• Read legacy German documents and translate into actionable migration work artefacts.
• Define extract, transform and load rules for client static data, accounts and holdings.
• Reconcile migrated records to source and demonstrate transfer integrity.
• Coordinate with mainframe teams to ensure target data shape matches expectations.
• Specify downstream data needs for migrated systems.

Kenntnisse

German fluency

English fluency

Business analysis

Data migration

Mainframe familiarity

Data profiling

Record reconciliation

ETL design

Data lineage tooling

Depositary knowledge

Custody domain

SQL

Tools

SQL

Mainframe familiarity

Jobbeschreibung

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, 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 the evidence 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 or a 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.