Data Analyst

Role & responsibilities

Reporting & Dashboarding

• Design, automate, and maintain dashboards to track daily shift-wise volumes, operator-level efficiency, and task-type productivity.
• Create and maintain weekly and monthly business review (WBR/MBR) decks with key performance indicators, trends, and insights.
• Build real-time trackers for operations visibility (e.g., work in progress, pending tasks, SLA adherence, etc). Performance Analysis
• Provide detailed performance breakdowns against the key performance parameters (average handling time (AHT), resolution time, accuracy scores, utilization, etc)
• Identify bottlenecks, outliers, and improvement areas using historical and live data. Forecasting & Capacity Planning
• Analyze historical data and maintain forecasting for upcoming volumes and required headcount for new and ongoing projects.
• Support sales and delivery heads with accurate volume projections and hiring recommendations. Ad Hoc & Client Requests
• Respond to urgent, data-driven client queries on volumes, productivity, KPIs, or any other metrics.
• Generate clean, presentation-ready insights for external communication. Process Automation Proactively identify manual or repetitive data processes and automate them using tools like Google Sheets scripts, Power Query, or dashboards. www.mediamint.com
• Maintain well-structured, documented data pipelines and reporting logic for ease of use across the team. Strategic Insights & Value-Add
• Provide leadership with actionable insights from data to help make strategic decisions.
• Suggest new performance metrics, efficiency benchmarks, or custom data views that improve operations.

Preferred candidate profile

• 2-4 years of experience in a data analytics, MIS reporting, or operations analytics role.
• Strong expertise in Google Sheets/Excel, with hands-on experience in pivot tables, VLOOKUP/XLOOKUP, data cleaning, and visualization.
• Proficiency in data visualization and dashboarding using Looker Studio (Data Studio), Power BI, or similar tools.
• Experience in forecasting, trend analysis, and capacity modeling.
• Familiarity with performance operations data such as AHT, TAT, utilization, SLA adherence, etc. Excellent communication skills with the ability to present data clearly to non-technical stakeholders.
• High ownership, self-starter attitude, and ability to work under pressure and tight deadlines. Good to Have:
• Experience in a Digital Marketing / Ad Operations environment or client-facing BPO/operations analytics.
• Prior exposure to MBR/WBR decks for large enterprise clients.
• Knowledge of scripting languages (Google Apps Script, Python) for automating reporting tasks.

What Success Looks Like:

• Operations and leadership teams are no longer bogged down by data/insights generation work.
• On-time creation and completion of the performance review presentations with actionable insights.
• Clear visibility on team performance, task volumes, and SLA adherence through intuitive dashboards.
• Improved planning accuracy and headcount forecasting for future volume projections.
• Reduction in turnaround time for ad hoc client or internal data asks.
• A more proactive, data-driven decision-making culture in the operations team.

Please Fill out the candidate information form: https://shorturl.at/mwpHj