Microsoft Fabric Solution Architect

Job Role: Microsoft Fabric Solution Architect

Location: Northville, MI

Hire-Type: Long-term

Job Summary

Design and deliver enterprise-scale data and analytics solutions using Microsoft Fabric, working closely with clients, business stakeholders, and engineering teams to build secure, scalable, and high-performance data platforms.

Key Roles & Responsibilities

• Design end-to-end Microsoft Fabric architecture.
• Build solutions using OneLake, Lakehouse, Data Warehouse, Data Factory, Real-Time Intelligence, and Power BI.
• Implement Medallion Architecture (Bronze, Silver, Gold) and Delta Lake best practices.
• Develop scalable data ingestion, ETL/ELT, and orchestration pipelines using Fabric Data Factory and Spark.
• Design semantic models, Direct Lake, dashboards, and reports in Power BI.
• Define data governance, security, and lineage using Microsoft Purview and Microsoft Entra ID.
• Optimize Fabric capacity, Spark workloads, Warehouse performance, and Power BI reports.
• Implement CI/CD using Git integration and Fabric Deployment Pipelines.
• Lead client workshops, architecture reviews, solution design, and technical delivery.
• Mentor technical teams and ensure adherence to architecture and coding standards.

Core Microsoft Fabric Components

• OneLake
• Data Factory
• Lakehouse
• Data Warehouse
• Data Engineering (Spark, PySpark)
• Real-Time Intelligence (Eventstream, Eventhouse, KQL)
• Power BI (Semantic Models, Direct Lake, DAX)
• Data Science & AI
• Microsoft Purview
• Fabric Deployment Pipelines & Git Integration

Key Skills

• Microsoft Fabric
• Azure Data Platform
• SQL, PySpark, Python
• Power BI & DAX
• Delta Lake & Medallion Architecture
• Data Modeling
• Microsoft Purview
• CI/CD & DevOps
• Stakeholder Management and Solution Architecture