Jobiglo

No results.

This job is no longer available

This job expired on 22/09/2026. It no longer accepts applications.

Data Modeler

Capgemini · Mexique

🇬🇧 English
SQL SSIS Azure Databricks Dimensional data modeling

Job description

About the role

As a Data Modeler at Capgemini you will analyse legacy data integration solutions, define enterprise data models and support migration to cloud‑based platforms. You will collaborate with data engineers, architects and business stakeholders to translate existing ETL logic into modern Azure data pipelines.

Key responsibilities

  • Analyze and interpret existing SSIS packages, workflows and data transformation processes.
  • Reverse engineer legacy ETL jobs to capture business rules, transformation logic, dependencies and data flows.
  • Document transformation processes, technical specifications and data lineage clearly.
  • Design and maintain conceptual, logical and physical data models based on business and technical requirements.
  • Apply industry‑standard modeling methodologies such as Third Normal Form (3NF), star schema and dimensional modeling.
  • Develop comprehensive source‑to‑target mapping documents incorporating transformation logic and lineage.
  • Collaborate with enterprise architects and data engineering teams to align with target‑state data architectures.
  • Provide functional and technical guidance throughout the development lifecycle.
  • Conduct data validation between legacy systems and new cloud platforms, ensuring transformation accuracy and data quality.
  • Identify, document and support resolution of data quality and reconciliation issues.
  • Contribute to data governance, documentation and metadata management initiatives.

Required profile

  • Analytical thinker able to understand complex legacy systems and translate technical logic into scalable data solutions.
  • Data‑modeling expert with strong knowledge of relational and dimensional modeling principles.
  • Documentation‑focused, producing clear and detailed technical specifications.
  • Collaborative partner who works effectively with architects, engineers, analysts and business stakeholders.
  • Problem solver who identifies data challenges, investigates root causes and proposes solutions.

Required skills

  • SQL
  • SSIS
  • Azure Databricks
  • Azure cloud platforms
  • Relational data modeling (3NF)
  • Dimensional data modeling (star schema)

Questions fréquentes

Le salaire n'est pas communiqué publiquement par le recruteur. Vous pouvez postuler et négocier directement avec Capgemini.
Cliquez sur "Postuler maintenant" en haut de la page. Vous pouvez importer votre CV en 1 clic — Jobiglo extrait automatiquement vos informations et postule pour vous.

Why are you reporting this job?

Thank you for your report. We will review this job.

A question about this job?

Ask it here: you will get the full job summary by e-mail, right away.

Published 3 months ago

21 views · 0 interested

Boost your chances

Upload your CV — we will match you with relevant openings.

Analyzing your CV...

Capgemini

Mexique