Bi Lead Gurugram (India)

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: productive, 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 .