Description
Role: BI Lead (Power BI / Tableau)

Location : Gurugram

Hire Type : FTE

KEY RESPONSIBILITIES
- Lead BI architecture and solution design conversations with clients, acting as the primary technical authority on data and analytics platforms.
- Design, build, and optimise Power BI semantic models and Tableau data sources for enterprise-scale performance and maintainability.
- Write and optimise complex DAX measures, M/Power Query transformations, and SQL queries to support accurate, high-performance reporting.
- Diagnose and resolve data model issues — slow DAX, broken relationships, cardinality problems, and upstream data quality issues — quickly and systematically.
- Architect dimensional data models (star schema, fact/dimension design) and semantic layers consumed across multiple BI tools.
- Drive self-service BI capability: certify datasets, define governed metrics, and build enablement programmes so business teams can explore data independently.
- Define BI deployment standards, CI/CD pipelines,



and release governance to ensure reliable and secure analytics delivery.
- Partner with data engineering teams to design analytics-ready data structures and resolve data issues at source.
- Establish data governance frameworks covering data quality standards, metadata management, access controls, and KPI standardisation across business units.
- Mentor BI developers through code and model reviews, sharing DAX, SQL, and design best practices to raise overall team capability.

MUST-HAVE SKILLS

Power BI
- Semantic model design and optimisation: star-schema modelling, reducing cardinality, managing relationships, aggregations, and composite models.
- Advanced DAX: effective, reusable measures; evaluation context; CALCULATE; iterator functions; time intelligence patterns.
- M / Power Query: advanced transformations, query folding, incremental refresh, parameter-driven pipelines.
- Power BI Service governance: certified datasets, deployment pipelines, workspaces, ro

📌 BI Lead (Gurugram)
🏢 EXL
📍 Gurugram