Data Solutions Architect – Semantic Layer & Microsoft Fabric

We are seeking an experienced Data Solutions Architect to lead the design and implementation of enterprise-scale semantic layer solutions using Microsoft Fabric and Power BI. This role will drive data architecture, semantic model development, governance, and SOX-compliant analytics frameworks that enable trusted, self-service reporting across Finance, Operations, Marketing, HR, and Technology teams.

The ideal candidate will possess strong expertise in Microsoft Fabric, Power BI, semantic modeling, data architecture, and enterprise governance, along with experience integrating downstream BI platforms and AI-driven analytics solutions.

Key Responsibilities

• Architect and deliver enterprise semantic models using Microsoft Fabric (Direct Lake, Composite Models, Import Mode) and Power BI.
• Define and implement data modeling standards, certified datasets, reusable measures, and semantic layer best practices.
• Establish governance frameworks including RLS, OLS, dataset certification, sensitivity labeling, and data lineage management.
• Ensure compliance with SOX controls, audit requirements, access governance, and change management processes.
• Design integrations between Microsoft Fabric and BI platforms such as Tableau, Qlik Sense, MicroStrategy, Grafana, Excel, and AI/LLM solutions.
• Collaborate with business stakeholders to translate requirements into scalable analytics architectures.
• Lead architecture reviews, performance optimization initiatives, and solution design discussions.
• Drive enterprise adoption of governed, reusable semantic models supporting self-service analytics.

Required Skills & Experience

• 7 years of experience in Data Architecture, Analytics Engineering, or BI Solutions Architecture.
• Strong hands-on expertise with Microsoft Fabric, including Lakehouses, OneLake, Dataflows Gen2, Data Pipelines, and Direct Lake semantic models.
• Extensive experience with Power BI, DAX, semantic modeling, composite models, aggregation tables, and deployment pipelines.
• Deep understanding of Data Modeling, dimensional modeling, and semantic layer architecture.
• Experience implementing SOX-compliant governance, security controls, audit trails, and data lineage.
• Strong knowledge of RLS, OLS, dataset certification, and enterprise data governance frameworks.
• Experience integrating third-party BI tools and enterprise reporting platforms with semantic models.
• Ability to engage senior stakeholders and provide architectural leadership across multiple business domains.

Preferred Qualifications

• Experience with Databricks and modern cloud-based analytics platforms.
• Exposure to AI/LLM integrations such as Anthropic Claude or Azure OpenAI.
• Knowledge of data governance tools such as Microsoft Purview, Alation, or Collibra.
• Experience leading enterprise-scale analytics transformation initiatives.

Required Experience

• Microsoft Fabric & Semantic Layer Architecture: 7 years
• Power BI, Data Modeling & SOX Compliance: 7 years
• Overall IT Experience: 10 years preferred

ABOUT BRICKRED SYSTEMS

BrickRed Systems is a global leader in next-generation technology, consulting, and business process services. The company helps organizations accelerate digital transformation through innovative, scalable, and high-impact solutions across industries worldwide.

With ISO 27001 and ISO 9001 certifications and over a decade of experience, BrickRed Systems leverages cloud computing, analytics, hyper-automation, robotics, cognitive computing, and emerging technologies to deliver measurable business outcomes.

The organization fosters a strong continuous learning culture, enabling clients and talent to build future-ready digital capabilities and maintain a competitive edge in a rapidly evolving global marketplace.