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 up-to-date 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 models.

Skill Requirements

Required Qualifications

8+ years in data architecture and modeling.

Deep expertise in dimensional modeling (facts, dimensions, SCDs).

Experience with canonical models and Medallion architecture.

Strong governance, metadata, and data contract experience.

Preferred Qualifications

Experience with Data Mesh and domain-driven architecture.

Familiarity with governance tools

Exposure to dbt and semantic modeling frameworks.

Tools & Technologies

Azure Databricks, Delta Lake, Unity Catalog

dbt, SQL-based tools

ADLS Gen2

KPIs / Success Metrics

Adoption of canonical models

Model reusability and consistency

Data quality and governance maturity

Reduced data duplication

Faster delivery of analytics datasets

Contract Details Duration : 6 months (extendable) Location : Remote Engagement : Contractor Start Date : Immediate

#body.unify div.unify-button-container.unify-apply-now : focus, #body.unify div.unify-button-container.unify-apply-#body.unify div.unify-button-container.unify-apply-now: focus, #body.unify div.unify-button-container.unify-apply

📌 Technical Architect (Dpo) (Chennai)
🏢 HCLTech
📍 Chennai