Fabric Solution Architect

Location:

Saint Louis, United States (Posted on 07/01/2026)

A Fabric Solution Architect designs, implements, and governs end-to-end data and analytics solutions using Microsoft Fabric
. This role bridges business requirements with technical architecture, ensuring scalable, secure, and high-performing data platforms leveraging Fabric components such as Lakehouse, Data Warehouse, Data Engineering, Data Science, Real‑Time Intelligence, and Power BI
.

• Define end-to-end data architecture using Microsoft Fabric
• Design Lakehouse architectures (Delta Lake, Medallion layers: Bronze, Silver, Gold)
• Architect data integration, ingestion, transformation, and serving layers
• Define architecture patterns for batch, streaming, and real‑time data processing

• Lead implementation of:
  • Fabric Work spaces & governance model
  • Data Pipelines & Dataflows Gen2
  • Notebooks (Spark‑based engineering workloads)
  • Data Warehouse & Lakehouse solutions
• Configure and optimize One Lake data management

• Establish best practices for data modeling (star schema, dimensional modeling)
• Enable self‑service BI and governed analytics

• Integrate Fabric with:
  • Azure services (ADLS, Synapse, Azure SQL, Event Hub, etc.)
  • External data sources (ERP, CRM, APIs)
• Design hybrid/multi‑cloud data integration where required

• Implement data governance, lineage, and cataloging
• Define role‑based access control (RBAC) and data security strategies
• Ensure compliance with enterprise data policies

• Query performance
• Cost efficiency (capacity planning)
• Data storage strategies
• Monitor and troubleshoot Fabric environments
• Work closely with:
  • Business stakeholders
  • Data engineers, analysts, and scientists
  • IT and cloud teams
• Provide technical leadership and mentorship
• Drive design reviews and architecture governance

• Strong experience with Microsoft Fabric / Synapse / Azure Data Platform
• Data Lakehouse architecture
• Spark / Py Spark
• SQL & Data Warehousing (MPP systems)
• Experience with:
  • Data Pipelines / ETL/ELT frameworks
  • Power BI (advanced modeling, DAX)

• Knowledge of:
  • Data ingestion tools (ADF, Fabric pipelines)
  • Streaming technologies (Kafka/Event Hub)
  • Delta Lake & parquet formats

• Data governance frameworks (Purview preferred)
• Scalable and cost‑optimized solution design
• Strong stakeholder communication
• Solution‑oriented thinking
• Leadership and mentoring capability

• Microsoft Certifications (highly desirable):
  • DP‑600:
    Fabric Analytics Engineer
  • DP‑203:
    Data Engineering on Azure
  • PL‑300:
    Power BI Data Analyst
• Experience with AI/ML integration within Fabric
• Familiarity with Dev Ops (CI/CD for data platforms)