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.
