Senior Associate – Sales MIS & Reporting
We are looking for an experienced and analytical professional to take ownership of Sales MIS, business reporting, lead management analytics and sales performance tracking.
The individual will develop sales dashboards, analyse sales calling activities, monitor lead allocation and conversions, identify performance gaps and provide actionable business insights to support data-driven decisions.
Key Responsibilities
Sales MIS & Business Reporting: Own daily, weekly and monthly Sales MIS, covering lead generation, allocation, calls, follow-ups, meetings, conversions and revenue performance. Prepare individual and team-level performance reports.
Sales Analytics & Performance Monitoring: Analyse calling patterns, connect ratios, lead engagement, conversion rates and sales funnel movement. Monitor productivity, identify performance gaps and recommend improvements.
Lead Allocation & Funnel Management: Monitor lead allocation, ownership, follow-up status and ageing. Identify duplicate, unattended and inactive leads and ensure accountability across the sales team.
Dashboard Development & Business Intelligence: Develop and maintain interactive Microsoft Power BI dashboards. Integrate CRM, Excel/Google Sheets and other data sources. Automate reporting and provide meaningful business insights.
Advanced Excel & Data Management: Work extensively with Advanced Excel and Google Sheets, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS and Power Query. Manage large datasets, data cleaning and validation.
AI & Reporting Automation: Leverage AI tools such as ChatGPT and Microsoft Copilot for reporting automation, data analysis, trend identification and analytical summaries.
Stakeholder Coordination: Work closely with Sales Executives, Team Leads, Sales Leadership, Marketing and CRM/Technology teams. Present analytical findings and support periodic sales review meetings.
Experience & Qualifications
Bachelor's degree in Business Administration, Commerce, Statistics, Mathematics, Finance or related discipline.
5–8 years of experience in Sales MIS, Sales Analytics, Business Intelligence or Sales Operations.
Strong hands-on experience in Advanced Excel and Power BI, including interactive dashboards and automated MIS reports.
Good understanding of sales funnels, lead management, calling metrics and conversion analysis.
Experience with CRM platforms such as Salesforce, HubSpot or Zoho.
Practical exposure to AI tools such as ChatGPT and Microsoft Copilot for reporting and analytics.
Experience with SQL or other data-querying tools will be an advantage.