Job Description: 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:
- 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).
- Strong 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.