Job Title: Sr Microsoft Fabric Data Engineer
Location: Dallas TX (Remote)
Duration: 6+ months
ROLE SUMMARY
Design and build enterprise-scale Microsoft Fabric data platforms with a strong focus on metadata-driven ingestion and orchestration frameworks. Lead the development of reusable, configuration-driven data integration solutions capable of dynamically executing Microsoft Fabric resources including Data Pipelines, Notebooks, Dataflows Gen2, Lakehouses, Warehouses, and Semantic Models. Establish and govern Fabric Medallion Architecture (Bronze/Silver/Gold), implement scalable framework standards, and support migration of enterprise Tableau dashboards from on-prem SQL Server (Epic Clarity ~90%) to governed Microsoft Fabric data products.
Responsibilities:
· 12+ years of Data Engineering and Data Warehousing experience, including lead-level ownership of enterprise data platform architecture.
· 3+ years of hands-on Microsoft Fabric experience (Lakehouse, Warehouse, Data Factory, Spark Notebooks, Dataflows Gen2, Direct Lake, Semantic Models) or equivalent Azure Synapse/ADF experience with recent Fabric delivery.
· Extensive experience building metadata-driven ingestion and orchestration frameworks for enterprise data platforms.
· Strong experience developing dynamic, configuration-driven ETL/ELT frameworks capable of orchestrating Fabric workloads at scale.
· Proven experience implementing dependency-based job orchestration, execution control frameworks, and operational monitoring solutions.
· Expert T-SQL skills with proven Fabric Warehouse (or Azure SQL DW / Dedicated SQL Pool) delivery of enterprise dimensional Gold models.
· Strong Spark/PySpark expertise for Lakehouse Bronze/Silver transformations and proven Medallion Architecture implementation experience.
· Strong Python development experience for framework automation, metadata processing, orchestration, and platform engineering.
· Strong dimensional modeling (Kimball) expertise for Warehouse-based fact and dimension design.
· Hands-on experience with Microsoft Purview, lineage management, sensitivity labels, and row-level/object-level security implementation.
· Experience implementing CI/CD for data platforms using Azure DevOps, Git-based deployment, and Fabric deployment pipelines.
· Proven track record migrating or modernizing large BI and data warehouse ecosystems onto modern cloud platforms.
· Experience with Agentic AI, MCP-driven automation, and intelligent orchestration concepts.
Key skills:
Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Notebooks/Spark, Dataflows Gen2, Direct Lake, Semantic Models)
• OneLake
• Fabric Data Factory
• Metadata-Driven Frameworks
• Dynamic Orchestration Frameworks
• T-SQL
• PySpark
• Python
• Delta Lake
• Azure DevOps
• Git Integration / Deployment Pipelines
• Power BI / Tableau
• SQL Server / Epic Clarity