Fabric Senior Data Engineer
EXL Gurugram, Haryana, India
Business Consulting and Services · 10,001+ employees
About the role
Develop and maintain Microsoft Fabric and OneLake Lakehouse solutions using Medallion Architecture across Bronze, Silver, and Gold layers. Build scalable data ingestion pipelines and optimize Spark workloads to support Power BI semantic models and business KPIs.
What they look for
Requirements
Requires over 5 years of data engineering experience with strong proficiency in Azure, Microsoft Fabric, PySpark, and SQL. A bachelor's degree is required, and experience in commercial insurance or brokerage data is preferred.
Full description
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 • 5+ 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.
Responsibilities
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 • 5+ 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.
Qualifications
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 • 5+ 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.
Similar roles
-
Data Engineer 4 (Manager, IC)
Capital One McLean, Virginia, United States · $179K–$225K/yr
-
Senior Data Engineer, Vice President
State Street Boston, Massachusetts, United States · $110K–$208K/yr
-
AI Data Engineer II (Business Data Analyst II)
UKG Bengaluru, Karnataka, India
-
Senior Data Engineer (Spark)
SSC HR Solutions Cairo, Cairo, Egypt
-
Databricks Data Engineer
Elevate Government Solutions Washington, District of Columbia, United States
-
Senior Data Engineer
Iris Software Noida, Uttar Pradesh, India