Data Modeller - Erwin/ER/Studio

About the Role :

We are hiring an experienced Data Modeler to drive enterprise-scale data modernization and AI readiness initiatives. This role focuses on designing, standardizing, and governing enterprise data models across modern cloud data platforms.

You will work closely with Data Architects, Data Engineers, and Business Stakeholders to translate complex business requirements into scalable, high-performance data models that support analytics, interoperability, and decision-making.

Key Responsibilities :

- Design and develop Conceptual, Logical, and Physical Data Models aligned with enterprise architecture standards

- Translate business requirements, workflows, and data flows into robust and scalable data models

- Analyze end-to-end business processes and value chains (Customer, Product, Finance, Supply Chain) to define data entities and relationships

- Build dimensional data models (Star Schema, Snowflake Schema) for data warehouse and analytics use cases

- Design physical data models optimized for performance on cloud platforms like Snowflake, Databricks, Redshift, Dremio

- Develop and maintain semantic layers for BI tools and data discovery platforms

- Implement and enforce data standards, naming conventions, metadata management, and lineage tracking

- Collaborate with data engineering teams to ensure alignment between data pipelines, ETL processes, and data models

- Manage version control, documentation, and change management for enterprise data models

- Participate in data governance and data quality initiatives to ensure consistent and trusted data

- Create and maintain business glossary and metadata definitions in collaboration with governance teams

Required Skills & Experience:

- 7 to 15 years of experience in Data Modeling / Enterprise Data Architecture

- Strong hands-on experience in Conceptual, Logical, and Physical Data Modeling

- Expertise in Dimensional Modeling (Kimball), Inmon methodology, normalization techniques

- Experience with modern data platforms: Snowflake, Databricks, Amazon Redshift, Dremio

- Proficiency in SQL and schema design, with ability to validate implementations

- Hands-on experience with data modeling tools : Erwin, ER/Studio, PowerDesigner, SQLDBM or similar

- Strong understanding of data warehousing, data lakes, and lakehouse architectures

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

Preferred Skills :

- Experience with data governance and metadata tools: Collibra, Alation, Microsoft Purview

- Exposure to ETL / ELT tools: Informatica, DBT, Airflow

- Understanding of Master Data Management (MDM) and reference data management

- Experience in domains like High-Tech, Manufacturing, Supply Chain, Customer or Product Data

Why Join us :

- Work on cutting-edge data modernization and AI readiness programs

- Exposure to modern cloud data stack (Snowflake, Databricks, Lakehouse)

- Opportunity to influence enterprise-wide data strategy and architecture

- Collaborative environment with strong focus on data governance and innovation