Role : Business Intelligence Lead

Experience : 8+ years

Key Responsibilities :

Data Engineering (Azure Stack) :

- Design and develop scalable data pipelines using Azure Data Factory (ADF) and Databricks jobs and notebooks.

- Develop efficient data transformation logic using PySpark DataFrames and SQL functions.

- Build reusable Python-based frameworks and utilities for robust ETL/ELT processes.

- Orchestrate Databricks jobs from ADF pipelines for end-to-end automation and integration.

- Tune Databricks workloads and optimize ADF pipelines for performance and cost efficiency.

Data Integration & Architecture :

- Architect and maintain scalable data lake/lakehouse solutions (ADLS Gen2 + Databricks).

- Integrate data from multiple sources (D365, Salesforce, APIs, flat files, databases).

- Develop and maintain Delta Lake / Medallion architecture (Bronze, Silver, Gold layers).

- Standardize enterprise data models for analytics and reporting, ensuring quality and consistency.

Power BI Development :

- Design, develop, and maintain Power BI reports, dashboards, and datasets.

- Build and support Power BI Paginated Reports (Report Builder / RDL).

- Develop optimized semantic models using advanced DAX and data modeling best practices.

- Create and maintain complex data transformations using M Query (Power Query).

- Manage Power BI Service workspaces, deployments, and security (RLS, access control).

Performance & Optimization :

- Manage existing BI infrastructure, reports, reporting systems and recommend strategies to improve performance and capacity of BI tools for current and future data.

- Monitor, troubleshoot, and resolve incidents; implement BI systems monitoring and alerts.

- Support BI tools upgrades and maintain technical architectural documentation.

Collaboration & Delivery :

- Work closely with business stakeholders, BI teams, and data architects to translate requirements into scalable solutions.

- Provide technical leadership, mentorship, and foster a results-driven, customer-centric culture.

- Document technical solutions and share best practices with the broader BI and IT teams.

Required Qualifications :

- Bachelors degree in Computer Science, Information Systems, or related field preferred.

- 8+ years experience in enterprise-wide BI system design and architecture.

- 7+ years in data modeling and visualization.

- Strong experience with Azure Databricks, Azure Data Factory, ADLS Gen2, SQL, Python, Power BI Desktop/Service, Report Builder, DAX.

- Experience with Microsoft Fabric / Direct Lake, CI/CD pipelines (Azure DevOps, GitHub).

- Ability to work in large, complex BI development projects.

- Strong written and verbal communication skills.

- Experience with Agile methodology and offshore teams.