Data Modeller

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 versatile, 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.
- Robust 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.

📌 Data Modeller (Chennai)
🏢 Vrinda International
📍 Chennai