Data Solutions Architect - Microsoft Fabric & Semantic Layer

Data Solutions Architect - Microsoft Fabric & Semantic Layer

Location: Frisco, TX, / Overland Park, KS and Atlanta, GA - Onsite Locals Only

Mandatory Areas : Solution Architecture, MS Fabric, Power BI, Data Architecture, Data Modeling, Semantic model development, Microsoft Fabric, Sox compliance

Must have Skills - Data Solutions Architect with Semantic Layer & Microsoft Fabric

Skill 1 - 7Yrs of Exp - Databricks, MS Fabric, Semantic Layer

Skill 2 - 7Yrs of Exp - PowerBI, Data Modeling, Sox Compliance

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.

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