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 Dat

📌 Data Modeler (Aguascalientes)
🏢 Capgemini
📍 Aguascalientes