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
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.