Associate - Project Manager (Gurugram)

Associate - Project Manager (Gurugram)

20 Nov
|
EXL
|
Gurugram

20 Nov

EXL

Gurugram

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

📌 Associate - Project Manager (Gurugram)
🏢 EXL
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: associate - project manager (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: associate - project manager (gurugram) / gurugram