Associate - Project Manager
Referral available at EXL
An employee here can refer you. The referrer stays anonymous and reaches out to you directly if interested.
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.
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.
- 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.
Skills
- A/B Testing
- Analytics
- BigQuery
- Business Intelligence
- Cloud
- Data Analytics
- Data Engineering
- Data Governance
- Data Modeling
- Data Pipelines
- Data Quality
- Data Visualization
- Databricks
- dbt
- Dimensional Modeling
- Power Query
- Power BI
- Python
- Redshift
- Snowflake
- SQL
- Stakeholder Management
- Tableau
- Version Control
Sign in to read and join the discussion.