Data Modeler

We are seeking a highly experienced Senior Data Modeler with expertise in data modeling, architecture, and analytics. This role is critical in designing and optimizing data models for complex systems across diverse platforms. The ideal candidate will bring domain knowledge in investment management and hands-on experience with Data Vault 2.0 implementation.

Job Responsibilities:

• Data Modeling:
  Lead the design and development of conceptual, logical, and physical data models for enterprise-scale systems.
• Data Architecture:
  Collaborate with architects to build scalable, high-performance data models for analytics, reporting, and BI.
• Domain Expertise:
  Apply investment management domain knowledge to align data models with business strategies.
• Data Vault 2.0 Implementation:
  Design and implement data models using Data Vault 2.0 methodology.
• Stakeholder
  
  Collaboration:
  
  Work with business analysts, data engineers, and stakeholders to gather and translate data requirements.
  
  Data Governance & Quality:
  Ensure compliance with data governance, security, and quality standards. Implement validation and quality checks.
  
  Performance Tuning:
  Optimize data models and queries for performance and scalability.
  
  Mentorship:
  Guide and mentor junior data modelers and analysts.
• Best Practices:
  Define and enforce data modeling standards and best practices.
• Documentation:
  Maintain comprehensive documentation including ERDs, data dictionaries, and schema definitions.
• Innovation:
  Stay updated with industry trends and emerging technologies in data modeling and analytics.

Required Skills:

• Experience:
  
  data modeling, data architecture, or related fields.
• Domain Knowledge:
  Strong understanding of investment management processes and data.
• Tools:
  Proficiency in Erwin, IBM Info Sphere Data Architect, Microsoft Visio, or similar tools.
• Databases:
  Expertise in SQL, No
  
  SQL, Oracle, SQL Server, MySQL, Postgre
  
  SQL, Hadoop, etc.
• Cloud Platforms:
  Experience with AWS, Azure, or GCP; familiarity with Snowflake, Redshift, Big Query.
• Design Principles:
  Deep understanding of normalization, denormalization, star/snowflake schemas, and ETL processes.
• Methodologies:
  Experience working in Agile and Dev Ops environments.
• Governance:
  Knowledge of data privacy, security protocols, and governance frameworks.
• Business Acumen:
  Ability to align data architecture with business goals and strategies.

Life at Capgemini:

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

Healthcare including dental, vision, mental health, and well-being programs

Financial well-being programs such as 401(k) and Employee Share Ownership Plan

Paid time off and paid holidays

Paid parental leave

Family building benefits like adoption assistance, surrogacy, and cryopreservation

Social well-being benefits like subsidized back-up child/elder care and tutoring

Mentoring, coaching and learning programs

Employee Resource Groups

Disaster Relief

Disclaimer:

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant

Salary Transparency Disclaimer:

C…