Role & responsibilities

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

- 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.

Preferred candidate profile

📌 Data Modeler (Pune)
🏢 Hoonar Tekwurks Consulting
📍 Pune