Lead Data Mapper

Insight Global; Toronto; On-site; CAD 120,000 - 190,000; Full time

Job summary

Insight Global in Toronto is seeking a Lead Data Designer/Data Mapper to own logical data models, source-to-target mappings, transformation rules, and integration specs for a large Wealth Data Platform initiative.

You will partner with Business Analysts, Solution Architects, Data Engineers and business stakeholders to translate requirements into scalable data designs and ensure consistent, high-quality data delivery across the enterprise.

Qualifications

• 8+ years of experience in Data Modelling, Design, or Integration in financial services.
• Strong experience with source-to-target mappings and data transformation design.
• Experience designing data models for enterprise data platforms, data warehouses, or data lakes.
• Deep understanding of relational and dimensional modelling techniques.
• Experience with cloud-based data platforms (AWS) and data integration tools.

Responsibilities

• Define logical, canonical, and dimensional data models.
• Create and maintain source-to-target mappings and transformation specs.
• Design schemas for data warehouses, lakes, and analytics platforms.
• Define data quality, validation, lineage, and data contracts.
• Collaborate with architects and engineers to ensure consistent implementation.

Skills

Data Modelling

Data Design

Data Integration

Source-to-Target Mapping

Data Transformation

Enterprise Data Platforms

Relational & Dimensional Modelling

Cloud Data Platforms (AWS)

Salesforce Data Integration

DataOps / Modern Data Platform

Tools

AWS

Salesforce

Job description

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.

Skills and Requirements

• 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.
• AWS (S3, Glue, Redshift, Lake Formation, Lambda).
• Salesforce data integration experience.
• DataOps or modern data platform experience.Data modernization or cloud migration project experience.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].