Data Modeler

Description :

- Develop conceptual, logical, and physical data models aligned with enterprise architecture standards.

- Engage with Business Stakeholders : Collaborate with business teams, business analysts and SMEs to understand business processes, data lifecycles, and key metrics that drive value and outcomes.

- Value Chain Understanding : Analyze end-to-end customer and product value chains to identify critical data entities, relationships, and dependencies that should be represented in the data model.

- Conceptual and Logical Modeling : Translate business concepts and data requirements into conceptual and logical data models that capture enterprise semantics and support analytical and operational needs.

- Physical Data Modeling : Design and implement physical data models optimized for performance and scalability

- Semantic Layer Design : Create semantic models that enable business access to data via BI tools and data discovery platforms.

- Data Standards and Governance : Ensure models comply with enterprise data standards, naming conventions, lineage tracking, and governance practices.

- Implement naming conventions, data standards, and metadata definitions across all models.

- Collaboration with Data Engineering : Work closely with data engineers to align data pipelines with the logical and physical models, ensuring consistency and accuracy from ingestion to consumption.

- Manage version control, lineage tracking, and change documentation for models.

- Participate in data quality and governance initiatives to ensure trusted and consistent data definitions across domains.

- Create and maintain a business glossary in collaboration with the governance team.

Ideal Candidate :

- Strong Enterprise Data Modeller profile (Modern Data Platforms)

- Must have 7+ years of experience in Data Modeling or Enterprise Data Architecture, with strong hands-on expertise in designing conceptual, logical, and physical data models for enterprise data platforms

- Must have Strong hands-on experience with enterprise data modeling tools such as Erwin, ER/Studio, PowerDesigner, SQLDBM, or similar enterprise data modeling tools

- Must have Deep understanding of dimensional modeling (Kimball / Inmon methodologies), normalization techniques, and schema design for modern data warehouse environments.

- Proven experience designing data models for modern data platforms such as Snowflake, Databricks, Redshift, Dremio, or similar cloud data warehouse / lakehouse systems.

- Must have strong SQL expertise and schema design skills, with the ability to validate data model implementations and collaborate closely with data engineering teams

- Bachelors or Masters degree in Computer Science, Information Systems, or a related technical field.

(ref:hirist.tech)