Data Modeler

Role overview

Data Modeler at Hoonartek

Design Conceptual, Logical and Physical Data Models for enterprise data platforms.

We are looking for an experienced Data Modeler responsible for designing scalable, governed, and high-performance data models for enterprise data platforms.

Responsibilities

• Develop dimensional models using Star and Snowflake schemas.
• Design fact and dimension tables, including conformed dimensions.
• Define grain, keys, relationships, cardinality and referential integrity.
• Design SCD Type 1, Type 2 and other historical tracking approaches.
• Work with Data Architects to define enterprise data architecture and modeling standards.
• Create models for Data Warehouse, Data Lake and Lakehouse environments.
• Develop data models for Bronze, Silver and Gold layers in a Lakehouse architecture.
• Optimize models for analytical workloads and BI reporting.
• Work closely with Power BI/Tableau teams to create models suitable for semantic-layer consumption.
• Analyze source systems and map source attributes to target data models.
• Perform source-to-target mapping and define transformation rules.
• Identify data quality, duplication, normalization and data integrity issues.
• Define metadata, business definitions and data lineage.
• Support Data Governance, Master Data Management and reference-data modeling.
• Collaborate with Data Engineers during implementation and validate the implemented model.
• Review SQL queries and database structures for performance and scalability.

Employment details

• Location: Pune [India]

Additional role details

• The role will work closely with Data Architects, Data Engineers, BI developers, business stakeholders, and application teams to translate business requirements into logical and physical data models.
• The candidate should have strong experience in enterprise data modeling, dimensional modeling, data warehousing, cloud data platforms, and modern Lakehouse architectures.