Data Modeler

Your Role

As a Data Modeler at Capgemini, you will play a key role in analyzing legacy data integration solutions, defining enterprise data models, and supporting modernization initiatives in cloud-based data platforms. You will work closely with Data Engineers, Architects, and Business Stakeholders to understand existing data transformation logic, develop source-to-target mappings, and ensure data quality throughout migration and modernization efforts.

This role requires strong SQL expertise, experience with SSIS reverse engineering, and a solid understanding of data modeling principles and best practices. You will serve as a critical bridge between legacy systems and modern Azure-based data platforms.

Responsibilities & Scope

• Analyze and interpret existing SSIS packages, workflows, and data transformation processes.
• Reverse engineer legacy ETL jobs to identify business rules, transformation logic, dependencies, and data flows.
• Document transformation processes, technical specifications, and data lineage in a clear and structured manner.
• Design and maintain conceptual, logical, and physical data models based on business and technical requirements.
• Apply industry-standard data modeling methodologies including:
• Third Normal Form (3NF)
• Star Schema
• Dimensional Modeling
• Develop comprehensive source-to-target mapping documents incorporating transformation logic, business rules, and lineage requirements.
• Collaborate with Enterprise Architects and Data Engineering teams to ensure alignment with target-state data architectures.
• Work closely with Data Engineers developing modern pipelines in Azure Databricks and cloud-based environments.
• Provide functional and technical guidance throughout the development lifecycle.
• Conduct data validation activities between legacy systems and new cloud platforms.
• Verify transformation accuracy and ensure data quality standards are consistently met.
• Identify, document, and support the resolution of data quality and reconciliation issues.
• Contribute to data governance, documentation, and metadata management initiatives.

Your Profile

• Analytical thinker – Able to understand complex legacy systems and translate technical logic into scalable data solutions.
• Data modeling expert – Strong understanding of relational and dimensional data modeling principles.
• Documentation-focused – Creates clear, detailed, and accurate technical documentation and mapping specifications.
• Collaborative partner – Effectively works with architects, engineers, analysts, and business stakeholders.
• Problem sol