LION ENVIRO GROUP

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 TitleMIS Executive DepartmentMIS, Reporting & AnalyticsLocation[Lucknow Brgusarai Vararansi]Reporting ToMIS HeadNo. of Positions5Experience 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 industryEmployment TypeFull-timeIndustryMunicipal Solid Waste Management / Environmental Services/CompensationAs per Industry NormsNotice Period PreferredImmediate to 15 days1. 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, then convert it step by step to semi-automated and finally to fully automated generation using advanced formulas, Power Query, VBA / macros and scheduled templates. Reduction in manual effort hours is a measurable deliverable of this role.

¢ 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 works, service, concession, facility management or similar is mandatory for this position. Candidates with MIS experience but no billing exposure will not be considered.

¢ Demonstrated experience of building the justification and supporting data pack for a bill, and of defending billed quantities against a client or consultant query with documentary evidence.

¢ Understanding of how a deduction or disallowance arises, what documentation rebuts it, and how a reply is to be framed factual, clause-referenced and defensible rather than argumentative.

¢ Familiarity with billing in a government, municipal or public-sector environment, where formats are prescribed and certification passes through an external consultant or authority, will be a strong advantage.

4. TECHNICAL SKILLS MANDATORY

4.1 Advanced Microsoft Excel

¢ Advanced formulas: INDEX-MATCH, XLOOKUP / VLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, nested IF / IFS, AND-OR logic, text and date functions, error handling (IFERROR, IFNA), and array / dynamic array formulas.

¢ Pivot Tables, Pivot Charts, slicers, grouping and calculated fields.

¢ Power Query for data import, transformation, append and merge operations (essential for multi-source consolidation).

¢ Data validation, conditional formatting, named ranges, sheet and workbook protection, and structured tables.

¢ Dashboard and chart building for management reporting.

4.2 VBA and Macros

¢ Writing, reading and debugging VBA code variables, loops, conditional logic, ranges and worksheet objects.

¢ Recording, editing and optimising macros to automate repetitive report generation, formatting and consolidation.

¢ Automating file handling opening, merging and splitting workbooks, exporting to PDF, and automated report dispatch.

¢ User forms and simple input interfaces (preferred).

4.3 Supporting Tools

¢ Google Sheets at the same functional level as Excel (Optional), including shared-drive based collaborative reporting; Google Apps Script is an added advantage.

¢ MS Word and PowerPoint for report packaging and management presentations.

¢ Power BI, SQL basics or Python for data handling preferred, not mandatory.

5. ANALYTICAL AND PROBLEM-SOLVING REQUIREMENTS

This is the defining requirement of the position. Technical tool knowledge alone will not qualify a candidate.

¢ Reasoning ability. The role requires a candidate who understands why a number behaves the way it does. Candidates who can only operate a pre-built template will not be suitable.

¢ Speed with parallel load. Ability to carry three to five reporting deliverables concurrently within a single working day and close each within its own deadline, without quality drop.

¢ Solution orientation. On encountering an unfamiliar problem, the incumbent is expected to break it down, test approaches, and arrive at a working solution within a short cycle rather than wait for direction.

¢ Estimation and gap management. Ability to keep a reporting cycle running when field data is delayed by deriving a defensible provisional figure from available trends and baselines, stating the assumption in writing, and marking it as an estimate for later replacement with actuals.

¢ Accuracy discipline. Self-checking habit, reconciliation before release, and immediate disclosure of any error found in a previously issued report.

6. USE OF AI TOOLS

¢ Effective use of AI tools (ChatGPT, Claude, Microsoft Copilot or equivalent) to solve technical problems that fall outside the incumbents existing knowledge for example generating or debugging a formula or VBA routine, structuring an unfamiliar calculation, or identifying a faster approach.

¢ Every AI-assisted output must be independently tested and verified against known data before it is used in a live report. AI output is treated as a draft, never as a validated result.

¢ Project, client and contract-sensitive data must not be uploaded to public AI platforms. AI assistance is to be sought on method,



logic and code not by sharing confidential datasets. Candidates should be able to demonstrate an understanding of this distinction.

7. AUTOMATION MANDATE The position carries an explicit expectation of progressive automation. The incumbent is required to:

