Architect II - Enterprise Solutions

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Job Type: Temporary Assignment 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. 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.5-7 yrs Power BI semantic model development: DAX authoring, composite models, aggregation tables, incremental refresh, and deployment pipelines.5-7 yrs Governance experience: dataset certification, workspace governance, RLS/OLS implementation, sensitivity labels, and data catalog/governance tooling integration (e.g., Microsoft Purview, Alation, Collibra, or equivalent).3-5 yrs SOX compliance for financial data systems including audit trail design, change management controls, access reviews, and lineage documentation.3-5 yrs Experience connecting third-party BI and analytics tools (e.g., Tableau, Qlik Sense, MicroStrategy, Grafana) to XMLA-compatible semantic models including live connection architecture, security passthrough, and performance tuning.2-4 yrs Experience integrating AI/LLM tools (e.g., Anthropic Claude, Azure OpenAI) with structured data sources or semantic layer APIs for natural language querying or embedded analytics.5-7 yrs Experience leading solution architecture and design reviews across multiple business workstreams with demonstrated executive presence.X Key Focus Areas Microsoft Fabric & Semantic Model Platform Architect and govern the enterprise semantic layer in Microsoft Fabric, including Direct Lake models on OneLake, composite model strategies, and Power BI Premium/Fabric capacity planningDefine standards for model partitioning, incremental refresh, and aggregation table patterns to meet performance SLAs across diverse workstreamsOwn deployment pipeline strategy across Dev / Test / Prod Fabric workspaces, including Git integration, XMLA scripting, and Tabular Editor automationEstablish DAX coding standards, measure naming conventions, and reusable calculation groups shared across workstream modelsWorkstream Semantic Model Delivery Partner with Finance, Operations, Marketing, HR, and Technology workstream leads to gather requirements and deliver purpose-built certified semantic modelsDocument business glossary mappings, metric definitions, and lineage for each workstream model to support self-service analytics and reduce shadowIT Facilitate model reviews and sign-off with data owners, ensuring models meet certification criteria before promotion to production Governance, Certification & SOX ComplianceDefine the end-to-end dataset certification process: quality gates, ownership assignment, certification badges, and renewal cadence Implement row-level security (RLS) and object-level security (OLS) patterns aligned to organizational access control policies and RBAC structuresDesign SOX-compliant data lineage and change management controls for financial semantic models including audit trails, access reviews, and separation of dutiesIntegrate with enterprise data catalog and governance tooling (evaluation in progress candidates may include Microsoft Purview, Alation, Collibra, or equivalent) for data lineage, sensitivity labeling, and compliance monitoring across Fabric workspaces Tool Integration: BI Platforms, Anthropic & Other Consumers Architect connectivity between Fabric semantic models and third-party BI and analytics tools (including Tableau, Qlik Sense, MicroStrategy, Grafana, and others) via XMLA endpoints, OData, or direct query APIs optimizing live connection performance, pass-through security, and certified dataset reuse across consumption platformsDefine integration patterns for Anthropic Claude and other LLM-based tools to query semantic layer data safely, including prompt-to-DAX patterns, scoped data access, and output validationSupport Excel, Power BI Desktop, and other BI tools in consuming shared certified models, and document connectivity guides for each consumer type Advise on emerging AI-augmented analytics use cases that leverage the semantic layer as a governed data foundation for natural language interfaces TekWissen is an emerging global human capital, recruitment and IT services organization.

Create an account to see the full posting, access our search engine, and more.