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: efficient, 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, row-level security, gateways, and refresh scheduling.
- Self-service BI: promoting dataset reuse and enabling business users to build their own reports without IT dependency.
Tableau
- Dashboard and data source design for enterprise-scale reporting.
- Tableau Server / Tableau Cloud governance, published data sources, and performance optimisation.
SQL & Data Architecture
- Strong SQL: complex queries, CTEs, window functions, query optimisation, and reading execution plans.
- Data warehouse and dimensional modelling: fact/dimension design, schema validation, and data lineage.
- ETL/ELT understanding: diagnosing and resolving upstream data issues that affect BI layers.
Communication & Stakeholder Engagement
- Comfortable presenting architecture, data strategy, and roadmaps to client executives and technical leaders.
- Skilled at requirements gathering from non-technical stakeholders and translating them into scalable BI solutions.
- Experience leading architecture reviews, discovery workshops, and solution design sessions.
GOOD TO HAVE
- Snowflake: query optimisation, warehouse sizing, and integrating Snowflake with Power BI or Tableau via DirectQuery or native connectors.
- Sigma Computing: cloud-native self-service analytics on Snowflake; governed metrics, semantic model integration, and business user enablement.
- Experience connecting Sigma Computing with existing Power BI and Tableau ecosystems without creating governance gaps or data duplication.
- Working knowledge of policy lifecycle, claims, underwriting, premiums, loss ratios, and combined ratio.
- Ability to translate insurance business questions into structured KPIs, metrics hierarchies, and dashboard designs.
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.
Bachelor's Degree
Skills Required
- Power BI semantic model design and optimisation (star schema, aggregations, composite models)
- Advanced DAX (complex measures, evaluation context, time intelligence)
- M / Power Query advanced transformations, query folding, incremental refresh
- Power BI Service governance (certified datasets, deployment pipelines, workspaces, RLS, gateways)
- Tableau dashboard and data source design plus Tableau Server/Cloud governance
- Strong SQL skills (CTEs, window functions, query optimisation, execution plans)
- Data warehouse and dimensional modelling (fact/dimension design, schema validation, lineage)
- ETL/ELT understanding to diagnose and resolve upstream data issues
- Experience defining BI deployment standards, CI/CD pipelines, and release governance
- Stakeholder engagement and presentation of architecture and data strategy to executives
- Mentoring BI developers through code and model reviews
- Bachelor's Degree
- Snowflake experience (query optimisation, warehouse sizing, Power BI/Tableau integration)
- Sigma Computing and integration experience
- Insurance domain knowledge (policy lifecycle, claims, underwriting, insurance KPIs)
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
