Senior Data Modeller

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. 

We are seeking a skilled and detail-oriented Data Modeler to join our team. The ideal candidate will possess expertise in dimensional data modeling, SQL, and data mapping, with the ability to collaborate effectively with cross-functional teams. You will play a key role in delivering end-to-end solutions by translating business requirements into robust data models and ensuring the quality and accuracy of data-driven insights.

Key Responsibilities:

1. 
   
2. Requirements Analysis:

• Engage with stakeholders to thoroughly understand and document business requirements.
• Conduct comprehensive analyses to verify data availability for identified use cases.
  
  

• Identify and assess potential impacts on data models.
• Validate business rules within the data and coordinate with source teams to address data quality issues.
  
  

• Develop Conceptual, Logical, and Physical Dimensional Data Models using Erwin, adhering to industry best practices.
• Create detailed data mapping documentation for all data model attributes.
  
  

• Facilitate handover sessions with ETL, Testing, and BI teams to discuss business requirements, data models, and mapping documents.
• Provide continuous feedback and clarification throughout the development and testing phases.
  
  

• Perform sample data validations to ensure the data behaves as expected post-development.
• Update and maintain documentation to reflect any modifications to mappings or data models.
  
  

• Oversee report creation by the BI team using Power BI, ensuring alignment with business needs.
• Validate reports with stakeholders to confirm accuracy and relevance.
  
  

• Address production issues and design ad hoc solutions as needed using SQL on Snowflake.
• Leverage a basic understanding of Informatica Intelligent Cloud Services (IICS) for resolving data challenges.

Qualifications:

• Bachelor's degree in computer science, Information Technology, or a related field.
• Proven experience in data modeling with proficiency in Erwin. Experience with Teradata Reference Data Model is a plus.
• Strong SQL skills, with experience in Snowflake.
• Basic understanding of Informatica Intelligent Cloud Services (IICS) and Power BI.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills to work effectively with cross-functional teams.
  
  

Preferred Qualifications:

• Experience in the financial industry or investment domain is highly desirable.
• Familiarity with Agile methodologies.
  
  

Soft Skills:

• Attention to detail and the ability to work independently.
• Proactive approach to identifying and solving data-related challenges.
• Strong documentation and organizational skills.

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.
Make it real |