Senior Microsoft Fabric Data Engineer

Risamsoft Inc

Dallas (TX)

Remote

USD 130,000 - 170,000

Full time

4 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Risamsoft Inc. is seeking a Sr Microsoft Fabric Data Engineer in the Dallas area with remote work option.

You will design and build enterprise-scale Fabric data platforms, focusing on metadata-driven ingestion and orchestration frameworks that cover Data Pipelines, Notebooks, Dataflows Gen2, Lakehouses, Warehouses, and Semantic Models. You will govern Fabric medallion architecture and support Tableau migrations to Fabric datasets.

Qualifications

  • 12+ years in data engineering/warehousing.
  • 3+ years hands-on Fabric experience.
  • Metadata-driven ingestion/orchestration experience.
  • Strong T-SQL and Spark/PySpark skills.

Responsibilities

  • Design and implement metadata-driven ingestion frameworks in Microsoft Fabric.
  • Build dynamic orchestration frameworks to execute Fabric resources.
  • Develop reusable Fabric Data Factory pipelines for scalable ingestion and transformation.
  • Implement full loads, incremental loads, CDC processing, restartability, error handling, and automatic recovery.
  • Design and maintain execution control tables, metadata repositories, and dependency frameworks.
  • Stand up the Fabric Medallion Architecture with Bronze/Silver in Lakehouse and Gold in Warehouse.
  • Build Bronze/Silver layers in Lakehouse and Gold layer in Fabric Warehouse using Fabric tools.
  • Translate Tableau embedded SQL into reusable Silver and Gold data products.
  • Act as human-in-the-loop reviewer for automated recommendations and governance.

Skills

Data engineering
Metadata-driven ingestion
ETL/ELT frameworks
Python development
Spark/PySpark
T-SQL
Azure Fabric
Data governance
CI/CD
Tableau integration

Tools

Microsoft Fabric
Azure Data Factory
Purview
Git/GitHub
Tableau

Job description

Job Title: Sr Microsoft Fabric Data Engineer

Location: Dallas TX (Can be Remote)

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.

KEY RESPONSIBILITIES
  • Design and implement metadata-driven ingestion frameworks in Microsoft Fabric to onboard and manage multiple source systems through centralized configurations.
  • Build dynamic orchestration frameworks capable of executing Fabric resources including Data Pipelines, Spark Notebooks, Dataflows Gen2, Lakehouses, Warehouses, and Semantic Models based on metadata and business rules.
  • Develop reusable and parameter-driven Fabric Data Factory pipelines to support scalable ingestion, transformation, dependency management, auditing, and monitoring.
  • Implement framework capabilities for full loads, incremental loads, CDC processing, restartability, error handling, and automated recovery mechanisms.
  • Design and maintain execution control tables, metadata repositories, and dependency frameworks to support enterprise-scale orchestration and workload management.
  • Stand up the Fabric Medallion Architecture using a hybrid model: Bronze and Silver in the Lakehouse (Delta), Gold in the Fabric Warehouse (T-SQL).
  • Build Bronze and Silver layers in the Lakehouse using Spark/PySpark Notebooks and Data Factory Pipelines (source-aligned Bronze; standardized, reusable Silver).
  • Build the Gold layer in the Fabric Warehouse as enterprise dimensional models (facts, dimensions, aggregations, KPIs) using T-SQL, loading from Silver via Data Factory pipelines, Spark Notebooks, or Dataflow Gen2.
  • Translate parsed Tableau embedded/custom SQL into reusable Silver business logic and Gold fact/dimension data products.
  • Build Gold dimensional models and Fabric Semantic Models / Direct Lake datasets that replace embedded SQL and serve as enterprise Tableau published data sources.
  • Act as the human-in-the-loop reviewer on automated Bronze/Silver/Gold recommendations by evaluating reusable business concepts, existing Fabric assets, and fact vs dimension vs report-specific mart classifications.
  • Implement governance and security including Microsoft Purview cataloging, lineage tracking, sensitivity labels, RLS/OLS, and PHI/HIPAA compliance controls.
  • Establish and enforce enterprise standards for metadata management, orchestration, naming conventions, medallion architecture, and governance processes.
  • Implement CI/CD using Azure DevOps, Fabric Git Integration, and Deployment Pipelines.
  • Lead data reconciliation and validation activities against source systems, partnering with business owners on automated comparisons and sign-off processes.
  • Collaborate with Tableau teams to repoint existing dashboards and published data sources to Fabric-based Lakehouse, Warehouse, and Semantic Model assets.
REQUIRED QUALIFICATIONS
  • 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.
  • 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.
TECH STACK
  • Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Notebooks/Spark, Dataflows Gen2, Direct Lake, Semantic Models)
  • SQL Server / Epic Clarity
PREFERRED QUALIFICATIONS
  • Microsoft Certified: Fabric Data Engineer Associate (DP-700), Fabric Analytics Engineer Associate, and/or Azure Data Engineer Associate (DP-203).
  • Demonstrated experience designing enterprise metadata-driven ingestion and orchestration frameworks in Microsoft Fabric.
  • Experience building centralized execution engines, dependency‑management frameworks, and operational monitoring solutions for Fabric workloads.
  • Epic Clarity / Caboodle experience.
  • Experience integrating Fabric Warehouse (SQL Endpoint, XMLA Endpoint, Direct Lake) as published data sources for Tableau consumption.
  • Familiarity with SQL parsing, normalization, and automation techniques using SQLGlot and Python.
  • Experience leveraging AI‑assisted development, Agentic AI, MCP Servers, and automation frameworks for accelerating Fabric platform delivery and operations.
  • Experience supporting large‑scale healthcare, HIPAA, or regulated data environments.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Microsoft Fabric Data Engineer
Sr Microsoft Fabric Data Engineer

Newlineinfo Corp - IT Services and IT Consulting • Dallas (TX)

On-site
USD 140,000 - 180,000
Senior Data Architect (Microsoft Fabric)
Senior Data Architect (Microsoft Fabric)

EazyML • United States

Remote
USD 170,000 - 250,000
Lead Data Architect - Microsoft Fabric
Lead Data Architect - Microsoft Fabric

Weekday • United States

Remote
USD 21,000 - 64,000
Lead Data Architect (Fabric)
Lead Data Architect (Fabric)

Weekday • United States

Remote
USD 21,000 - 64,000
Data Engineer
Data Engineer

Franklin Fitch • United States

Remote
USD 140,000 - 160,000
Fabric Solution Architect
Fabric Solution Architect

iLink Digital • St. Louis (MO)

On-site
USD 120,000 - 150,000
Lead MS Fabric Administrator
Lead MS Fabric Administrator

TriCom Technical Services • Pittsburgh

Remote
USD 140,000 - 170,000
Data Engineer (Microsoft Fabric)
Data Engineer (Microsoft Fabric)

MMD Services • Chicago (IL)

On-site
USD 110,000 - 140,000
MS Fabric Lead
MS Fabric Lead

Experion • United States

Remote
USD 140,000 - 190,000
Data Engineer
Data Engineer

betterdebtsolutions • Irvine (CA)

On-site
USD 140,000 - 155,000