Assistant Manager Data Analysis and Reporting

Date: 27 Mar 2025

Location: Karachi

Company: KE

Purpose

To monitor and perform analysis of data extracted from different sources along with gap analysis

Education

BBA

Knowledge

  • Business Analysis and Planning
  • Number Crunching
  • Forecasting
  • Knowledge of relevant SAP Modules and other analysis tools like BEX, Qlick View etc
  • Advance knowledge of MS Office

Experience

2-3 years’ relevant experience

Competencies

Builds High Performance Team > (Value = Respectful / Energized)
Accountable
BUILDS HIGH PERFORMING TEAM > Value (ENERGIZED + RESPECTFUL)
Customer Centric
DRIVES CHANGE > Value (ENERGIZED)
DRIVES RESULTS > Value (CUSTOMER CENTRIC + ENERGIZED)
Energised
INTERNAL & EXTERNAL STAKEHOLDER MANAGEMENT > Value (CUSTOMER CENTRIC + RESPECTFUL)
Leading Change
Leading People
Leading Results
Leading Self
MENTAL AGILITY > Value (ENERGIZED)
Respectful
SELF AWARENESS > Value (ACCOUNTABILITY)
Safe

Area of Responsibilities

Business

Data Reporting:

  • Prepare and analyze daily Sales and Cash reports.
  • Prepare various reports for DGMs, GM & Cluster Office.
  • Prepare summaries/reports of pending SIRs, FMRs, RCDC, D-Loss, Recovery and other relevant reports.
  • Prepare special projects reports i.e. ABC Reporting and coordinate with concerned departments.
  • Ensure monthly reporting of IRB targets/UHC units in coordination with RPR.

Data Analysis:

  • Carry out Complaints Management Analysis.
  • Perform Score Card Analysis on daily basis.
  • Monitor Cycle days wise sales and revenue targets in coordination with CA department.
  • Carry out analysis of HT & LT Mapping and also updating on SAP EDM (Energy Data Management).
  • Perform analysis of unbilled revenue.
  • Analyze feeder and PMT losses.
  • Highlight billing related abnormalities w.r.t. feeders sent out.
  • Analyze data related to back-feeding of feeders and sharing of feeders.

Area of Responsibility Continued

  • Ensure daily sent out reports including timely updation of new feeders.
  • Prepare projections w.r.t. DL & RR as and when required.
  • Perform budget based analysis on the basis of ground realities.
  • Carry out data analysis pertaining to aging wise defaulters with paying slabs

Follow-ups:

  • Ensure follow up on resolution of all pending technical, billing and service tickets as per TATs.
  • Check with CA and RPR about all pending notifications.

Coordination:

  • Coordinate with compliance, Internal audit department, cluster team, RPR, CA, CM, PM and CS teams.
  • Coordinate with all stakeholders as deemed necessary for routine matters and for other issues that may arise from time to time.

Health, Safety & Environment

Ensure that department operates in accordance with health, safety and environmental policies and procedures to ensure the safety and well-being of staff & public.