MS Fabric Data Architect

Req ID: 112462-1
Title: MS Fabric Data Architect
Locations: Chicago, IL / REMOTE
Duration: 06+ Months
Pay Range: $65-$70/Hour on W2 (All inclusive)

We are seeking a highly skilled MS Fabric Data Architect with strong expertise in Client Fabric, Azure Data Platform, Data Architecture, Data Engineering, and Advanced Analytics. The ideal candidate will be responsible for designing and implementing modern data architecture solutions, supporting enterprise data modernization initiatives, leading data integration projects, and driving Client Fabric adoption across the organization.

This role will support ongoing projects, Proof of Concepts (POCs), innovation initiatives, data modernization programs, and enterprise data architecture requirements.

Key Responsibilities

• Design and develop enterprise-scale Data Architecture solutions using modern cloud-based platforms.
• Perform data discovery, business domain analysis, and data modeling activities including conceptual, logical, and physical data models.
• Create and maintain source-to-target mapping documentation for data integration initiatives.
• Design and implement scalable ETL/ELT architectures for structured and unstructured data.
• Architect and optimize Client Fabric solutions including OneLake, Lakehouse, Warehouse, Data Factory, and Data Engineering workloads.
• Build and maintain data pipelines, data flows, and integration solutions using Client Fabric and Azure Data Factory.
• Develop and optimize SQL queries, views, stored procedures, and data transformation processes.
• Support enterprise data modernization efforts through cloud migration and lakehouse implementations.
• Implement data governance, security, metadata management, lineage, and data quality frameworks.
• Design API-based and event-driven integration architectures.
• Troubleshoot and resolve performance issues across Fabric environments and data pipelines.
• Collaborate with business stakeholders, solution architects, and development teams to define data requirements and architecture standards.
• Enable reporting and analytics capabilities through seamless integration with Power BI.
• Provide architectural guidance, best practices, and technical leadership to project teams.

Required Skills & Qualifications

Data Architecture & Modeling

• Strong experience in Conceptual, Logical, and Physical Data Modeling.
• Expertise in Data Domain Modeling and Enterprise Data Architecture.
• Experience with Data Discovery and Data Mapping exercises.
• Strong understanding of Source-to-Target Mapping methodologies.

Data Integration & Engineering

• Extensive experience designing ETL/ELT solutions.
• Expertise in Data Pipeline and Data Flow architecture.
• Experience with API integrations and Event-Driven Architectures.
• Knowledge of Data Quality, Metadata Management, and Data Lineage.

Client Fabric & Azure Data Platform

• Hands-on experience with:
  • Client Fabric
  • OneLake
  • Fabric Lakehouse
  • Fabric Warehouse
  • Fabric Data Factory
  • Fabric Data Engineering
• Strong knowledge of Fabric Architecture, Implementation, and Troubleshooting.
• Experience with Fabric Performance Optimization, Security, Governance, and Monitoring.
• Expertise in Azure Data Factory (ADF).