Job Title: Business Analyst

Location: Gurugram | On-site | 6 days a week

Experience: 2-3 Years

Department: Business / Sales Analytics

About the Role iQuanta is looking for a highly analytical and numbers-driven Business Analyst who can work closely with business, sales, and marketing teams to turn raw data into clear insights and actionable decisions.

The ideal candidate should be excellent with numbers, data handling, Excel/Google Sheets, reporting, and sales funnel analysis, with a strong eye for identifying gaps, inconsistencies, and opportunities in data.

Key Responsibilities

- Analyse sales funnel data from lead generation to conversion and revenue.
- Track and analyse leads, lead sources, counsellor performance, follow-ups, conversions, and revenue.
- Build and maintain daily, weekly, and monthly MIS and business performance reports.
- Perform data cleaning, validation, reconciliation, and standardisation across multiple data sources.
- Identify data discrepancies, missing information, duplicates, and reporting errors.
- Monitor funnel metrics such as Leads → Connects → Counselling → Conversions → Revenue.
- Analyse conversion rates, drop-offs, ageing leads, follow-up performance, and sales productivity.
- Create dashboards and reports that provide clear visibility into business performance.
- Work with Sales, Marketing, Operations, and Management teams to understand data requirements.
- Identify trends, patterns, and anomalies and highlight them proactively to management.
- Support management with data-backed insights and business recommendations.
- Develop and improve reporting systems, trackers, and analytical processes.




- Ensure data accuracy and consistency across CRM, spreadsheets, and internal reporting systems.

What We’re Looking For

- 2-3 years of experience in Business Analytics, Sales Analytics, MIS, Business Intelligence, or a similar role.
- Excellent numerical and analytical ability.
- Advanced Excel / Google Sheets skills — Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, data cleaning, conditional logic, etc.
- Strong understanding of sales funnels, lead management, conversion metrics, and revenue data.
- Solid attention to detail and ability to identify patterns and anomalies in large datasets.
- Comfortable working with large volumes of data and maintaining accuracy.
- Good understanding of dashboards and data visualisation.
- Ability to convert raw data into clear, actionable business insights.
- Strong ownership, speed, and problem-solving ability.
- Excellent communication skills and the ability to present numbers clearly to stakeholders.

Good to Have

- Experience working with CRM / lead management systems.
- Knowledge of SQL, Power BI, Tableau, or similar analytics tools.
- Experience in EdTech, B2C sales, lead generation, or high-volume sales environments.
- Experience in building automated MIS/reporting systems.

The Ideal Candidate

You should be someone who loves working with numbers.

You don't just prepare reports, you understand what the numbers are saying, why they are changing, where the business is losing opportunities, and what should be done next.

If you are highly skilled with data, extremely comfortable with numbers, and can turn messy business data into clear insights and actionable decisions, this role is for you.

📌 Business Analyst (Gurugram)
🏢 iQuanta
📍 Gurugram