Solutions Architect

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.

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, MicroStrategy, 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 BI
• SQL
• Spark
• Azure
• Python
• AI/ML
• Enterprise Data Architecture
• Data Governance & SOX Compliance
• RLS / OLS and data lineage
• Fabric OneLake, Lakehouse, Dataflows Gen2 & Data Pipelines
• DAX, 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 SYSTEMS

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. BrickRed fosters a culture of continuous learning, collaboration, and excellence, enabling professionals to contribute to high-impact global initiatives while advancing their careers.