Data Modeller

Zoho; Chennai District; On-site; INR 350,000 - 800,000; Full time

Job summary

Zoho in Chennai seeks an experienced Data Modeller to design, implement, and maintain robust data architectures across IT services. You will translate complex business requirements into precise data models that support scalable analytics and governance initiatives.

The role focuses on Bronze/Silver/Gold layering, Data Vault 2.0, and governance tools like Purview, Collibra, and Unity Catalog, ensuring data quality and regulatory adherence while enabling efficient data integration.

Qualifications

• Minimum 12–15 years of experience in data modeling/architecture or related IT services domains.
• Proven expertise in Bronze/Silver/Gold layering in data architecture.
• Hands-on with data governance/cataloging platforms (Unity Catalog, Purview, Collibra).
• Deep understanding of Many-to-Many relationships, Bridge/Link tables.
• Strong knowledge of Business Keys and Surrogate Keys.
• Experience with Erwin or ER Studio.
• Experience applying Data Vault 2.0 in enterprise-scale projects.
• Advanced SQL proficiency.
• Experience with Azure Databricks or similar cloud data platforms.

Responsibilities

• Design and develop logical and physical data models using Bronze/Silver/Gold principles.
• Implement and manage data governance frameworks with Purview, Collibra, and Unity Catalog.
• Build complex data structures (Many-to-Many, Bridge, Link) to model business relations.
• Define standards for Business Keys and Surrogate Keys to ensure referential integrity.
• Use Erwin or ER Studio for documentation and schema visuals.
• Apply Data Vault 2.0 to flexible, auditable data warehouses.
• Write and optimize SQL queries for validation and transformations in Azure Databricks.
• Collaborate with teams to align data architecture with business goals.

Skills

Data modeling

Data architecture

Data governance

Data Vault 2.0

Bronze/Silver/Gold

Many-to-Many relationships

Bridge tables

Link tables

Business Keys

Surrogate Keys

Erwin

ER Studio

Unity Catalog

Microsoft Purview

Collibra

Azure Databricks

SQL

Education

Bachelor's degree or higher

Tools

Erwin

ER Studio

Unity Catalog

Microsoft Purview

Collibra

Azure Databricks

Job description

Job Description

Summary

We are seeking an experienced Data Modeller to design, implement, and maintain robust data architectures within the IT Services sector. This pivotal role involves translating complex business requirements into precise data models that support scalable analytics and governance initiatives. The successful candidate will leverage advanced modeling techniques and industry-leading tools to optimize data flow, ensure data integrity, and facilitate seamless integration across enterprise systems. This position is critical for driving data strategy, enabling high-performance data platforms, and ensuring compliance with organizational standards in a dynamic technology environment.

Responsibilities

• Design and develop comprehensive logical and physical data models utilizing Bronze, Silver, and Gold architecture principles to support advanced analytics.
• Implement and manage enterprise data governance frameworks using tools such as Microsoft Purview, Collibra, and Unity Catalog to ensure data quality and regulatory adherence.
• Construct complex data structures, including Many-to-Many, Bridge, and Link models, to accurately represent intricate business relationships and hierarchies.
• Define and enforce standards for Business Keys and Surrogate Keys to maintain referential integrity across diverse data sources.
• Utilize industry-standard modeling software like Erwin and ER Studio to create detailed documentation and visual representations of data schemas.
• Apply Data Vault 2.0 methodology to build flexible, scalable, and auditable data warehouses capable of handling historical data changes.
• Write and optimize complex SQL queries to validate data models, perform data transformations, and support backend processing within Azure Databricks environments.
• Collaborate with cross-functional teams to align data architecture with business objectives and technical requirements.

Requirements

Requirements:

• Minimum of 12 to 15 years of professional experience in data modeling, data architecture, or related IT services domains.
• Proven expertise in modern data architecture patterns, specifically the Bronze/Silver/Gold layering approach.
• Hands‑on proficiency with data governance and cataloging platforms, including Unity Catalog, Microsoft Purview, and Collibra.
• Deep understanding of advanced relational modeling concepts, such as Many-to-Many relationships, Bridge tables, and Link tables.
• Strong command of key management strategies, including the implementation of Business Keys and Surrogate Keys.
• Extensive experience with professional data modeling tools, specifically Erwin or ER Studio.
• Demonstrated ability to apply Data Vault 2.0 design principles in enterprise‑scale projects.
• Advanced proficiency in SQL for data manipulation, validation, and optimization.
• Practical experience working with cloud‑based data platforms, particularly Azure Databricks.