Fabric Solution Architect

Fabric Solution ArchitectJob Title: Fabric Solution ArchitectRole Summary: A Fabric Solution Architect designs, implements, and governs end-to-end data and analytics solutions using Microsoft Fabric. This role bridges business requirements with technical architecture, ensuring scalable, secure, and high-performing data platforms leveraging Fabric components such as Lakehouse, Data Warehouse, Data Engineering, Data Science, Real-Time Intelligence, and Power BI.Key Responsibilities:Solution Architecture & DesignDefine end-to-end data architecture using Microsoft FabricDesign Lakehouse architectures (Delta Lake, Medallion layers: Bronze, Silver, Gold)Architect data integration, ingestion, transformation, and serving layersDefine architecture patterns for batch, streaming, and real-time data processingPlatform ImplementationLead implementation of: Fabric Workspaces & governance modelData Pipelines & Dataflows Gen2 Notebooks (Spark-based engineering workloads)Data Warehouse & Lakehouse solutionsConfigure and optimize OneLake data managementData Modeling & AnalyticsDesign enterprise-grade semantic models (Power BI datasets)Establish best practices for data modeling (star schema, dimensional modeling)Enable self-service BI and governed analyticsIntegration & EcosystemIntegrate Fabric with: Azure services (ADLS, Synapse, Azure SQL, Event Hub, etc.)External data sources (ERP, CRM, APIs)Design hybrid/multi-cloud data integration where requiredSecurity & GovernanceImplement data governance, lineage, and catalogingDefine role-based access control (RBAC) and data security strategiesEnsure compliance with enterprise data policiesPerformance OptimizationOptimize workloads for: Query performanceCost efficiency (capacity planning)Data storage strategiesMonitor and troubleshoot Fabric environmentsLeadership & CollaborationWork closely with: Business stakeholdersData engineers, analysts, and scientistsIT and cloud teamsProvide technical leadership and mentorshipDrive design reviews and architecture governanceRequired Skills & Experience:Core Technical Skills:Strong experience with Microsoft Fabric / Synapse / Azure Data PlatformExpertise in: Data Lakehouse architecture Spark / PySpark SQL & Data Warehousing (MPP systems)Experience with: Data Pipelines / ETL/ELT frameworks Power BI (advanced modeling, DAX)Cloud & Data Expertise:Hands-on experience in Azure ecosystemKnowledge of: Data ingestion tools (ADF, Fabric pipelines) Streaming technologies (Kafka/Event Hub) Delta Lake & parquet formatsArchitecture Skills:Enterprise data architecture design Data governance frameworks (Purview preferred) Scalable and cost-optimized solution designSoft Skills:Strong stakeholder communication Solution-oriented thinking Leadership and mentoring capabilityPreferred Qualifications:Microsoft Certifications (highly desirable): DP-600: Fabric Analytics Engineer DP-203: Data Engineering on Azure PL-300: Power BI Data Analyst Experience with AI/ML integration within Fabric Familiarity with DevOps (CI/CD for data platforms)