Solutions Architect Semantic Layer & Microsoft Fabric Practice

This role develops and owns end-to-end solution design strategies for the enterprise Semantic Layer program, built on Microsoft Fabric and Power BI. The Solutions Architect leads semantic model design across business workstreams ensuring models are governed, certified, and compliant with SOX and enterprise data standards. The role bridges technical implementation (Microsoft Fabric, Power BI, third-party BI platforms, and Anthropic/AI tooling) with stakeholder alignment across Finance, Operations, Marketing, and Technology. Success is measured by the delivery of certified, trusted semantic models that enable self-service analytics across the organization. The work directly enables data-driven decision-making by establishing a governed, reusable, and interoperable semantic layer. Main Responsibilities: Responsibility % of Time Semantic Model Architecture & Workstream Enablement Design, build, and own semantic models in Microsoft Fabric (Direct Lake, composite models, and import mode) for each business workstream including Finance, Operations, Marketing, HR, and Technology. Establish workstream-specific model standards, certified dataset patterns, and reusable measure libraries. 30% Governance, Certification & SOX Compliance Define and enforce semantic layer governance frameworks including dataset certification workflows, row-level security (RLS), object-level security (OLS), and sensitivity label policies. Partner with Audit and Finance to ensure SOX-compliant lineage, access controls, and change management processes for financial reporting models. 25% Tool Integration: BI Platforms, Anthropic & Downstream Consumers Architect interoperability between Microsoft Fabric semantic models and downstream consumption tools including third-party BI platforms (Tableau, Qlik Sense, MicroStrategy, Grafana, and others), Anthropic-based AI/LLM applications (Claude), and Excel. Define connectivity patterns, query optimization strategies, and security passthrough standards for each integration channel. 20% Stakeholder Alignment & Technical Advisory Engage workstream leads, data owners, and senior management to translate business requirements into semantic model designs. Lead architectural trade-off discussions and present options for data modeling approaches (star schema, composite models, aggregation tables). Serve as the primary point of escalation for semantic layer design decisions. 15% Other Duties Other duties/projects as assigned by business management., TekWissen Group is an equal opportunity employer supporting workforce diversity. a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }, Role: Agentic AI Solution Architect Mode : Remote Core Skills Orchestration architecture and framework selection (Microsoft Agent Framework, LangGraph); MCP-based integration…

• 22 days ago, Job Title: AI & Automation Solution Architect Location: Plano, TX (On Site) Role Overview Lead the design and delivery of AI and automation solutions that solve business chall…
• 20 hours ago
• Apply easily +

Experience Required Preferred: Bachelor’s Degree 7+ years related experience, or equivalent combination. Acceptable fields: Computer Science, IT, Computer Engineering, Data Engineering, or related. Required & Preferred Experience Years Experience Required Preferred 7-10 yrs Progressive experience in enterprise data architecture, analytics engineering, or BI platform leadership. 7-10 yrs Hands-on experience with Microsoft Fabric including Lakehouses, Direct Lake semantic models, Dataflows Gen2, Data Pipelines, and the Fabric OneLake architecture. Mandatory Areas: Data Solution Architecture, Semantic Layer & Microsoft Fabric: Must have Skills MS Fabric, Semantic Layer, PowerBI, Semantic Model Architecture Skill 1 7Yrs of Exp MS Fabric, Semantic Layer, Spark, SQL Skill 2 7Yrs of Exp SQL Skill 3 5Yrs of Exp in IT Python, Azure, AI/ML

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services, Baker Tilly

• Frisco, TX Overview Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U.S. and in many …