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