Data Modeler

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