Lead Data Mapper
- Toronto, ON, Canada
From $91 CAD / hour · Contract
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.
- 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