MIS Executive and Analyst

Batra Art Press; Delhi Cantonment; On-site; INR 335,000 - 670,000; Full time

Job summary

Batra Art Press in Delhi seeks a skilled MIS/Reporting Specialist to manage daily sales, stock, and KPI reporting using advanced Excel techniques. You will develop and maintain inventory records, coordinate timely report submission, and support data-driven decision making.

Responsibilities include using pivot tables to analyze large datasets, generating stakeholder-friendly insights, and driving continuous improvements in reporting processes within a collaborative team environment.

Qualifications

• Proficiency in advanced Excel functions: HLOOKUP, VLOOKUP, COUNTIF, SUMIF, Conditional Formatting.
• Strong KPI reporting and data analysis abilities.
• Experience in creating and using pivot tables for large datasets.

Responsibilities

• Prepare daily reports on sales, stock, and KPIs using advanced Excel skills.
• Manage MIS operations by coordinating with team members to ensure timely report generation and submission.
• Develop and maintain accurate records of inventory levels through effective stock management practices.
• Utilize pivot tables to analyze large datasets and generate insightful reports for stakeholders.
• Collaborate with the team to identify areas of improvement in reporting processes.

Skills

Advanced Excel

KPI reporting

Pivot tables

Tools

Microsoft Excel

Job description

Roles and Responsibilities

• Prepare daily reports on sales, stock, and other key performance indicators (KPIs) using advanced Excel skills such as HLOOKUP, VLOOKUP, COUNTIF, SUMIF, Conditional Formatting, Charts, Lookup, Pivot Tables, and Formulas.
  
• Manage MIS operations by coordinating with team members to ensure timely report generation and submission.
  
• Develop and maintain accurate records of inventory levels through effective stock management practices.
  
• Utilize pivot tables to analyze large datasets and generate insightful reports for stakeholders.
  
• Collaborate with the team to identify areas of improvement in reporting processes.