¢ Build each new reporting process from scratch and 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.

Reduction in manual reporting effort is a measurable key performance area for this role and will form part of the annual review.

8. BEHAVIOURAL REQUIREMENTS

¢ Discipline. Punctuality, adherence to reporting timelines, and consistency of output are non-negotiable in this role.

¢ Qualified conduct. Measured written and verbal communication, appropriate handling of internal escalations, and professional bearing in interactions with management, government officials and external agencies.

¢ Teamwork. Ability to work within a reporting team sharing formats and logic, covering for colleagues, supporting juniors, and coordinating with operations staff who are not data specialists. This role cannot be performed in isolation.

¢ Ownership. Accepts responsibility for the report end to end, including chasing inputs that are outside the incumbents direct control.

¢ Confidentiality. Strict handling of project, contractual, financial and workforce data.

9. WORKING CONDITIONS

¢ This role supports municipal solid waste management operations, which are classified as essential public services and run seven days a week, including public holidays.

¢ The weekly off is rotational and may require rescheduling at short notice based on operational and reporting requirements; compensatory off will be provided in accordance with applicable law and company policy. Candidates unable to work with a rotational and reschedulable weekly off should not apply.

¢ On a weekly off, the incumbent may be required to release one or two time-critical reports, or alternatively to coordinate with a colleague and ensure the report is released by the team. Continuity of reporting is the incumbents responsibility and is expected to be planned for in advance through documented handover, ready templates and shared access.

¢ Reporting load peaks at month-end, quarter-end and during audit or review cycles; extended hours may be required during these windows.

¢ Occasional field visits within the project area may be required to verify data at source.

10. LOCATION AND DEPLOYMENT REQUIREMENTS

¢ Depending on the size of the operation, the incumbent may be the sole MIS resource at the location or part of a reporting team. In either case the position requires the ability to work independently on daily output and to coordinate closely with operations and field staff who are not data specialists.

¢ Where the incumbent is the sole MIS resource, reporting continuity during weekly off, leave and travel must be planned in advance through documented handover notes, ready-to-run templates, shared file access and a named backup.

¢ Where the incumbent is part of a team, formats and formula logic must be shared openly with colleagues, and the incumbent must be able to take over a colleagues reporting at short notice during leave or peak load.

¢ Field data at project locations is frequently late, inconsistent or received in non-standard formats. The ability to standardise inputs at source by fixing formats, defining codes and training field users rather than repeatedly correcting data at the reporting end, is central to this role.

¢ Occasional field visits within the project area may be required to verify data at source. Willingness to relocate to, or travel within, the project area as required is a condition of employment.

¢ Candidates currently based at or near [LOCATION], or willing to relocate at their own arrangement, will be preferred. Working proficiency in Hindi is essential for field coordination.

11. QUALIFICATION AND LANGUAGE

¢ Graduate in any discipline; B.Com, BBA, BCA, B.Sc (Statistics / Mathematics / Computer Science) or B. Tech preferred. Post-graduate qualification is an advantage.

¢ Certification in Advanced Excel, VBA, Data Analytics or Power BI is an advantage.

¢ Working proficiency in Hindi and English, including the ability to draft clear report notes and email communication in English.

12. SELECTION PROCESS

¢ Stage 1 Screening of the CV, followed by a short telephonic discussion to confirm experience, billing exposure, location and availability.

¢ Stage 2 Written Analytical and Expertise Assessment, conducted at the interview venue. Ninety minutes, closed book, no calculator or mobile phone. The paper covers data reconciliation, calculation design, Excel formula construction, automation approach, billing justification, and reporting judgement.

¢ Stage 3 Practical assessment on a computer: Advanced Excel, a live reconciliation and calculation exercise, and a VBA / macro task.

¢ Stage 4 Application Questionnaire, completed at the interview stage, followed by a technical and situational interview with the MIS Head in which the candidates own cited examples are examined.

¢ Stage 5 Final discussion on terms, followed by reference and document verification.

Contact no-(phone hidden), Email id [email protected]

📌 Mis Executive (Begusarai)
🏢 Lion Security
📍 Begusarai