Job Purpose:

We are looking for a Data & Analytics skilled to manage, analyse and present large-scale IVR and voice survey data. The candidate will work with millions of call records and convert raw call data into meaningful reports, dashboards and actionable insights.

Key Responsibilities:
Analyse millions of IVR call records, survey responses, DTMF responses and call outcomes.
Prepare daily, weekly and monthly MIS and analytics reports.
Work with large datasets using Advanced MS Excel, SQL and databases.
Perform data cleaning, validation, reconciliation, duplicate identification and error analysis.
Create advanced Excel reports and dashboards using:
Pivot Tables & Pivot Charts
XLOOKUP / VLOOKUP
INDEX-MATCH
Advanced Excel formulas
Power Query
Data validation and transformation
Excel dashboards
Write SQL queries to extract, filter, aggregate and analyse large volumes of data.
Analyse IVR metrics such as:
Total calls
Connected / failed calls
Answer rate
Call duration
DTMF responses
Question-wise responses
Campaign-wise performance




Date/time-wise trends
Location-wise analysis
Response percentages
Identify data anomalies, trends and inconsistencies.
Convert raw data into meaningful business insights.Prepare qualified reports, dashboards and PowerPoint presentations.
Create management presentations using charts, graphs, tables and data visualizations.
Understand business/project requirements and convert them into data and reporting requirements.
Coordinate with development, database and operations teams for report and analytics requirements.
Define KPIs, reports, data fields and analytical requirements for current IVR campaigns.
Maintain proper documentation of reports, KPIs, datasets and requirements.

Technical Skills
Advanced MS Excel
SQL / Database
Data analysis and MIS reporting
Advanced PowerPoint / PPT
Data cleaning and reconciliation
Large dataset handling
Dashboard creation
Requ

📌 Ivr Data Hyderabad
🏢 Keyblocks Strategy Consulting
📍 Hyderabad