Lead Data Engineer - Azure + Fabric

EXL Talent Acquisition Team; Gurugram District; On-site; INR 300,000 - 520,000; Full time

Job summary

EXL Talent Acquisition Team is seeking an experienced Data Engineer to design and maintain a modern data platform using Microsoft Fabric and OneLake. You will build scalable pipelines, implement data quality, and support analytics with Power BI, across Bronze to Gold layers.

You will work with Spark / PySpark, Python, SQL, and Delta Lake, implementing CDC frameworks, data ingestion, and governance aligned with Purview.

Qualifications

• 8+ years of data engineering experience with hands-on Azure/Microsoft Fabric.
• Strong hands-on experience with Microsoft Fabric Lakehouse, OneLake, Warehouse, Data Pipelines, and Notebooks.
• Proficiency in Spark / PySpark, Python, SQL, and Delta Lake.
• Experience with ETL/ELT, CDC, data ingestion, transformation, and Medallion Architecture.
• Experience developing data quality, validation, reconciliation, and exception-handling frameworks.
• Knowledge of Power BI semantic models and Direct Lake.
• Experience with Microsoft Purview, Azure DevOps, Git, CI/CD, and deployment.
• Commercial insurance or brokerage data experience preferred.

Responsibilities

• Develop and maintain Microsoft Fabric / OneLake Lakehouse solutions across Bronze, Silver, and Gold layers.
• Build reusable data ingestion pipelines and CDC frameworks for sources including GCP, CSV, Excel, email files, and SharePoint.
• Implement Bronze-layer ingestion with audit logging, schema validation, schema-drift detection, and error handling.
• Develop Silver-layer transformations for cleansing, standardization, data quality, validation, and exception handling.
• Build Gold-layer datasets including curated entities, conformed dimensions, business metrics, KPIs, aggregations, and secure views.
• Develop and optimize Spark / PySpark, Python, and SQL workloads for scalable data processing.
• Build data pipelines using Fabric Data Pipelines, Synapse Pipelines, and Notebooks.
• Support Power BI semantic models and Direct Lake data consumption requirements.
• Implement data quality checks, reconciliation processes, monitoring, and operational controls.
• Follow data governance and security standards, including Purview, RBAC, PII/PHI controls, classification, and lineage.
• Troubleshoot pipeline failures, performance issues, data discrepancies, and production incidents.
• Collaborate with Solution Architects, Lead Data Engineers, BI teams, and business stakeholders to deliver scalable data solutions.

Skills

Spark / PySpark

Python

SQL

Delta Lake

ETL/ELT

CDC

Medallion Architecture

Power BI semantics

Direct Lake

Data quality

Reconciliation

Exception handling

Purview

Azure DevOps

Git

CI/CD

Deployment

Education

B.Tech / Bachelor’s degree in CS/Engineering/IT

Microsoft Fabric or Azure Data Engineer certification

Tools

Purview

Azure DevOps

Git

CI/CD

Job description

Data Engineer – Microsoft Fabric / OneLake

Role Overview

We are looking for a Data Engineer to develop and maintain a modern data platform leveraging Microsoft Fabric, OneLake, and the Medallion Architecture. The role will focus on building scalable data pipelines, implementing data transformation and quality processes, and supporting curated data products for analytics and Power BI.

Key Responsibilities

• Develop and maintain Microsoft Fabric / OneLake Lakehouse solutions across Bronze, Silver, and Gold layers.
• Build reusable data ingestion pipelines and CDC frameworks for sources including GCP, CSV, Excel, email files, and SharePoint.
• Implement Bronze-layer ingestion with audit logging, schema validation, schema-drift detection, and error handling.
• Develop Silver-layer transformations for cleansing, standardization, data quality, validation, and exception handling.
• Build Gold-layer datasets including curated entities, conformed dimensions, business metrics, KPIs, aggregations, and secure views.
• Develop and optimize Spark / PySpark, Python, and SQL workloads for scalable data processing.
• Build data pipelines using Fabric Data Pipelines, Synapse Pipelines, and Notebooks.
• Support Power BI semantic models and Direct Lake data consumption requirements.
• Implement data quality checks, reconciliation processes, monitoring, and operational controls.
• Follow data governance and security standards, including Purview, RBAC, PII/PHI controls, classification, and lineage.
• Troubleshoot pipeline failures, performance issues, data discrepancies, and production incidents.
• Collaborate with Solution Architects, Lead Data Engineers, BI teams, and business stakeholders to deliver scalable data solutions.

Required Experience & Skills

• 8+ years of overall Data Engineering experience with hands-on experience in Azure /Microsoft Fabric.
• Strong hands-on experience with Microsoft Fabric Lakehouse, OneLake, Warehouse, Data Pipelines, and Notebooks.
• Proficiency in Spark / PySpark, Python, SQL, and Delta Lake.
• Experience with ETL/ELT, CDC, data ingestion, transformation, and Medallion Architecture.
• Experience developing data quality, validation, reconciliation, and exception-handling frameworks.
• Knowledge of Power BI semantic models and Direct Lake.
• Experience with Microsoft Purview, Azure DevOps, Git, CI/CD, and deployment
• Commercial insurance or brokerage data experience preferred.

Education & Certifications

• B.Tech / Bachelor’s degree or equivalent in Computer Science, Engineering, Information Technology, or a related field.
• Microsoft Fabric or Azure Data Engineer certification preferred.