Microsoft Fabric Data Architect

DataFactZ, Inc.; Northville (MI); On-site; USD 140,000 - 210,000; Full time

Job summary

DataFactZ, Inc. seeks a hands-on Microsoft Fabric Data Architect to lead the design and delivery of enterprise data and analytics solutions from its Northville, Michigan office.

You will architect Fabric platforms, drive migrations, and mentor engineers while staying active in implementation and pre-sales discussions. You will collaborate with stakeholders and delivery teams to optimize data models, governance, and performance, leveraging Power BI and Azure data services to unlock enterprise

Qualifications

• Strong hands-on experience with Microsoft Fabric architecture, optimization, and migration.
• Expertise in data architecture, data warehousing, and modern analytics platforms.
• Power BI governance, security, and enterprise reporting.
• Ability to lead technical teams, participate in pre-sales discussions, and mentor engineers.

Responsibilities

• Design and implement Fabric-based data platforms for enterprise-scale solutions.
• Lead legacy data platform migrations to Microsoft Fabric.
• Provide architecture guidance, code reviews, and engineering standards.
• Partner with pre-sales to define solutions and estimate efforts, mentor junior team members.

Skills

Microsoft Fabric

Power BI

SQL

Data Architecture

ETL/ELT

Leadership

Pre-sales

Mentoring

Tools

Azure Data Factory

Azure Synapse

Notebooks

Spark

Azure Data Services

Job description

We are looking for a hands-on Microsoft Fabric Data Architect to lead the design and delivery of modern enterprise data and analytics solutions. The ideal candidate will have strong experience with Microsoft Fabric architecture, implementation, optimization, and migration, along with a solid background in data engineering, data warehousing, analytics, and Power BI. This is a senior technical leadership role requiring someone who can architect solutions, remain hands-on during implementation, lead technical teams, participate in customer-facing pre-sales discussions, and mentor/upskill other engineers

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

Key Responsibilities & Skills

• Strong hands-on experience with Microsoft Fabric, including environment/tenant setup, architecture, capacity planning, security, governance, performance optimization, and best practices.
• Design and implement solutions using OneLake, Lakehouse, Fabric Warehouse, Data Factory/Pipelines, Notebooks, Spark, SQL, and Power BI.
• Lead legacy data platform migrations to Microsoft Fabric, including assessment, architecture, migration strategy, data transformation, validation, performance tuning, and modernization.
• Strong expertise in data architecture, dimensional/data modeling, data warehousing, ETL/ELT, SQL, data engineering, medallion architecture, and modern analytics platforms.
• Strong Power BI experience, including semantic models, Direct Lake, performance optimization, governance, security/RLS, and enterprise reporting.
• Serve as a technical lead, providing architecture guidance, conducting design/code reviews, establishing engineering standards, and leading onshore/offshore delivery teams.
• Participate in pre-sales and customer discussions—understand requirements, define solution architecture, conduct technical presentations/demos, estimate implementation efforts, and showcase Microsoft Fabric capabilities.
• Mentor and upskill junior and mid-level engineers on Fabric, data engineering, architecture patterns, and development best practices.
• Excellent communication skills with the ability to work directly with business stakeholders, technical teams, and senior customer leadership.

Nice to Have: Previous experience with Informatica or similar enterprise ETL platforms, particularly migration/modernization projects. Experience with Azure Synapse Analytics, Azure Data Factory, SSIS, SSRS, ADLS, Databricks, and other Azure data services is a strong plus.

Must Have: This is a hands-on architect role , not a purely advisory/management position. The candidate must be comfortable designing the architecture as well as working directly with SQL, notebooks, pipelines, data models, Fabric workloads, and troubleshooting implementation issues. Onsite presence at our Northville, Michigan office is required.