Solutions Architect

Key Responsibilities: 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. Lead architectural reviews, technical trade-off discussions, POCs, and solution roadmaps. 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.

Required Skills: Microsoft Fabric Semantic Layer & Semantic Model Architecture Power BISQLSpark Azure PythonAI/MLEnterprise Data Architecture Data Governance & SOX ComplianceRLS / OLS and data lineage Fabric One Lake, Lakehouse, Dataflows Gen 2 & Data PipelinesDAX, composite models, aggregation tables, incremental refresh Experience 7–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. Strong solution architecture, stakeholder management, and technical leadership experience.

Additional Requirements: FAANG / Product / Top-Tier 1 company experience mandatory.10+ years of overall experience. Bachelor’s degree in Computer Science, IT, Computer Engineering, Data Engineering, or related field, or equivalent experience. No specific certification required. Must be available to work 3 days onsite in Bellevue, WA or Frisco, TX.ABOUT BRICKRED SYSTEMSBrick Red 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, Brick Red Systems helps organizations solve complex business challenges by providing skilled professionals across strategy, technology, creative, and operational functions. Brick Red fosters a culture of continuous learning, collaboration, and excellence, enabling professionals to contribute to high-impact global initiatives while advancing their careers.