Data Modeler

Zorba Consulting; Khordha, Bengaluru; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Zorba Consulting in India seeks an experienced Data Modeler with 8+ years to design, develop, and maintain enterprise data models for analytics and operations. You will work across conceptual, logical, and physical models and collaborate with stakeholders to translate requirements into scalable data architectures.

Responsibilities include maintaining ER diagrams and metadata, ensuring data quality and governance, optimizing databases for performance, and supporting ETL/ELT processes and data

Qualifications

• 8+ years of experience in Data Modeling and Data Architecture.
• Hands-on with ERwin, ER/Studio, IBM InfoSphere Data Architect.
• Strong SQL and data warehousing concepts across Oracle, SQL Server, PostgreSQL, or MySQL.
• Experience with Dimensional Modeling, Data Vault, Star Schema, Snowflake Schema.
• Knowledge of ETL/ELT processes, metadata management, data governance, and data quality frameworks.
• Experience with cloud platforms (Azure, AWS, GCP) and modern data warehouses (Snowflake, Redshift, Synapse, BigQuery).

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise applications and data warehouses.
• Collaborate with business stakeholders, solution architects, and data engineers to translate business requirements into scalable data models.
• Develop and maintain ER diagrams, data dictionaries, metadata, and data lineage documentation.
• Ensure data quality, consistency, integrity, and adherence to enterprise data governance standards.
• Optimize database structures for performance, scalability, and maintainability.
• Work with ETL/ELT teams to support data integration and transformation processes.
• Perform data analysis, normalization, dimensional modeling (Star/Snowflake Schema), and support data migration initiatives.
• Participate in data architecture reviews, model validation, and best practice implementation.

Skills

Data Modeling

Data Architecture

ER/Studio

SQL

Dimensional Modeling

ETL/ELT

Cloud Platforms

Stakeholder communication

Tools

ERwin

ER/Studio

InfoSphere Data Architect

Job description

• We are seeking an experienced Data Modeler with 8+ years of expertise in designing, developing, and maintaining enterprise data models that support analytical and operational systems.
• The ideal candidate should have strong experience in conceptual, logical, and physical data modeling, data architecture, data governance, and database design across large-scale enterprise environments.

Key Responsibilities:

• Design and maintain conceptual, logical, and physical data models for enterprise applications and data warehouses.
• Collaborate with business stakeholders, solution architects, and data engineers to understand business requirements and translate them into scalable data models.
• Develop and maintain ER diagrams, data dictionaries, metadata, and data lineage documentation.
• Ensure data quality, consistency, integrity, and adherence to enterprise data governance standards.
• Optimize database structures for performance, scalability, and maintainability.
• Work with ETL/ELT teams to support data integration and transformation processes.
• Perform data analysis, normalization, dimensional modeling (Star/Snowflake Schema), and support data migration initiatives.
• Participate in data architecture reviews, model validation, and best practice implementation.

Required Skills:

• 8+ years of experience in Data Modeling and Data Architecture.
• Hands‑on experience with ERwin, ER/Studio, IBM InfoSphere Data Architect, or similar data modeling tools.
• Strong expertise in SQL, relational databases (Oracle, SQL Server, PostgreSQL, or MySQL), and data warehousing concepts.
• Experience with Dimensional Modeling, Data Vault, Star Schema, Snowflake Schema, normalization, and denormalization.
• Knowledge of ETL/ELT processes, metadata management, data governance, and data quality frameworks.
• Experience working with cloud platforms such as Azure, AWS, or GCP and modern data warehouses like Snowflake, Redshift, Synapse, or BigQuery is preferred.
• Excellent analytical, problem-solving, and stakeholder communication skills.