Data Analyst and Reporting Insights Analyst

Process Manager

Description

Role: Data Analyst / Reporting & Insights Analyst 

Location : Mumbai 

Summary

We are looking for a Data Analyst who can turn complex data into clear, decision-ready insights. The role involves advanced Excel-based analysis, Tableau/BI reporting, performance tracking, forecasting, and strong stakeholder management across multiple teams.

Key Responsibilities

• Build and manage dashboards & reports using Excel & PowerBI (preferred) or other BI tools (Tableau, Looker, etc.).
• Perform deep-dive analysis in Advanced Excel (pivot tables, Power Query, complex formulas, data modelling, VBA).
• Track and report business performance KPIs (daily/weekly/monthly), ensuring accuracy and consistency across multiple reports.
• Drive forecasting, budgeting, and variance tracking (actual vs plan, trend analysis, risks/opportunities etc).
• Translate data into storytelling narratives: crisp executive summaries, insights, recommendations, and next actions.
• Handle large datasets (multiple sources, high-volume tables), validate data quality, and troubleshoot inconsistencies.
• Partner with stakeholders across functions (Business, Ops, Product, Marketing, Finance, Tech) to gather requirements and deliver reporting solutions.
• Maintain reporting documentation: metric definitions, dashboard logic, refresh cycles, and governance standards.
• SQL skills for data extraction and validation.
• Exposure to automation (Excel macros/VBA, Python) for reporting efficiency.

Must-Have Skills & Requirements

• Advanced Excel expertise (Power Query/Power Pivot, pivots, lookups, indexing, nested formulas; automation is a plus).
• Strong hands-on experience with PowerBI or equivalent BI tools (Tableau/Looker/Qlik).
• Proven ability in data analysis + insight storytelling (not just reporting—recommendations matter).
• Experience with performance tracking and forecasting/budget tracking (variance analysis, trend modeling).
• Comfortable managing multiple reports, stakeholders, and deadlines in a fast-paced environment.
• Strong communication: can explain data clearly to both technical and non-technical audiences.