| 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 modern Lakehouse (Medallion) architecture.
This role is primarily focused on enterprise data architecture and advanced data modeling , including the creation of canonical models, conformed dimensions, and scalable semantic structures. The ideal candidate will bring deep expertise in dimensional modeling, domain-oriented design, and enterprise data architecture , with the ability to define reusable, governed, and business-aligned data assets .
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 minimal 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.
Apply domain-driven design principles.
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-
