Senior MIS Analyst.CXC - RBG - Direct Banking Centre-Egypt COE.Client Experience and Conduct Group-MEGPCOE

🏢 mashreq
📍 EgyptFull-timeOn-site
📅 Posted: 1mo ago🔄 Updated: 1mo ago
CV%
✨ AI Summary
The Senior MIS Analyst & Workforce Management (WFM) role in the Direct Banking Centre-Egypt COE focuses on driving operational efficiency through advanced reporting, automated dashboards, accurate forecasting (including Erlang-C), capacity planning, scheduling, and real-time monitoring across voice and non-voice channels. The responsibilities include developing performance reports, building scorecards, providing KPI reports, automating repetitive tasks using Excel Macros/VBA, Power Query, and SQL, and creating real-time dashboards. The role also involves building interval-level forecasts, preparing staffing plans, creating optimized shift schedules, and monitoring queues and adherence in real-time. Strong technical skills in Excel, Power BI, SQL, and WFM tools are required, along with analytical and communication skills.
Required Skills
Productivity & Workplace Tools
Excel
Information Technology
jQuerySQLPower BIDistributed SystemsIP-CCTV Systems
Other
Erlang-C forecastingErlang-A forecastingdata accuracy
Soft Skills & Professional Competencies
Analytical SkillsStakeholder ManagementCommunicationLeadership
Nice to have:
Other
VerintAvaya
Requirements
Requires a Bachelor's degree and 5-8+ years of experience in MIS & WFM roles within a contact center environment, covering both voice and non-voice channels. Proficiency in advanced Excel (VBA/Macros), Power BI, SQL, and automation tools is essential, along with a strong understanding of Erlang-C/A forecasting models and WFM tools.
Description

Job Description: Lead MIS Analyst & Workforce Management (Voice & 

NonVoice Contact Center) 

 

Role Overview 

The Lead MIS & WFM Analyst will drive operational efficiency through advanced reporting, automated dashboards, accurate forecasting (including Erlang‑C), capacity planning, scheduling, and real-time monitoring across voice and non‑voice channels. The role ensures seamless alignment between workload demand, staffing supply, and SLA expectations. 

Key Responsibilities 

1. MIS, Reporting & Automation 

  • Develop and publish accurate daily/weekly/monthly performance reports. 
  • Build agent/team/process scorecards for voice & non‑voice channels. 

  • Provide SLA, AHT, abandonment, productivity, and quality KPI reports. 
  • Automate repetitive reports using Excel Macros/VBA, Power Query, SQL. 
  • Create real-time automated dashboards for leadership. 
  • Conduct trend analysis, SLA deep-dives, variance analysis, and provide insights. 
  • Maintain data integrity across MIS databases. 

2. Workforce Management (Forecasting, Scheduling & Real-Time) 

Forecasting 

  • Build interval-level forecasts using Erlang‑C/Erlang‑A for voice. 

  • Forecast volumes for email, chat, back-office tasks using workload models. 
  • Create short-term, mid-term, and long-term forecasts. 
  • Conduct what-if analysis and assess seasonal patterns. 

Capacity Planning 

  • Prepare staffing plans with shrinkage, skill mix, channel distribution. 
  • Suggest hiring, training, cross-skilling, overtime requirements. 

Scheduling & Rostering 

 

Classification: Internal Use 

  • Create optimized shift schedules and leave planning. 
  • Ensure staffing adequacy across intervals for all channels. 

Real-Time Monitoring 

  • Monitor queues, adherence, occupancy, SLA delivery. 
  • Coordinate intra-day adjustments with operations. 

Required Technical Skills 

  • Advanced Excel (VBA/Macros), Power BI, SQL. 
  • Automation experience (Power Query, BI refresh, scripting). 
  • Strong knowledge of Erlang‑C, Erlang‑A forecasting models. 

  • Experience with WFM tools such as Verint and Avaya. 
  • Understanding of ACD/IVR systems. 

Soft Skills 

  • Analytical thinking, stakeholder management, communication skills. 
  • Leadership skills and attention to data accuracy. 

Qualifications & Experience 

  • Bachelor’s degree. 

  • 5–8+ years in MIS & WFM roles in a contact center environment. 
  • Experience across both voice and non‑voice channels. 

  • Automation expertise preferred. 

KPIs 

  • Forecast accuracy. 
  • Schedule adherence & staffing efficiency. 
  • SLA performance. 
  • Report accuracy & automation success. 
  • Productivity improvements. 

✨ Premium Match Details
Deep-dive CV analysis, customized Cover Letters, and Interview prep!
📊 Match Analysis
Insights against your active CV
📊
Personalized Match Analysis
Upload your CV to see exact matching percentages, detailed skills mapping, and gap analysis for this role.
🎯 Overalli74%
⚡ Skillsi85%
View Breakdown
Ontology Match: 85.0
Matched:✓ Requirements Matching✓ Ontology Skills Mapping
📜 Eligibilityi49%
View Breakdown
Local: 19600%
🏗️ Career Fiti91%
View Breakdown
Seniority: 91.0
📋 Requirementsi67%
View Breakdown
Domain: 67.0
🔥 Motivationi78%
View Breakdown
Title Fit: 78.00