Solutions Architect

Job Description

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

\n
• Design and own enterprise semantic models in Microsoft Fabric , including Direct Lake, composite and import models.
\n
• Architect and govern Power BI semantic models , reusable datasets, measures, and calculation frameworks.
\n
• Establish governance standards including RLS, OLS, dataset certification, sensitivity labels, lineage, and access controls .
\n
• Ensure SOX-compliant lineage, audit trails, change management, and access controls for financial reporting models.
\n
• Integrate Fabric semantic models with Tableau, Qlik Sense, MicroStrategy, Grafana, Excel , and other downstream BI platforms.
\n
• Define secure integration patterns for AI/LLM tools such as Claude and Azure OpenAI with semantic-layer data.
\n
• Lead architectural reviews, technical trade-off discussions, POCs, and solution roadmaps.
\n
• Partner with business and technical stakeholders to translate requirements into scalable data architecture.
\n
• Establish standards for DAX, model partitioning, incremental refresh, aggregation tables, deployment pipelines, Git, XMLA, and Tabular Editor .
\n
• Mentor technical teams and contribute to reusable frameworks, best practices, and architecture assets.
\n

Required Skills

\n
• Microsoft Fabric
\n
• Semantic Layer & Semantic Model Architecture
\n
• Power BI
\n
• SQL
\n
• Spark
\n
• Azure
\n
• Python
\n
• AI/ML
\n
• Enterprise Data Architecture
\n
• Data Governance & SOX Compliance
\n
• RLS / OLS and data lineage
\n
• Fabric OneLake, Lakehouse, Dataflows Gen2 & Data Pipelines
\n
• DAX, composite models, aggregation tables, incremental refresh
\n

Experience

\n
• 7–10+ years in enterprise data architecture, analytics engineering, or BI platform leadership.
\n
• 7+ years with Microsoft Fabric, Semantic Layer, Spark and SQL.
\n
• 5–7 years of Power BI semantic model development and governance.
\n
• 3–5 years of SOX compliance and financial data governance.
\n
• Experience integrating third-party BI platforms and AI/LLM technologies.
\n
• Strong solution architecture, stakeholder management, and technical leadership experience.
\n

Additional Requirements

\n
• FAANG / Product / Top-Tier 1 company experience mandatory.
\n
• 10+ years of overall experience.
\n
• Bachelor’s degree in Computer Science, IT, Computer Engineering, Data Engineering, or related field, or equivalent experience.
\n
• No specific certification required.
\n
• Must be available to work 3 days onsite in Bellevue, WA or Frisco, TX.
\n

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.