MIS Executive

Hiring: Energy MIS Executive

Location: Lucknow

Experience: 2–5 Years

Salary: ₹25,000 CTC per month

Industry: Telecom Infrastructure

Department: Energy / Operations

Job Summary

We are looking for an experienced Energy MIS Executive with excellent knowledge of MS Excel to manage telecom energy data, prepare MIS reports, analyze fuel and power consumption, and provide data-driven insights to improve energy efficiency.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly Energy MIS reports.

• Track and analyze DG diesel consumption, fuel filling, battery performance, EB/Grid availability, and energy utilization.

• Monitor site-wise and technician-wise fuel consumption and identify abnormal consumption or gaps.

• Prepare fuel variance, diesel reconciliation, energy performance, and exception reports.

• Create and maintain Excel dashboards, trackers, Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, and charts.

• Analyze large datasets to identify trends, discrepancies, leakages, and high-consumption sites.

• Coordinate with Energy Managers, Technical Managers, technicians, and field teams for data validation and issue closure.

• Track DG run hours, fuel efficiency, refueling, theft/shortage cases, and sensor-related discrepancies.

• Ensure timely submission of MIS reports to management and customers.

• Support management with data analysis, presentations, and performance reports.

• Maintain accurate records and ensure data integrity and timely reporting.

Required Skills

• Excellent knowledge of MS Excel is mandatory.

• Advanced Excel: Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF, Conditional Formatting, Charts, Dashboards, Data Validation, and Data Cleaning.

• Strong analytical and problem-solving skills.

• Good understanding of telecom energy/fuel operations.

• Ability to handle and analyze large volumes of data.

• Good communication and coordination skills.

• Strong attention to detail and ability to work within strict reporting timelines.

Preferred

• Experience in telecom tower / O&M / energy management / fuel management.

• Knowledge of Power BI will be an added advantage.

• Experience with telecom MIS platforms preferred.

Interested candidates can apply/share their updated CV.Indeed JD

Job Title: Energy MIS Executive

Location: Lucknow

Experience: 2–5 Years

Salary: ₹25,000 CTC per month

Industry: Telecom Infrastructure

Job Description

We are hiring an Energy MIS Executive with strong MS Excel skills and experience in handling energy/fuel MIS operations. The candidate will be responsible for preparing reports, analyzing fuel and power consumption, maintaining dashboards, and identifying discrepancies in energy data.

Responsibilities

• Prepare daily, weekly, and monthly Energy MIS reports.

• Track DG diesel consumption, fuel filling, battery performance, EB/Grid availability, and energy utilization.

• Monitor site-wise and technician-wise fuel consumption.

• Prepare fuel variance, diesel reconciliation, and exception reports.

• Maintain Excel dashboards, trackers, Pivot Tables, and charts.

• Use VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IF formulas.

• Analyze large datasets and identify discrepancies, leakages, and high-consumption sites.

• Track DG run hours, fuel efficiency, refueling, theft/shortage cases, and sensor discrepancies.

• Coordinate with field and technical teams for data validation.

• Submit timely MIS reports to management and customers.

• Maintain accurate records and data integrity.

Required Skills

• Excellent MS Excel knowledge is mandatory.

• Advanced Excel skills including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, dashboards, charts, data cleaning, and conditional formatting.

• Strong analytical and problem-solving skills.

• Understanding of telecom energy/fuel operations.

• Good communication and coordination skills.

• Ability to manage large volumes of data.

Preferred Experience

• Telecom tower / O&M / Energy Management / Fuel Management.

• Power BI knowledge is an added advantage.

• Experience with telecom MIS platforms.

Pay: ₹20,000.00 - ₹25,000.00 per month

Benefits:

• Provident Fund

Work Location: In person