Senior Data Modeller
at Capgemini
Posted 17 hours ago
No clicks
- Compensation
- Not specified
- City
- Not specified
- Country
- Portugal
Currency: Not specified
Join Capgemini Engineering as a Data Modeller responsible for designing, developing, and maintaining high-quality data models that support enterprise analytics, reporting, and governance. You will work closely with engineering, data governance, and business teams to ensure data structures are efficient, consistent, and aligned with enterprise standards. Key responsibilities include data modeling & architecture, defining data quality rules and metadata standards, and contributing to data lineage and governance efforts. Collaborate with ETL/ELT engineers on schema deployment, indexing, and performance optimization, and communicate model changes and dependencies to technical and non-technical stakeholders.
CAPGEMINI ENGINEERING
At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same.
YOUR ROLE
Data Modeling & Architecture
- Design dimensional models (fact tables, conformed dimensions, SCD types) and/or 3NF or Data Vault structures appropriate for business and technical requirements.
- Create and maintain conceptual, logical, and physical data models that adhere to enterprise architecture standards.
- Define data quality rules, metadata standards, and naming conventions to ensure governance and consistency across systems.
Engineering Collaboration
- Generate DDL and collaborate with engineering teams on schema deployment, indexing strategies, and performance optimization.
- Work closely with ETL/ELT engineers to ensure that pipelines, transformations, and data flows align with model structures.
Governance & Documentation
- Contribute to data lineage, cataloging, and metadata management efforts in partnership with Data Governance teams.
- Clearly communicate model changes, business impacts, and dependencies to technical and non‑technical stakeholders.
YOUR PROFILE
Technical Expertise
- Demonstrated experience in data modeling, including dimensional modeling (star, snowflake), normalization (3NF), and/or Data Vault 2.0.
- Strong SQL and DDL skills, with the ability to reason about query performance, indexing, and partitioning.
- Familiarity with data quality, metadata, and data lineage practices.
Tools Experience
- Proficiency with at least one enterprise data modeling tool, such as:
SAP PowerDesigner, ERwin Data Modeler, ER/Studio, Oracle SQL Developer Data Modeler, SQLDBM, DbSchema, Vertabelo, Hackolade, Toad Data Modeler, InfoSphere Data Architect, pgModeler, or Sparx Enterprise Architect.
Collaboration & Awareness
- Ability to work effectively in cross-functional teams, bridging technical and business perspectives.
- Awareness of ETL/ELT and orchestration concepts (e.g., Informatica, SSIS, Talend, Matillion, dbt, Airflow, ADF, Databricks); hands‑on pipeline development is not required.
WHAT YOU’LL LOVE ABOUT WORKING HERE
- Join a multicultural and inclusive team environment.
- Enjoy a supportive atmosphere promoting work-life balance.
- Hybrid work.
- Your career growth is central to our mission. Our array of career growth programs and diverse professionals are crafted to support you in exploring a world of opportunities.
- Access valuable training and certifications in cutting-edge technologies.
- Engage in exciting national and international projects.
- Health and life insurance.
- Referral program with bonuses for talent recommendations.
- Great office locations.
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.
