MS Fabric Data Architect
Chicago, IL or Remote
Long Term
Provide enterprise data architecture leadership to accelerate strategic initiatives, integrations, modernization programs, and innovation projects by designing scalable data structures, integration patterns, and reusable architectural standards.
Key Responsibilities - Using Microsoft Fabric
• Design enterprise data architectures, canonical data models, and target-state information architectures
• Develop source-to-target mappings, data lineage, and end-to-end data flow designs
• Create conceptual, logical, and physical data models supporting business and technology initiatives
• Define integration architectures and data consumption patterns for cloud and enterprise applications
• Establish reusable architectural patterns, golden paths, standards, and best practices
• Provide architecture guidance for data modernization and data fabric initiatives
• Collaborate with business, application, integration, and engineering teams to resolve architecture challenges
• Conduct architecture reviews and ensure alignment with enterprise standards
• Support troubleshooting, performance optimization, and technical governance activities across in-flight projects
Experience
• 10+ years of experience in Enterprise Data Architecture, Data Engineering, or Solution Architecture roles
• Deep expertise in data modeling, data architecture, and enterprise information management
• Strong experience with source-to-target mapping and enterprise integration design
• Experience designing data pipelines, data flows, and large-scale data movement architectures
• Working knowledge of Microsoft Fabric and implementation of large setup on it
• Hands-on experience with SQL development, optimization, and performance tuning
• Experience supporting enterprise modernization, migration, and transformation initiatives
• Demonstrated ability to support multiple concurrent projects, pilots, and innovation programs
• Strong stakeholder engagement and communication skills across business and technical teams
• Experience defining reusable architecture standards, governance frameworks, and enterprise design patterns