04 Power BI Engineer Engineering · Gurgaon India →

D2R Technologies Pte Ltd; Gurugram District; On-site; INR 1,500,000 - 2,400,000; Full time

Job summary

D2R Technologies Pte Ltd is seeking a BI Engineer to design and deliver analytics solutions on Microsoft Fabric for client engagements across India, UAE, KSA, UK, and Australia. You will own semantic models, Fabric data workloads, and report delivery end-to-end, while migrating Tableau estates where needed.

Prioritize candidates with automotive OEM data experience; strong DAX, SQL, and Fabric skills are essential, along with stakeholder-facing capabilities.

Qualifications

• 2+ years Power BI (Desktop + Service) with advanced DAX and Power Query.
• 12+ months hands-on Microsoft Fabric (Direct Lake, OneLake, Dataflows Gen2).
• 2+ years Tableau (Desktop; Server/Cloud) with LOD expressions.
• Hands-on with on-premise and cloud deployment: SQL Server / SSAS Tabular, Power BI Report Server or Tableau Server; Fabric / Power BI Service.
• Strong SQL and dimensional modelling (Kimball).
• Deployment discipline: workspace lifecycle, deployment pipelines, Git-integrated Fabric items.
• Fluent English communications; able to run stakeholder sessions.

Responsibilities

• Design star-schema semantic models and build Power BI reports on Fabric.
• Operate Fabric workloads: Lakehouse, Dataflows Gen2, Data Pipelines, and notebooks for transformation.
• Develop Direct Lake semantic models and choose Direct Lake/Import/DirectQuery per workload.
• Write advanced DAX and Power Query; tune performance and query folding.
• Migrate Tableau dashboards to Power BI where needed.
• Implement governance: workspace strategy, deployment pipelines with Git, RLS/OLS, labels, capacity monitoring.
• Support hybrid architectures: on-prem gateway and on-prem to cloud migrations.
• Work with clients: gather requirements, write specs, perform UAT, deliver docs.

Skills

Power BI advanced DAX

Stakeholder communication

SQL proficiency

Dimensional modelling (Kimball)

Tableau experience

Fabric knowledge

Git integration

Tools

Power BI Desktop/Service

Tableau Server/Cloud

SQL Server / SSAS

Fabric (Microsoft Fabric)

PySpark / Spark SQL

Job description

We are hiring a BI Engineer to design and deliver analytics solutions on Microsoft Fabric for client engagements across India, UAE, KSA, UK, and Australia. You will own semantic models, Fabric data workloads, and report delivery end-to-end, while maintaining and migrating existing Tableau estates where clients run dual stacks. This is a client-facing delivery role - you translate business requirements into governed, performant BI assets, not just dashboards.

Domain preference: candidates with automotive OEM commercial / sales-performance data experience will be prioritised.

What You’ll Do

• Design star-schema semantic models and build reports and dashboards in Power BI on Fabric capacities
• Build and operate Fabric workloads: Lakehouse/OneLake, Dataflows Gen2, Data Pipelines, and notebooks (PySpark / Spark SQL) for transformation
• Develop Direct Lake semantic models; choose correctly between Direct Lake, Import, and DirectQuery per workload
• Write advanced DAX and Power Query (M); tune for performance — query folding, incremental refresh, aggregations, VertiPaq optimisation
• Maintain, enhance, and where required migrate existing Tableau workbooks and dashboards to Power BI
• Implement governance: workspace strategy, deployment pipelines with Git integration, RLS/OLS, sensitivity labels, capacity monitoring (F-SKUs)
• Design and support hybrid architectures: on-premises data gateway connectivity, and on-prem → cloud migrations (SSAS Tabular, Power BI Report Server, Tableau Server estates into Fabric / cloud)
• Work directly with client stakeholders: requirements gathering, spec writing, UAT, and delivery documentation

Requirements

Must-Have

• 2+ years Power BI (Desktop + Service): advanced DAX (context transition, CALCULATE mechanics), Power Query/M, composite models
• 12+ months hands-on Microsoft Fabric: Direct Lake, OneLake shortcuts, Dataflows Gen2, Data Pipelines, Lakehouse vs Warehouse trade-offs
• 2+ years Tableau (Desktop; Server/Cloud exposure): LOD expressions, extracts vs live, dashboard actions and performance tuning
• Hands-on with both on-premise and cloud deployment models: SQL Server / SSAS Tabular, Power BI Report Server or Tableau Server on-prem; Fabric / Power BI Service and Tableau Cloud; hybrid connectivity via the on-premises data gateway
• Strong SQL and dimensional modelling (Kimball); comfortable working against warehouse / lakehouse sources
• Deployment discipline: workspace lifecycle, deployment pipelines, Git-integrated Fabric items
• Clear written and spoken English; able to run stakeholder sessions independently

Good-to-Have

• Automotive OEM domain experience — commercial / sales-performance data: wholesale vs retail volumes, dealer network KPIs, incentives / VME, fleet, pricing; NSC or regional sales-org exposure is a strong plus
• DP-600 (Fabric Analytics Engineer Associate) — strongly preferred; PL-300 expected
• Python / PySpark in Fabric notebooks beyond copy-paste level
• Azure data estate context: ADF / Synapse and migration paths into Fabric
• Purview, or any formal data governance exposure

Certifications

• Required or in-progress: PL-300 (Power BI Data Analyst)
• Strongly preferred: DP-600 (Fabric Analytics Engineer)