Mis Executive

Mamaearth; Gurugram District; On-site; INR 500,000 - 900,000; Full time

Job summary

Mamaearth is seeking a detail-oriented MIS Analyst to independently manage reporting and reconciliation of financial and operational data. You will compile daily, weekly, and monthly MIS reports, ensure data integrity, and coordinate with Finance, Operations, and Sales to meet deadlines.

You will automate reporting processes, develop dashboards and trackers, investigate discrepancies, monitor ageing of unsettled items, and support audits with complete documentation.

Qualifications

• Advanced MS Excel skills including VLOOKUP, XLOOKUP, Pivot Tables, SUMIFS, COUNTIFS, IF formulas.
• Strong knowledge of MIS reporting, data management, and reconciliation.
• Understanding of bank reconciliation and payment reconciliation.
• Good analytical, numerical, and problem-solving skills.
• Experience in preparing dashboards and management reports.
• Knowledge of ERP, accounting software, or financial management systems.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to manage multiple reports and deadlines independently.

Responsibilities

• Prepare, consolidate, analyse, and maintain daily, weekly, and monthly MIS reports covering financial and operational performance.
• Perform daily reconciliation of transactions between internal records, bank statements, payment gateways, sales reports, and third-party platforms.
• Develop and maintain MIS dashboards, reconciliation statements, transaction trackers, and management reports.
• Identify and investigate discrepancies, mismatches, duplicate entries, short payments, excess payments, and pending transactions.
• Coordinate with Finance, Accounts, Operations, Sales, and other departments to resolve reconciliation differences within defined timelines.
• Monitor outstanding transactions and prepare ageing reports to ensure timely follow-up and closure.
• Analyse business data, identify trends, highlight exceptions, and provide meaningful insights to management for decision-making.
• Ensure accuracy and consistency of data across various reporting systems and maintain proper supporting documentation.
• Prepare daily transaction summaries, collection reports, payment reports, and reconciliation status reports.
• Maintain and update MIS databases, trackers, and reporting formats to ensure data integrity.
• Improve reporting and reconciliation processes through automation and standardisation using advanced Excel and other available tools.
• Ensure timely submission of MIS and reconciliation reports as per defined timelines.
• Support internal and external audits by providing reconciliation statements, transaction details, and supporting documents.
• Maintain confidentiality of financial and business information and ensure compliance with company policies and procedures.

Skills

Advanced Excel

MIS reporting

Bank reconciliation

Data analysis

Dashboards

ERP knowledge

Attention to detail

Communication

Deadline management

Tools

ERP systems

Accounting software

Job description

Job Purpose -

To independently manage MIS reporting and reconciliation activities, ensuring accurate data compilation, financial and operational transaction matching, timely reporting, identification of discrepancies, and resolution of outstanding items. The role requires strong analytical skills, attention to detail, and effective coordination with internal and external stakeholders.

Role & responsibilities

1. Prepare, consolidate, analyse, and maintain daily, weekly, and monthly MIS reports covering financial and operational performance.
2. Perform daily reconciliation of transactions between internal records, bank statements, payment gateways, sales reports, and third-party platforms.
3. Develop and maintain MIS dashboards, reconciliation statements, transaction trackers, and management reports.
4. Identify and investigate discrepancies, mismatches, duplicate entries, short payments, excess payments, and pending transactions.
5. Coordinate with Finance, Accounts, Operations, Sales, and other departments to resolve reconciliation differences within defined timelines.
6. Monitor outstanding transactions and prepare ageing reports to ensure timely follow-up and closure.
7. Analyse business data, identify trends, highlight exceptions, and provide meaningful insights to management for decision-making.
8. Ensure accuracy and consistency of data across various reporting systems and maintain proper supporting documentation.
9. Prepare daily transaction summaries, collection reports, payment reports, and reconciliation status reports.
10. Maintain and update MIS databases, trackers, and reporting formats to ensure data integrity.
11. Improve reporting and reconciliation processes through automation and standardisation using advanced Excel and other available tools.
12. Ensure timely submission of MIS and reconciliation reports as per defined timelines.
13. Support internal and external audits by providing reconciliation statements, transaction details, and supporting documents.
14. Maintain confidentiality of financial and business information and ensure compliance with company policies and procedures.

Preferred candidate profile

• Advanced MS Excel (VLOOKUP, XLOOKUP, Pivot Tables, SUMIFS, COUNTIFS, IF formulas).
• Strong knowledge of MIS reporting, data management, and reconciliation.
• Understanding of bank reconciliation and payment reconciliation.
• Good analytical, numerical, and problem-solving skills.
• Experience in preparing dashboards and management reports.
• Knowledge of ERP, accounting software, or financial management systems.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to manage multiple reports and deadlines independently.