Data Model Consultant

Job Title: Data Model Consultant

Experience: 7–9 Years (Mandatory)
Location: Remote 

Only CV matching with the JD will be shortlisted

Role Purpose

We are seeking an experienced Data Model Consultant to design and evolve scalable, high-quality data models within a modern data platform. This role focuses on building and maintaining core (Silver Layer) data models using structured modeling techniques, ensuring consistency, reusability, and alignment with business requirements across domains.

Key Responsibilities

Data Modeling & Design

• Design and evolve core (Silver Layer) data models within an existing Anchor Modeling framework
• Translate business requirements into well-structured, normalized data models, aligned with source system structures
• Build highly normalized models (3NF / 6NF) for scalable and reusable core data layers
• Ensure consistency, integrity, and reusability of data entities across domains

Data Architecture & Standards

• Apply best practices for historization, change tracking, and auditability
• Contribute to data modeling standards, naming conventions, and governance frameworks
• Support the evolution of enterprise-wide data modeling practices

Collaboration & Delivery

• Work closely with data engineering teams to ensure efficient transformations in Snowflake
• Collaborate with business and analytics teams to align models with business needs
• Participate in Agile delivery processes, including sprint planning and tracking via Jira

Data Quality & Documentation

• Support data validation, reconciliation, and quality assurance processes
• Document data models, relationships, and business logic for broader team understanding
• Maintain clear and structured metadata and lineage documentation

Required Skills & Experience

• Strong experience in data modeling for data warehouses on Snowflake
• Expertise in:
  • Highly normalized modeling (3NF / 6NF / Core layer modeling)
  • Designing scalable and reusable data structures
• Solid understanding of:
  • Data integration across multiple source systems
  • Change tracking and historization concepts
• Hands-on experience with Snowflake and advanced SQL
• Experience working in structured modeling environments or frameworks
• Strong ability to translate business concepts into clean, maintainable data models
• Proven collaboration skills with data engineering and analytics teams
• Experience working in Agile environments using Jira

Nice to Have

• Conceptual understanding of Anchor Modeling (anchors, attributes, ties, historization)
• Experience with Data Vault or other temporally-aware modeling approaches
• Familiarity with Medallion architecture (Bronze / Silver / Gold layers)
• Exposure to data governance, lineage, and metadata management practices

Soft Skills

• Strong communication and stakeholder management skills
• Analytical thinking with attention to detail
• Problem-solving mindset with a structured approach
• Ability to work independently and collaboratively in cross-functional teams