What are the responsibilities and job description for the Data Solutions Architect - Microsoft Fabric & Semantic Layer position at Spiceorb?
Data Solutions Architect - Microsoft Fabric & Semantic Layer
Location: Frisco, TX, / Overland Park, KS and Atlanta, GA - Onsite
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
• 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