Solution Architect – Microsoft Fabric -W2 -Northville, MI Day One Onsite

DataFactZ, Inc.

Northville (MI)

On-site

USD 120,000 - 190,000

Full time

14 hours ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

DataFactZ is seeking a Solution Architect for Microsoft Fabric to design enterprise-scale data and analytics solutions. You will work closely with clients, business stakeholders, and engineering teams to build secure, scalable data platforms using Fabric components and best practices.

You will mentor delivery teams, lead architecture reviews, and ensure delivery excellence across data ingestion, modeling, and reporting using Power BI and Delta Lake.

Qualifications

Design end-to-end Microsoft Fabric architecture.
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.
Lead client workshops, architecture reviews, solution design, and technical delivery.
Mentor technical teams and ensure adherence to architecture and coding standards.

Responsibilities

Design end-to-end Microsoft Fabric architecture.
Lead client workshops and architecture reviews.
Develop scalable data ingestion, ETL/ELT, and orchestration pipelines.
Design semantic models and Power BI reports.
Define governance and security using Purview and Entra ID.

Skills

Stakeholder Management

Solution Architecture

CI/CD & DevOps

SQL

PySpark

Python

Tools

Microsoft Fabric

Power BI

Delta Lake

Microsoft Purview

Data Factory

Lakehouse

Data Warehouse

Job description

Solution Architect – Microsoft Fabric (W2)

Hire-Type: W2

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.

About DataFactZ

DataFactZ is a data and analytics consulting company headquartered in Northville, Michigan, with delivery teams in the United States and India. For more than two decades, we've helped organizations turn their data into better decisions through data engineering, cloud data platforms on Azure, AWS, and Google Cloud, business intelligence and visualization, advanced analytics, and AI. Our consultants work on high-impact programs for fortune 500 clients, and we invest in their growth through certifications, hands-on learning, and meaningful work. Curiosity drives everything we do

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