Associate - Project Manager
Gurugram, HR, India6h ago
Key details
- Location
- Gurugram, HR, India
- Work style
- Hybrid
- Level
- Mid level
- Job type
- Full-time
- Experience
- 3–7 yrs
- Function
- Product / Program management
- Focus area
- other
- Posted
- 6h ago
Skills
About the role
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.
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.