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

📌 Senior Data Architect (Chennai)
🏢 GreatHR Solutions
📍 Chennai