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.