Job Role: Microsoft Solution Architect – Microsoft Fabric
Location: Northville, MI / Remote (Travel to St Louis, MO)
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
Never miss an opportunity! Create an alert based on the job you applied for.
