Roles & Responsibilities:

- Own analytics for assigned projects and functions.

- Build analytical views and manage recurring reports.

- Handle business queries and provide insights between reporting cycles.

- Perform data preparation, data visualization and analysis of trends.

- Investigate changes in business performance, such as conversion drops, source mix, inventory exhaustion, RM changes and pricing.

- Identify and resolve data quality issues, including missing reason codes and duplicate leads.

- Reconcile cancelled bookings that have not been returned to inventory.

- Work with business functions and central teams to provide insights for growth and support data-driven decision-making.

Preferred Candidate Profile:

- 2-5 years of experience in Analytics, Business Analysis or MIS.

- Robust SQL knowledge, including joins, aggregation and window functions.

- Advanced Excel skills, including Pivot Tables and Lookups.

- Working knowledge of at least one BI tool.

- Ability to present findings to functional heads, explaining what changed, why it changed and what action should be taken.

- Python for analysis.

- Experience in Real Estate, Retail or BFSI.

- Experience with a CRMs reporting layer.

📌 Data Analyst (Mumbai)
🏢 Kolte Patil
📍 Mumbai