MS Fabric Lead

Experion; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

Experion is seeking a Microsoft Fabric Lead to steer end‑to‑end data and analytics solutions on Microsoft Fabric and Azure. You will guide a delivery team, set engineering best practices and collaborate with architects and stakeholders to translate requirements into scalable Fabric implementations.

The role focuses on data ingestion, transformation, Lakehouses, Power BI reporting and production readiness, with a strong emphasis on performance, security and governance.

Qualifications

• Hands-on experience with Microsoft Fabric and data platforms.

Responsibilities

• Lead development and delivery of Fabric-based data solutions end-to-end.
• Mentor developers and perform technical reviews.
• Optimize performance, security and data quality.
• Collaborate with architects, PMs and stakeholders to translate requirements into designs.
• Contribute to CI/CD and DevOps practices for data projects.

Skills

Microsoft Fabric

SQL

PySpark/Spark/Python

ETL/ELT

Power BI modeling

Direct Lake/DirectQuery

Agile/DevOps

Azure data services

Data modeling

Data quality & integration

Data pipelines & orchestration

Tools

OneLake

Fabric Lakehouse

Fabric Warehouse

Azure Data Factory

Power BI

ADLS

Azure SQL/Synapse

Direct Lake/DirectQuery

Job description

Job Purpose

Lead the design, development and delivery of Microsoft Fabric-based data solutions, ensuring high quality, scalable and performant data engineering and analytics implementations. The role will provide hands‑on technical leadership to the delivery team, establish engineering best practices, and work with architects and stakeholders to translate requirements into effective Fabric solutions.

Job Description

The Microsoft Fabric Lead will lead technical implementation across Microsoft Fabric and Azure, covering data ingestion, transformation, Lakehouse, Warehouse, data pipelines, Spark‑based processing and Power BI. The role will guide developers, perform technical reviews, troubleshoot complex issues and ensure solutions meet defined architecture, security, performance and quality standards. The role will collaborate with the Fabric Architect, project managers, business stakeholders and engineering teams to deliver end‑to‑end data and analytics solutions.

DUTIES & RESPONSIBILITIES

Lead development and implementation of Microsoft Fabric solutions using OneLake, Lakehouse, Fabric Warehouse and Data Factory/Pipelines.

• Design and develop scalable ETL/ELT data pipelines and data transformation processes.
• Develop and optimize SQL, PySpark/Python and Spark workloads.
• Implement Medallion architecture and appropriate data modelling patterns.
• Lead development of Power BI semantic models, datasets and reports, including Direct Lake/Import/DirectQuery where applicable.
• Perform code reviews, technical reviews and ensure adherence to development standards.
• Troubleshoot performance, data quality and integration issues and provide technical solutions.
• Implement data security, governance, quality and monitoring practices defined by the architecture.
• Support data-platform migration and modernization initiatives.
• Work closely with the Fabric Architect to translate solution architecture into implementation designs.
• Mentor developers and provide technical guidance to the delivery team.
• Participate in POCs, technical estimations, design discussions and client/stakeholder meetings.
• Ensure timely delivery of technically robust and production-ready solutions.
• Adherence to company policies, procedures, and relevant regulations in all duties.

Job Specification / Skills and Competencies

Strong hands‑on experience with Microsoft Fabric.

• Fabric Lakehouse, OneLake and Fabric Warehouse.
• Fabric Data Factory / Data Pipelines.
• Strong SQL skills.
• Hands‑on PySpark / Spark / Python experience.
• Strong understanding of ETL/ELT and data engineering.
• Power BI development and semantic modelling.
• Experience with Direct Lake, Import and/or DirectQuery.
• Azure data services, preferably ADLS, Azure SQL, Synapse and Azure Data Factory.
• Data modelling, data quality and data integration.
• Experience working in Agile/DevOps delivery environments.

Microsoft Fabric Data Engineering

Lakehouse and Medallion Architecture

SQL development and performance optimization

Power BI semantic models and enterprise reporting

Data migration and modernization

CI/CD and deployment practices

Technical troubleshooting and performance tuning

Technical leadership, mentoring and code reviews

Ability to work with architects and translate designs into implementation