Senior Data Architect

Role Summary

We are seeking a Senior Data Architect with 14+ years of experience to serve as the design authority for enterprise data platforms. The role owns architecture and data-design decisions, enterprise data models, ERDs, modelling standards, and design governance across Microsoft Fabric and the broader data ecosystem.

Key Responsibilities

· Own enterprise data architecture and end-to-end data-design decisions across source, integration, storage, modelling, semantic, and reporting layers.

· Develop and maintain conceptual, logical, and physical data models and current-state and target-state ERDs.

· Define entities, attributes, primary and foreign keys, relationships, cardinality, optionality, grain, and integration boundaries.

· Establish and govern enterprise data-modelling standards, naming conventions, reusable patterns, documentation templates, and model version-control practices.

· Lead design reviews, approve data models, document architecture decisions, manage design exceptions, and resolve cross-domain modelling conflicts.

· Design relational and dimensional models, including facts, dimensions, conformed dimensions, bridge tables, factless facts, surrogate keys, and aggregation strategies.

· Define standards for normalization, denormalization, Slowly Changing Dimensions, effective dating, late-arriving data, historization, soft deletes, audit columns, and lineage.

· Define Microsoft Fabric architecture across OneLake, Lakehouse, Warehouse, Pipelines, Notebooks, Dataflows Gen2, Semantic Models, Direct Lake, and Power BI.

· Ensure data solutions are scalable, secure, reusable, performant, testable, supportable, and aligned with governance and data-quality requirements.

· Translate business requirements into architecture and data designs and provide technical direction to data engineers, BI developers, analysts, and delivery teams.

· Mentor engineering teams on architecture, modelling practices, and implementation standards without becoming a delivery bottleneck.

Required Qualifications

· At least 14+ years of experience in data architecture, data warehousing, data engineering, enterprise analytics, or related disciplines.

· Extensive experience in conceptual, logical, and physical data modelling and enterprise ERD development.

· Strong expertise in relational modelling, dimensional modelling, star schema, snowflake schema, and Kimball techniques.

· Experience with modelling tools such as erwin Data Modeler, ER/Studio, Visio, Mermaid ER Diagrams, SQL Server Data Tools, or equivalent platforms.

· Demonstrated experience owning design decisions, chairing architecture reviews, approving models, and governing design standards across delivery teams.

· Hands-on experience with Microsoft Fabric, OneLake, Lakehouse, Warehouse, Semantic Models, Direct Lake, and Power BI.

· Strong knowledge of SQL, data integration, metadata, lineage, data quality, security, performance, and cloud data modernization.

· Excellent stakeholder communication, documentation, technical leadership, and mentoring skills.

Preferred Qualifications

· Microsoft Fabric or Azure data certification

· Experience with Azure Data Factory, SSIS, WhereScape RED, Microsoft Purview, Python, or PySpark.

· Experience designing enterprise semantic models and governed self-service analytics solutions.

· Experience in staffing, recruiting, HR, workforce analytics, or similar enterprise domains.