Data Modeler

Position: Data Modeller

Experience: 10+ years

Location: Sholinganallur, Chennai

Position: Permanent

Work Mode: 5 Days WFO (Onsite)

Responsibilities

• Design and own the conceptual, logical, and physical data models, specifically implementing Data Vault 2.0 architecture including Hubs, Links, and Satellites.
• Integrate AI-assisted development tools such as GitHub Copilot into data modeling and engineering workflows to automate repetitive SQL/DDL generation and accelerate delivery.
• Define the overarching data architecture strategy, including patterns for historical data retention, auditability, and integration across the global enterprise.
• Act as the bridge between business domains and technical teams, translating complex business ontologies into robust Data Vault structures.
• Establish data modeling standards, hashing rules, and data lineage tracking while ensuring compliance and data privacy support.
• Provide technical leadership to a global team of data modelers and engineers.
• Educate internal teams on Data Vault 2.0 best practices and secure, effective use of AI-coding tools.
• Facilitate modeling workshops to identify core business concepts.
• Design Point-in-Time (PIT) and Bridge tables.
• Review automated or AI-generated dbt models and SQL scripts to ensure they meet Data Vault 2.0 standards.

Position Summary

• 10+ years of overall IT/Data experience, with at least 5+ years dedicated to Enterprise Data Architecture and Data Modeling.
• Deep, proven expertise in designing and implementing Data Vault 2.0 architectures (Hubs, Links, Satellites, Hash Keys, PIT/Bridge tables).
• Practical experience implementing and guiding teams on AI-assisted development tools (GenAI, LLMs, Copilot) to accelerate data engineering and modeling workflows.
• Advanced SQL proficiency and hands-on experience with modern cloud data platforms (e.g., Snowflake, Azure Synapse).