Mis Executive

Lion Security; Varanasi, Lucknow, Begusarai; On-site; INR 420,000 - 640,000; Full time

Job summary

The MIS Executive role is based across Lucknow, Varanasi and Begusarai, handling MIS and reporting for project locations. You will design calculation logic, build reporting tools, automate processes, and ensure monthly billing is backed by validated data and proper documentation.

You will own end-to-end reporting and billing, coordinating with operations and accounts to maintain accuracy, timeliness and audit-ready records, while driving progressive automation wherever feasible.

Qualifications

• 3–6 years in MIS / data analytics / operations reporting.
• Hands-on experience with monthly billing against a contract (minimum 2 years).
• Preference for experience in waste management, facility management, logistics or related field-operations-driven industries.

Responsibilities

• Prepare, validate and release periodic MIS reports for the project within timelines.
• Collect, clean and consolidate raw data from multiple sources and reconcile discrepancies.
• Design, build and maintain report templates, dashboards and formula logic from scratch.
• Progress from manual reporting to automation using macros, Power Query and templates.
• Support billing with justification and data packs to ensure traceability of figures.

Skills

Billing

MIS reporting

Data analytics

Operations reporting

Tools

Power Query

Excel

Macros

Job description

LION ENVIRO GROUP
JOB DESCRIPTION
MIS Executive- [Lucknow Varanasi Begusarai]

Do you have at least 2 years of hands-on experience in monthly contract billing? If yes, please mention the type of contract/project and your role in billing.

Position Title MIS Executive Department MIS, Reporting & Analytics Location [Lucknow Brgusarai Vararansi] Reporting To MIS Head No. of Positions 5 Experience Required [3] [6] years in MIS / data analytics/operations reporting, of which a minimum of [2] years must include hands-on monthly billing against a contract. Preference for solid waste management, facility management, logistics, infrastructure or another field-operations-driven industry Employment Type Full-time Industry Municipal Solid Waste Management / Environmental Services/ Compensation As per Industry Norms Notice Period Preferred Immediate to 15 days

1. POSITION OVERVIEW

The position is based in Lucknow/Varanasi/Begusarai and is responsible for the MIS and reporting function for the project location. The incumbent will follow the formats, standards, and submission calendar set by the MIS Head and ensure every report is accurate, timely, and continuous. The role is not confined to operating a ready-made template. The incumbent is expected to design the calculation logic, build the reporting tools, identify and close reporting failures, and progressively convert manual reporting into an automated system. Candidates able only to fill a pre-built format will not be suitable for this position. The position also carries direct responsibility for monthly billing and its supporting justification. Reporting and billing are treated as one continuous function in this organisation: the figures reported through MIS during a month are the figures that must support the bill raised at the end of it, and the incumbent is accountable for that consistency.

2. KEY RESPONSIBILITIES

Prepare, validate and release all periodic MIS reports for the project within committed timelines daily, fortnightly, monthly and any other frequency prescribed, including weekly where a client or authority requires it covering waste collection and transportation, workforce deployment and attendance, vehicle and equipment utilisation, ward-level coverage, grievance redressal and contractual performance formats.

Collect, clean and consolidate raw operational data received from multiple sources field supervisors, ward registers, attendance systems, weighbridge records, vehicle tracking data, complaint registers and reconcile discrepancies between them before publishing any number.

Perform complex, multi-variable computations independently: coverage and compliance percentages, trip efficiency, tonnage reconciliation, manpower deployment ratios, weighted performance scoring, variance and trend analysis. The role owns the calculation logic, not merely its execution.

• Design, build and maintain report templates, trackers and dashboards from scratch including formula architecture, data validation, error trapping and protected input sheets so that outputs are repeatable and audit-traceable.
• Identify data gaps and process failures proactively. Where primary field data is delayed or incomplete, prepare a defensible working estimate using trend analysis, historical baselines or a documented derivation method; clearly label estimated figures as provisional, record the assumption used, and substitute actuals immediately on receipt. Under no circumstances is an unmarked estimate to be presented as a verified actual.
• Diagnose reporting and reconciliation problems to root cause and close them the expectation is that the incumbent identifies the issue, evaluates options, arrives at a workable solution and implements it, escalating with a recommendation rather than only with a problem.
• Drive progressive automation of the reporting function: build the process manually, stabilise it manually so that the underlying logic is fully understood.
• Convert the stabilised process to a semi-automated form formula-driven templates, Power Query refresh, standardised input sheets within an agreed timeframe.
• Progress the process to full automation using macros, scheduled routines and automated dispatch wherever technically feasible.
• Maintain an automation tracker recording, for each report, the current stage of automation, the manual hours consumed and the target reduction.
• Coordinate with operations, HR, accounts, Workshop and field teams to secure inputs on time, standardise submission formats at source, and train field users on data entry discipline.
• Maintain version control and documentation for every report format, formula logic and SOP, so that any report can be reconstructed and defended at a later date.
• Support management with ad-hoc analysis, comparative statements, presentations and data packs at short notice.

3. BILLING AND COMMERCIAL REPORTING

Billing is a core deliverable of this position, not an adjunct to it. The incumbent is required to:

• Prepare the monthly bill for the project in the prescribed format computing billable quantities and amounts from validated operational data and the applicable contractual rates, and releasing the bill within the contractual submission timeline.
• Assemble the complete justification and supporting data pack that accompanies the bill measurement and weighbridge records, vehicle trip records, workforce attendance and deployment statements, ward-level coverage data, fuel and equipment logs, statutory compliance proofs and any prescribed annexures such that every figure appearing in the bill is traceable to a primary record.
• Ensure exact reconciliation between the bill and the MIS reports already submitted for the same period. Where a variance exists it must be identified before submission, explained in writing, and not left to be discovered by the client or its consultant.
• Compute performance-linked, deduction-linked or incentive-linked amounts where the contract provides for them, and retain the complete workings in a form that can be re-derived and defended months later.
• Maintain rate escalation or price-adjustment computations where applicable, with the underlying index, base data and source references kept on record.
• Handle queries, observations, disallowances and deductions raised on the bill by the client, the authority or its appointed consultant locating the underlying records, preparing a written and data-backed reply within the prescribed period, and tracking each item through to closure.
• Maintain a running reconciliation of billed, certified, deducted, recovered and received amounts, with a live statement of outstanding items and the status of each pending claim or dispute.
• Keep the billing file audit-ready at all times every claim supported, every workbook version-controlled, and every document retrievable on demand for audit, review or dispute proceedings.
• Coordinate with accounts, operations, stores and HR to obtain billing inputs on time, and with accounts for dispatch, acknowledgement and follow-up of the submitted bill.

3.1 Billing Experience Mandatory

• Hands‑on experience of preparing or handling monthly billing against a contract