Coherent Pixel System Hiring – Consultant / Data Architect
Location: Chennai
Mode: WFO / Hybrid
Shift: 12:00 PM – 9:00 PM IST
Experience: 10+ Years
Job Description
The Data Architect is responsible for designing a highly scalable and agile Enterprise Data Warehouse (EDW) using Data Vault 2.0 methodology. The role involves solving complex data modeling challenges while championing AI-assisted development tools to automate and accelerate the generation of data models, mappings, and standardized Data Vault boilerplate code.
Responsibilities
- Design and own conceptual, logical, and physical data models implementing Data Vault 2.0 architecture (Hubs, Links, Satellites).
- Integrate AI-assisted development tools (e.g., GitHub Copilot) into data modeling and engineering workflows.
- Automate repetitive SQL/DDL generation and accelerate delivery timelines.
- Define enterprise-wide data architecture strategies for historical retention, auditability, and system integration.
- Collaborate with business and technical teams to translate business ontologies into scalable Data Vault structures.
- Establish data modeling standards, hashing rules, and lineage tracking mechanisms.
- Ensure architecture supports compliance, governance, and data privacy standards.
Tools & Technologies
- Data Vault 2.0
- Snowflake
- Azure Synapse
- dbt
- Erwin / Hackolade
- AI Coding Assistants (GenAI, GitHub Copilot, LLMs)
Requirements
- 10+ years of overall IT/Data experience.
- 5+ years of hands-on Enterprise Data Architecture and Data Modeling experience.
- Deep expertise in designing and implementing Data Vault 2.0 architectures, including:
- Hubs
- Links
- Satellites
- Hash Keys
- PIT / Bridge Tables
- Practical experience guiding teams on AI-assisted development workflows.
- Advanced SQL proficiency.
- Hands-on experience with modern cloud platforms like Snowflake and Azure Synapse.
Contact Details
Immediate Joiners Only Preferred
Drop your CV to:
Contact / WhatsApp:
Work Location: In person
