JOB TITLE: MIS EXECUTIVE AND FOUNDER’S OFFICE COORDINATOR

Company: Pavitra India Waste Management Pvt. Ltd.

Location: Kanpur, Uttar Pradesh

WhatsApp No. (phone hidden)

Job Type: Full-time, On-site

Department: Founder’s Office / MIS

Reporting To: Founder / CEO

Experience Required: 2-5 Years

Salary: Based on experience and technical suitability

JOB SUMMARY

We are looking for a responsible and technically capable MIS Executive and Founder’s Office Coordinator who can directly support the Founder in management reporting, task tracking, departmental coordination and data-based decision-making.

The candidate should have practical knowledge of Advanced Excel, ERP, Power BI, MIS reporting and AI productivity tools. The role requires solid follow-up, confidentiality, accuracy and the ability to convert management instructions into tracked and completed actions.

This is not a basic data-entry or personal-assistant role. The selected candidate will coordinate with Plant Operations, Accounts, Purchase, Inventory, Dispatch, HR, Vendors and Management.

KEY RESPONSIBILITIES

- MIS and Management Reporting
- Prepare Daily, Weekly and Monthly MIS reports.
- Compile reports covering production, raw material, inventory, purchase, sales, dispatch, expenses, outstanding payments, manpower and vendor status.
- Prepare Target vs Actual, department performance and exception reports.
- Verify data accuracy before submitting reports to the Founder.
- Reconcile figures received from different departments and highlight mismatches, missing entries and unusual variations.
- Convert raw departmental data into short, clear and decision-ready management summaries.
- Founder’s Office Coordination
- Maintain a central tracker for all tasks and instructions given by the Founder.
- Record task owner, assigned date, priority, deadline, current status, dependency and next action.
- Follow up with department heads, employees, vendors and consultants until work is completed and verified.
- Prepare meeting agendas, minutes of meetings and action points.
- Coordinate the Founder’s meetings, appointments, official correspondence, documents and follow-ups.
- Escalate overdue, critical or unresolved tasks with a clear status summary.
- Maintain complete confidentiality of business, financial, employee and management information.
- ERP and Data Management
- Collect,



check and update data in the company’s ERP or other management systems.
- Monitor missing, delayed or incorrect ERP entries.
- Coordinate with users for data correction, master-data updates and closure of ERP issues.
- Maintain an ERP issue tracker covering the problem, responsible person, target date and resolution status.
- Ensure that ERP data matches physical inventory, production, purchase, sales and dispatch records.
- Advanced Excel and Power BI
- Create and maintain Excel-based MIS formats, trackers and dashboards.
- Use functions and tools such as XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS, IF, Pivot Tables, Slicers, Conditional Formatting and Data Validation.
- Use Power Query for data cleaning and consolidation.
- Create Power BI dashboards for management review.
- Manage data relationships, KPI calculations, filters, visuals and dashboard refresh.
- Ensure that dashboard figures are reconciled with the original data source.
- Departmental Coordination
- Collect reports from Plant Operations, Accounts, Purchase, Stores, HR and Dispatch within defined timelines.
- Maintain department-wise reporting calendars and pending-report trackers.
- Follow up on purchase requirements, vendor commitments, stock shortages, dispatches, receivables and important approvals.
- Coordinate between office and plant teams to ensure timely information flow.
- Ensure that no important task depends only on verbal communication, memory or WhatsApp messages.
- AI and Office Automation
- Use approved AI tools for email drafting, meeting summaries, document comparison, structured data extraction and report preparation.
- Identify repetitive office and MIS activities that can be automated.
- Verify all AI-generated output before use.
- Never upload confidential company, employee, customer or commercial information to unauthorised public tools.
- Documentation and Record Control
- Maintain systematic digital records of reports, meetings, approvals, correspondence and management instructions.




- Ensure proper file naming, version control, backups and easy retrieval.
- Prepare presentations, comparative statements, review notes and management documents when required.

REQUIRED QUALIFICATION
- Graduate or postgraduate in Commerce, Management, IT, Computer Applications, Engineering or a related field.
- Candidates with MBA, BBA, B.Com, M.Com, BCA, MCA or B.Tech qualifications may apply.

REQUIRED EXPERIENCE AND SKILLS
- 2-5 years of experience in MIS, management reporting, business coordination, ERP reporting or Founder’s Office support.
- Strong practical knowledge of Advanced Excel.
- Hands-on experience with ERP and data reconciliation.
- Working knowledge of Power BI and dashboard preparation.
- Good written and verbal communication in Hindi and English.
- Strong follow-up, documentation and task-closing ability.
- Ability to coordinate with multiple departments and senior management.
- High accuracy, confidentiality and ownership.

PREFERRED EXPERIENCE
- Experience in a manufacturing plant, recycling company, process industry or industrial organisation.
- Experience preparing production, inventory, purchase, sales or dispatch MIS.
- Exposure to Power Query, basic DAX, automation or approved AI tools.
- Experience working directly with a Founder, CEO or senior management.

KEY PERFORMANCE EXPECTATIONS
- Accurate and timely Daily, Weekly and Monthly MIS.
- Reduction in reporting errors and data mismatches.
- Timely closure of Founder-assigned tasks.
- Complete and updated action trackers.
- Accurate ERP and dashboard data.
- Timely departmental reports and escalations.
- Proper meeting minutes and follow-up records.
- Confidentiality and organised document control.

APPLICATION SCREENING DETAILS

Candidates should mention

- Current location
- Current designation
- Total MIS experience
- Advanced Excel functions used practically
- ERP software experience
- Power BI dashboard experience
- Experience working with senior management or Founder’s Office
- Current and expected salary
- Notice period

IMPORTANT Candidates with only basic Excel, data-entry or personal-assistant experience without practical MIS, ERP, Power BI and management-reporting knowledge may not be suitable for this position.

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

Work Location: In person

📌 MIS EXECUTIVE AND FOUNDER’S OFFICE COORDINATOR (Kanpur)
🏢 Pavitra India
📍 Kanpur