We are looking for an experienced Solutions Architect to lead the design and architecture of an enterprise Semantic Layer and Microsoft Fabric platform. This role will own end-to-end solution strategies, develop governed semantic models, and enable trusted self-service analytics across Finance, Operations, Marketing, HR, and Technology. Design and own enterprise semantic models in Microsoft Fabric, including Direct Lake, composite and import models. Architect and govern Power BI semantic models, reusable datasets, measures, and calculation frameworks. Establish governance standards including RLS, OLS, dataset certification, sensitivity labels, lineage, and access controls .Ensure SOX-compliant lineage, audit trails, change management, and access controls for financial reporting models. Integrate Fabric semantic models with Tableau, Qlik Sense, Micro Strategy, Grafana, Excel, and other downstream BI platforms. Define secure integration patterns for AI/LLM tools such as Claude and Azure OpenAI with semantic-layer data. Partner with business and technical stakeholders to translate requirements into scalable data architecture. Establish standards for DAX, model partitioning, incremental refresh, aggregation tables, deployment pipelines, Git, XMLA, and Tabular Editor .Mentor technical teams and contribute to reusable frameworks, best practices, and architecture assets. Microsoft FabricPower BISQLPythonAI/MLEnterprise Data Architecture Data Governance & SOX ComplianceRLS / OLS and data lineage Fabric OneLake, Lakehouse, Dataflows Gen2 & Data PipelinesDAX, composite models, aggregation tables, incremental refresh7–10+ years in enterprise data architecture, analytics engineering, or BI platform leadership.~7+ years with Microsoft Fabric, Semantic Layer, Spark and SQL.~5–7 years of Power BI semantic model development and governance.~3–5 years of SOX compliance and financial data governance.~ Experience integrating third-party BI platforms and AI/LLM technologies.~ Bachelor's degree in Computer Science, IT, Computer Engineering, Data Engineering, or related field, or equivalent experience.~ BrickRed Systems is a global leader in next-generation technology consulting and workforce solutions, specializing in delivering high-quality talent across digital, engineering, marketing, analytics, finance, operations, and business transformation domains. With a strong emphasis on innovation, scalability, and client success, BrickRed Systems helps organizations solve complex business challenges by providing skilled professionals across strategy, technology, creative, and operational functions.