Data Solution Architect

Sophus IT Solutions; Frisco (TX); On-site; USD 130,000 - 180,000; Full time

Job summary

Sophus IT Solutions seeks a Data Solutions Architect to own end-to-end semantic layer design on Microsoft Fabric and Power BI, spanning Finance, Operations, Marketing, HR, and Technology. You will govern semantic models, certify datasets, and ensure SOX compliance while partnering with Audit to enable trusted self-service analytics enterprise-wide.

Responsibilities include designing Fabric semantic models, defining standards, and integrating BI tools (Tableau, Qlik Sense, MicroStrategy, Grafana)

Qualifications

• 7+ years related experience in enterprise data architecture, analytics engineering, or BI platform leadership.
• Fields acceptable: Computer Science, IT, Computer Engineering, Data Engineering, or related.

Responsibilities

• Design, build, and own semantic models in Microsoft Fabric for each business workstream (Finance, Operations, Marketing, HR, Technology).
• Establish model standards, certified dataset patterns, and reusable measure libraries; enforce governance and SOX compliance.
• Architect interoperability between Fabric semantic models and downstream tools (Tableau, Qlik Sense, MicroStrategy, Grafana, Excel).
• Lead stakeholder alignment, translate business requirements into semantic designs, and present options for data modeling approaches.

Skills

Databricks

Microsoft Fabric

Semantic Layer

Power BI

Data Modeling

SOX Compliance

Tools

Tableau

Qlik Sense

MicroStrategy

Grafana

Anthropic Claude

Azure OpenAI

Job description

• 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

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