We are seeking a skilled Business Intelligence (BI) Engineer with strong expertise in Power BI and Tableau to build scalable reporting and analytics solutions for a high-volume sports, media, and digital engagement ecosystem. The role involves designing and delivering enterprise-grade dashboards, data models, and KPI frameworks that enable stakeholders across product, content, marketing, and operations to make data-driven decisions. You will work closely with data engineering and analytics teams to transform complex datasets into actionable, high-performance BI solutions optimized for large-scale usage and executive reporting. This is an offshore role supporting a globally distributed analytics organization. Responsibilities 1. BI Dashboard Development (Power BI / Tableau)
• Design, develop, and maintain interactive dashboards and reports using:
• Power BI
• Tableau
• Build dashboards for key domains such as:
• User engagement and fan behavior analytics
• Content consumption and streaming performance
• Marketing campaign effectiveness
• Operational and business KPI tracking
• Ensure dashboards are visually intuitive, business-friendly, and performance-optimized.
• Implement advanced dashboard features such as drill-downs, filters, parameters, and dynamic visuals. 2. Data Modeling for BI
• Develop and maintain efficient data models (star schema / dimensional models) for reporting.
• Build semantic layers and reusable datasets to ensure consistency across Power BI and Tableau reports.
• Optimize data models for query performance and scalability.
• Collaborate with data engineering teams to structure BI-ready datasets. 3. SQL & Data Preparation
• Write complex and optimized SQL queries for data extraction and transformation.
• Work with large datasets in cloud data warehouses (Snowflake, BigQuery, Redshift, or Databricks).
• Validate and reconcile data to ensure accuracy across BI dashboards.
• Support data preparation for reporting and analytics use cases. 4. KPI & Metrics Definition
• Define and maintain business KPIs and metric frameworks in collaboration with stakeholders.
• Ensure single source of truth for all reporting layers.
• Align reporting logic across Power BI and Tableau environments.
• Standardize definitions for key business and product metrics. 5. Performance Optimization
• Optimize dashboards for fast load times and high user concurrency.
• Improve query performance through aggregation strategies and efficient data modeling.
• Troubleshoot and resolve performance issues in BI reports. 6. Cross-Functional Collaboration
• Work closely with:
• Data Engineering teams (data pipelines & transformations)
• Product teams (reporting requirements & KPIs)
• Analytics teams (insights & experimentation)
• Translate business requirements into scalable BI solutions.
• Support ad-hoc reporting and deep-dive analysis requests. 7. Data Quality & Governance
• Ensure data accuracy, consistency, and validation across BI outputs.
• Maintain documentation for dashboards, datasets, and KPI definitions.
• Follow best practices for BI governance, version control, and reporting standards. Qualifications
• 3–7+ years of experience in Business Intelligence / Data Analytics / BI Engineering roles.
• Strong hands-on experience with:
• Power BI (DAX, Power Query, data modeling)
• Tableau (LOD expressions, dashboard design, calculations)
• Advanced SQL skills (joins, window functions, performance tuning).
• Robust experience in data modeling (star schema, dimensional modeling).
• Experience working with cloud data platforms:
• Snowflake / BigQuery / Redshift / Databricks
• Strong understanding of dashboard design principles and data visualization best practices.
• Experience working with large datasets and enterprise reporting systems. Preferred Skills
• Experience in sports analytics, media, streaming, or digital consumer platforms.
• Familiarity with dbt or modern data transformation workflows.
• Exposure to A/B testing, cohort analysis, or experimentation frameworks.
• Basic understanding of Python for data analysis (optional).
• Experience working in real-time or near-real-time reporting environments.
• Knowledge of data governance tools and practices. Soft Skills
• Strong communication skills for working with global offshore/onshore teams.
• Ability to independently manage deliverables in a remote setup.
• Strong analytical thinking and attention to detail.
• Ability to handle multiple reporting priorities in a fast-paced environment.
• Strong stakeholder management and requirement gathering skills.
📌 Associate - Project Manager (Gurugram)
🏢 EXL
📍 Gurugram