Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

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

📌 Data Modeler (Aguascalientes)
🏢 Capgemini
📍 Aguascalientes