BI Developer

Kimbal; India; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Kimbal in India is seeking a data engineer/BI specialist to own the full data lifecycle, building scalable data lakes and BI reports. You will split time between engineering data pipelines in Databricks and developing Power BI semantic models and user-facing dashboards.

The role requires strong SQL, Spark, PySpark, SAP/MES knowledge and the ability to implement security and governance while enabling self-service analytics for business users.

Qualifications

• Bachelor's or Master’s degree from Tier-1/2 institute (IIT / NIT / BITS or equivalent).
• 3–5 years of experience building and running Data Platforms and BI reporting.
• Hands-on with Databricks, Spark (PySpark/SQL), and cloud data warehouses (Azure/AWS/GCP).

Responsibilities

• Build scalable data pipelines (ETL/ELT) to ingest, process, and clean data using Databricks.
• Define metrics, KPIs, and visual layouts for Power BI dashboards across functions.
• Establish clean semantic layers and security frameworks (RLS/OLS) in Databricks and Power BI.
• Collaborate with stakeholders to drive adoption and data literacy.

Skills

Databricks

Spark/SQL

Power BI

DAX

Power Query

Python

SQL

SAP data

MES data

Education

Tier-1/2 institute degree (IIT/NIT/BITS)

Tools

Azure

AWS

GCP

SAP

MES

Job description

Job Description:

Role Purpose

Own the full data lifecycle: from building scalable data lakes/warehouse/mart/houses to delivering intuitive, interactive dashboards. You will spend half your time engineering data pipelines in Databricks - integrating enterprise sources like SAP and MES - and the other half developing high-performance Power BI semantic models and user-facing reports. The ideal candidate blends back-end data orchestration with front-end analytical storytelling.

Key Responsibilities

1. Data Platform

• Build scalable data pipelines (ETL/ELT) to ingest, process, and clean structured and unstructured data using Databricks.


• Extract, blend, and harmonize complex data streams from multiple systems including such as SAP & MES.


• Implement robust data governance, access controls, and optimizations to ensure data integrity and query performance.


• Ensure cost of the data platforms is within budget

2. Enterprise Business Intelligence

• Define the metrics, KPIs, and visual layout for Power BI dashboards across Sales, Planning, Production, Sourcing, Quality, Logistics, Finance, engineering etc.


• Author complex, time-intelligent, and context-aware DAX calculations to compute functional KPIs, targets, and trend metrics.


• Establish clean, well-documented semantic layers and workspaces to support power users in building their own ad-hoc visualizations.


• Implement dynamic Row-Level Security (RLS) and Object-Level Security (OLS) frameworks across Databricks and Power BI.


• Build all review dashboards in Power BI


• Establish a self-service BI model, training functional power-users on data literacy and report consumption.

3. Stakeholder Management

• Work with functional team members to identify their needs, conceptualize the UI that best meets their needs, take alignment from the team members and support in driving adoption.

Candidate Profile

Education

• Bachelor's or Master's degree from Tier-1/2 institute (IIT / NIT / BITS or equivalent)

Experience

• 3-5 years of experience in building and running Data Platforms and Business Intelligence reporting.


• At least 4 years of hands-on experience with Databricks, Spark (PySpark/SQL), and cloud data warehouse ecosystems (Azure, AWS, or GCP).


• Solid understanding of SAP data structures (Tables, BAPIs, OData) and MES transactional data mapping.


• Expert-level proficiency in Power BI, advanced DAX modelling, Power Query, and star-schema data modelling.

Skills & Competencies

• Databricks & Spark (PySpark/Spark SQL)


• SQL


• Power BI Desktop & Service, Advance DAX, Power Query processing etc.


• Python


• Strong foundational knowledge of SAP data structures or MES logs is highly preferred.

Requirements: