Data Semantic Architect Microsoft Fabric & Power BI

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

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)