Data Modeller

Bean Hr Consulting; Gurugram District, Bengaluru; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Bean Hr Consulting in Gurugram invites an experienced Data Modeler to architect conceptual, logical and physical models for data warehouses, lakehouses, analytics ecosystems, and enterprise platforms.

You will design dimensional models, establish data dictionaries, metadata, and data lineage, collaborate with stakeholders, and contribute to Agile delivery and UAT.

Expertise across Snowflake, Databricks, and cloud data services is preferred to drive scalable data products and governance.

Qualifications

• 5+ years of hands-on data modeling experience.
• Experience with dimensional, ER, star/snowflake modeling.
• Experience with data dictionaries, mappings, metadata, lineage.
• Proficiency in SQL for profiling and validation.
• Familiarity with data governance and data contracts.
• Experience with Agile delivery and UAT.
• Strong communication with stakeholders.

Responsibilities

• Model data for data warehouses, lakehouses, analytics platforms.
• Design dimensional models, star/snowflake schemas, and conformed dimensions.
• Develop data dictionaries, mappings, metadata, lineage, and glossaries.
• Work with Snowflake, Databricks, Azure Data Lake, Redshift, SQL Server, dbt, Erwin/ER/Studio.
• Ensure data quality, governance, and reusable datasets.
• Collaborate with business stakeholders and support Agile delivery.

Skills

Dimensional modeling

ER modeling

Star/Snowflake schemas

SCD & normalization

SQL profiling & validation

Data dictionaries & metadata

Data lineage & governance

Agile delivery & UAT

Stakeholder communication

Data products knowledge

Tools

Snowflake

Databricks

Azure Data Lake

Redshift

SQL Server

dbt

Erwin

ER/Studio

Job description

Job Title: Data Modeler / Data Product Specialist

Experience: 5+ Years

Job Description:

We are looking for an experienced Data Modeler with strong hands‑on expertise in conceptual, logical, and physical data modeling for data warehouses, lakehouses, analytics, and enterprise data platforms.

Key Responsibilities & Skills:

• Strong expertise in dimensional modeling, ER modeling, Star/Snowflake schemas, fact/dimension tables, SCD, normalization, and conformed dimensions.
• Strong SQL skills for data profiling, source analysis, relationship validation, and business‑rule testing.
• Experience creating data dictionaries, source-to-target mappings, metadata definitions, data lineage, and business glossaries.
• Knowledge of Snowflake, Databricks, Azure Data Lake, Redshift, SQL Server, dbt, Erwin, or ER/Studio.
• Understanding of data products, data quality, governance, data contracts, and reusable datasets.
• Experience with business requirement gathering, UAT, reconciliation, model validation, and Agile delivery.
• Strong communication and stakeholder‑management skills.

Preferred Background:

Data Modeler, Data Architect, Data Warehouse Architect, or Data Engineer with proven hands‑on data modeling experience.