Data Mapping Lead (h / f)

Role Overview

RBC requires a Data Mapping Lead to own source-to-target mapping and system compatibility analysis across the Pathway programme's migration into the Avaloq platform. This goes beyond field-level mapping: the individual must build a genuine understanding of how the source and target systems each model, validate, and process data - their rules, constraints, and structural differences - surfacing conceptual mismatches during discovery so that behavioural gaps become design decisions made in advance, rather than defects discovered in test.

The role sits at the interface between technical build and business decision-making: standing in front of the business to explain what has been established, what is being done, and what developers need to build - and driving formal sign-off through show-and-tells, under tight documentation discipline.

The Data Mapping Lead will:

• Own source-to-target mapping and system compatibility analysis, going beyond field-level mapping to a full understanding of source/target data models, rules, and constraints.

• Create Conceptual, Logical and Physical data models and associated mapping documentation.

• Define the ETL build sprint plan.

• Lead mapping meetings with business stakeholders to drive agreement and formal sign-off.

• Work closely with the Test Manager and other Migration sub-workstreams to identify root cause on migration defects.

• Use Jira and Confluence for tracking and documentation.

• Experience in ownership of source-to-target mapping.

• Strong understanding of data models across Banking, Credit, Insurance, and corporate business lines.

• Ability to create data models and mapping documentation.

• Experience leading meetings with stakeholders for formal agreement.

• Proficient in Jira and Confluence usage.

• Strong analytical and problem-solving skills related to migration defects.

• Experience with the Avaloq platform.

• Familiarity with Salesforce CRM and SQL.

• Understanding of object modelling and design documentation.

• Background in testing and environment management.

This is a non-managerial role with an engagement start date ASAP. The position will require a focus on the Banking and CI business in the interim as workstreams are completed. The day rate for this role is £985.