Data Solution Architect

Please review the below JD:

About the Role

Role: Data Solution Architect

Location : Frisco, TX & Atlanta, GA

• 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

Job Summary

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

Responsibilities

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

Qualifications

• 7 years related experience, or equivalent combination.
• Acceptable fields: Computer Science, IT, Computer Engineering, Data Engineering, or related.

Required Skills

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

Preferred Skills

• 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 planning.
• Define standards for model partitioning, incremental refresh, and aggregation table patterns to meet performance SLAs across diverse workstreams.
• Own deployment pipeline strategy across Dev / Test / Prod Fabric workspaces, including Git integration, XMLA scripting, and Tabular Editor automation.
• Establish DAX coding standards, measure naming conventions, and reusable calculation groups shared across workstream models.