Jobs → Data & Analytics → Data Architect - MS Fabric

About the Role We are seeking a Data Modeling Architect to define and implement the enterprise modeling framework for an advanced data fabric architecture. The architect will establish reusable data contracts and canonical definitions that support interoperability, discoverability, trusted data products, and analytics across Microsoft Fabric and connected enterprise platforms. Key Responsibilities • Define an enterprise ontology and domain taxonomies that establish consistent business terminology, entity definitions, relationships, and business rules across functional domains. • Develop conceptual and logical models that capture domain boundaries, shared entities, reference data, cardinality, hierarchies, and cross-domain relationships. • Select appropriate modeling patterns, including normalized entity-relationship models, dimensional models, Data Vault, and canonical data models, based on integration and consumption requirements. • Design physical models for Microsoft Fabric Lakehouse and Warehouse workloads, including Delta table structures, partitioning strategies, keys, schema evolution, and query-performance considerations. • Design and govern open table-format implementations using Apache Iceberg, Apache Hudi, and Delta Lake across lakehouse workloads. • Select the appropriate table format based on interoperability, transaction requirements, ingestion patterns, query-engine compatibility, performance, cost, governance requirements, and operational supportability. • Define physical table-design standards for partitioning, clustering or data layout, compaction, file sizing, retention, schema evolution, partition evolution, and metadata management. Requirements • Strong data modeling expertise and hands-on implementation experience with Microsoft Fabric • Experience with OneLake, Lakehouse, Warehouse, Data Pipelines, and Power BI semantic models • Knowledge of Apache Iceberg, Apache Hudi, and Delta Lake • Understanding of enterprise architecture standards and operational processes