Data Architect - Microsoft Fabric

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

Job summary

DataFactZ, Inc. is seeking a hands-on Microsoft Fabric Data Architect to lead design and delivery of enterprise data solutions. The role requires strong Fabric expertise, data warehousing, ETL/ELT, and Power BI capabilities.

You will architect, implement, and optimize Fabric-based platforms while mentoring teams and supporting pre-sales discussions. The position is onsite at our Northville, Michigan office, with collaboration across onshore and offshore delivery teams to modernize data platforms

Qualifications

• Hands-on architect role with design and implementation duties.
• Deep experience with Microsoft Fabric architecture and migrations.
• Strong data engineering, warehousing, and analytics background.
• Excellent communication with stakeholders and teams.
• Onsite presence at Northville, MI office required.

Responsibilities

• Lead design and delivery of modern enterprise data solutions using Microsoft Fabric.
• Architect environment setups, capacity planning, security and governance.
• Design solutions with OneLake, Lakehouse, Fabric Warehouse, Data Factory/Pipelines.
• Mentor engineers and participate in pre-sales discussions.
• Drove migrations of legacy data platforms to Fabric and modern analytics stacks.
• Provide architecture guidance and code reviews, and set engineering standards.

Skills

Microsoft Fabric

Data architecture

Data warehousing

ETL/ELT

SQL

Power BI

Notebooks

Spark

Data modeling

Governance

Tools

OneLake

Lakehouse

Fabric Warehouse

Data Factory/Pipelines

Notebooks

SQL

Power BI

Job description

Job Title: Microsoft Fabric Data Architect

Workplace Mode: Onsite

Job ID: DFZ-2026-106

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.

Job Summary: 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 senior technical leadership role requires someone who can architect solutions, stay hands-on during implementation, lead technical teams, participate in customer-facing pre-sales discussions, and mentor/upskill other engineers.

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.