Solutions Architect Semantic Layer & Microsoft Fabric Practice

Overview:

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

Position: Solutions Architect Semantic Layer & Microsoft Fabric Practice

Location: Bellevue WA / Frisco, TX

Duration: 6 Months

Job Type: Temporary Assignment

Work Type: Hybrid

Job Description:

• 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.

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 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; }