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.
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.