Back to results

Lead Data Mapper

  • Toronto, ON, Canada

From $91 CAD / hour · Contract

Apply on insightglobal.com About employer

Applications open in a new tab.

Job details

Pay
From $91 CAD / hour
Job type
Contract
Experience
8+ years of experience in Data Modelling, Data Design, or Data Integration within Wealth Management, Asset Management, or Financial Services domains.
Posting language
English
Posted

Original job description

Required Skills & Experience

- 8+ years of experience in Data Modelling, Data Design, or Data Integration within Wealth Management, Asset Management, or Financial Services domains.
- Strong experience with source-to-target mapping and data transformation design.
- Experience designing data models for enterprise data platforms, data warehouses, or data lakes.
- Strong understanding of relational and dimensional modelling techniques.
- Experience working with cloud-based data platforms (AWS preferred).
- Excellent stakeholder management and communication skills.

Nice to Have Skills & Experience

- AWS (S3, Glue, Redshift, Lake Formation, Lambda).
- Salesforce data integration experience.
- DataOps or modern data platform experience.
- Data modernization or cloud migration project experience.

Job Description

Insight Global is seeking a Lead Data Designer/Data Mapper to support a large-scale Wealth Data Platform initiative. This role will own logical data models, source-to-target mappings, transformation rules, and integration specifications that enable consistent, high-quality data delivery across the enterprise. The successful candidate will partner closely with Business Analysts, Solution Architects, Data Engineers, and business stakeholders to translate requirements into scalable data designs.

Responsibilities
- Define logical, canonical, and dimensional data models.
- Create and maintain source-to-target mappings and transformation specifications.
- Design schemas and integration requirements for data warehouses, lakes, and analytics platforms.
- Define data quality, validation, reconciliation, and lineage requirements.
- Develop data contracts and interface specifications.
- Partner with architecture and engineering teams to ensure designs are implemented consistently.
- Support discovery, solution design, and project delivery activities.
More about this job

Responsibilities

The Lead Data Designer at Insight Global will design the data models and map how data moves from source systems to the target platform. They will write transformation rules, define data quality and lineage requirements, and make sure engineering teams build the designs consistently.

Requirements

Candidates need 8+ years of data modelling, design or integration experience in wealth management, asset management or financial services. They need strong source-to-target mapping, relational and dimensional modelling, and experience designing for warehouses, lakes or cloud platforms (AWS preferred).

Skills

  • Data modelling
  • Source-to-target mapping
  • Data transformation design
  • Relational modelling
  • Dimensional modelling
  • Canonical modelling
  • Data warehouse design
  • Data lake design
  • AWS
  • AWS S3
  • AWS Glue
  • AWS Redshift
  • AWS Lake Formation
  • AWS Lambda
  • Salesforce data integration
  • DataOps
  • Data quality
  • Data lineage
  • Data reconciliation
  • Data contracts
  • Interface specification
  • Stakeholder management
  • Requirements translation
  • Solution design
  • Cloud migration

Categories

  • Data & Analytics
  • Finance & Accounting
  • Technology

Keywords

  • Data Modelling
  • Data Mapping
  • Source-to-Target Mapping
  • Data Transformation
  • Dimensional Modelling
  • Logical Data Model
  • Canonical Data Model
  • Data Warehouse
  • Data Lake
  • AWS
  • S3
  • Glue
  • Redshift
  • Lake Formation
  • Lambda
  • Salesforce
  • DataOps
  • Data Lineage
  • Data Quality
  • Data Contracts

Seniority

Lead

Tools

  • AWS S3
  • AWS Glue
  • AWS Redshift
  • AWS Lake Formation
  • AWS Lambda
  • Salesforce

Report this job

Get in touch
MovoJobs

How can we help?