Chennai, Tamil Nadu

Job Summary

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.

Required Qualifications

8+ years in data architecture and modeling.

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

Experience with canonical models and Medallion architecture.

Solid 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.

To

📌 Azure DevOps Lead Technical Consultant (Chennai)
🏢 HCLTech
📍 Chennai