Data Mapping Lead

emagine Polska; Greater London; On-site; GBP 157,000 - 206,000; Full time

Job summary

RBC is seeking a Data Mapping Lead to own source-to-target mapping and assess system compatibility during the Pathway programme's migration into the Avaloq platform. You will surface conceptual mismatches and drive design decisions before testing, bridging technical build and business decisions with formal sign-off through structured show-and-tell sessions.

The role interfaces between data models, rules, and constraints across Banking, Credit, Insurance, and corporate lines, and requires strong

Qualifications

• Experience owning source-to-target mapping.
• Strong understanding of data models across Banking, Credit, Insurance, and corporate lines.
• Ability to create data models and mapping documentation.
• Experience leading meetings with stakeholders for formal agreement.

Responsibilities

• 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.

Skills

Mapping ownership

Data modeling

ETL planning

Stakeholder engagement

Migration defects analysis

Tools

Jira

Confluence

Salesforce

SQL

Job description

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.

Main Responsibilities

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.

Key Requirements

• 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.

Nice to Have

• Experience with the Avaloq platform.
• Familiarity with Salesforce CRM and SQL.
• Understanding of object modelling and design documentation.
• Background in testing and environment management.

Other Details

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.