Senior Microsoft Fabric & Power BI Data Engineer

smartData; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

smartData is seeking a Senior Data Engineer to build enterprise data platforms, ETL/ELT pipelines, data models, and BI solutions using Microsoft Fabric and Power BI. Healthcare domain experience is a plus.

You will design data solutions with OneLake, Lakehouse, and Medallion architecture; develop Bronze/Silver/Gold layers; implement governance with Purview; collaborate across teams in India.

Qualifications

• 5+ years of data engineering and BI experience.
• Hands-on with Microsoft Fabric stack and data platforms.
• Strong knowledge of SQL, data modeling, and ETL/ELT patterns.

Responsibilities

• Design data solutions using Fabric stack and Lakehouse architecture.
• Create Bronze-Silver-Gold data layers with Medallion architecture.
• Build scalable ETL/ELT pipelines and data ingestion processes.
• Develop analytics-ready fact and dimension models.
• Create Power BI dashboards and semantic models with DAX and Power Query.
• Monitor Fabric pipelines, SQL queries, and Power BI dashboards.
• Implement data governance and RBAC with Purview and Azure security.

Skills

Data engineering

Business Intelligence

ETL/ELT design

SQL / T-SQL

Python / ETL scripting

Tools

Microsoft Fabric

OneLake

Lakehouse

Fabric Warehouse

Medallion Architecture

Power BI

DAX

Power Query

Azure Data Services

CI/CD (Azure DevOps/GitHub Actions)

Jira/Agile/Scrum

Job description

We are looking for a Senior Data Engineer with experience in building enterprise data platforms, ETL/ELT pipelines, data models, and Business Intelligence solutions using Microsoft Fabric and Power BI. Experience in the healthcare domain is preferred.

Key Responsibilities

• Design data solutions using Microsoft Fabric, OneLake, Lakehouse, and Fabric Warehouse.
• Build Bronze, Silver, and Gold data layers using the Medallion Architecture.
• Develop scalable ETL/ELT pipelines, data ingestion, transformation, and orchestration using Fabric Data Factory and Dataflows Gen2.
• Create analytics-ready Fact and Dimension models and optimize performance.
• Develop Power BI dashboards, semantic models, and reports using DAX and Power Query.
• Monitor and optimize Fabric pipelines, SQL queries, and Power BI reports.
• Implement data governance, security, and access controls using Microsoft Purview and RBAC.

Required Skills

• 5+ years of experience in Data Engineering and Business Intelligence.
• Hands‑on experience with Microsoft Fabric, OneLake, Lakehouse, Fabric Warehouse, and Medallion Architecture.
• Strong knowledge of SQL/T‑SQL, ETL/ELT, Delta Lake, Parquet, Star Schema, and Fact & Dimension tables.
• Experience with Power BI, including DAX, Power Query, DirectLake, DirectQuery, semantic models, dashboards, and performance optimization.
• Knowledge of Microsoft Purview, data governance, security, and pipeline monitoring; experience with Azure Data Services is an advantage.
• Experience with CI/CD using Azure DevOps, GitHub Actions, or similar, along with Jira, Agile/Scrum, and independent task ownership and delivery.

Preferred Skills

• Experience with Healthcare Claims, EHR, FHIR, HL7, ICD-10, and HIPAA‑compliant data solutions.
• Microsoft Fabric and Power BI certifications.
• Experience working with Agile methodologies and Azure DevOps.

Soft Skills

• Strong English communication and client collaboration skills.
• Self‑starter capable of leading projects and taking end-to-end ownership.