Chennai, Tamil NaduNoida, Uttar Pradesh

Job Summary

Role Summary

We are seeking a highly experienced Data Architect / Data Modeler (Contract) to lead the design of our enterprise data foundation using a contemporary Lakehouse (Medallion) architecture.

You will play a critical role in shaping a platform-agnostic, scalable data ecosystem, ensuring strong alignment with governance, data contracts, and long-term analytical needs.

Key Responsibilities

Key Responsibilities

Enterprise Data Architecture

Define and own the enterprise data architecture strategy.

Design end-to-end Medallion architecture (Bronze, Silver, Gold).

Develop and maintain canonical data models and conformed dimensions.

Establish architecture standards, modeling guidelines, and best practices.

Ensure scalability and platform-agnostic design with mínimal vendor lock-in.

Lead data contract design, schema governance, and versioning strategies.

Data Modeling

Design enterprise-grade dimensional models (Star, Snowflake, Galaxy).

Define fact tables (transactional, snapshot, accumulating).





Design dimension tables (SCD Type 1, 2, hybrid).

Define grain, keys, hierarchies, and business semantics.

Create conformed dimensions enabling cross-domain analytics.

Optimize models for performance and usability.

Design semantic models for BI and analytics.

Data Product & Domain Design

Define datasets as data products with ownership and SLAs.

Enable Data Mesh readiness through modular design.

Governance & Data Quality

Define governance frameworks including metadata, lineage, and cataloging.

Establish data quality rules and validation standards.

Ensure auditability, compliance, and traceability.

Security & Compliance

Embed RBAC, row/column security, masking, and encryption.

Ensure adherence to enterprise data protection standards.

Leadership & Stakeholder Engagement

Provide architectural leadership across teams.

Mentor engineers on best practices.

Align business requirements with scalable data

📌 Technical Architect (Chennai)
🏢 HCLTech
📍 Chennai