MIS Executive/ Data Analyst : (North Delhi Candidates Needs To Apply)

MIS Executive/ Data Analyst : (North Delhi candidates needs to apply)

Company Name: Delhi Watch Marketing Pvt. Ltd., Sant Nagar, Burari, Delhi

Website: www.zanibo.com

Experience: 2–3 Years

Salary: Up to ₹25000 to ₹30,000/month

Key Responsibilities

• Generate and manage daily, weekly, and monthly MIS reports to support business decision-making.
• Analyze data trends and prepare insightful dashboards and reports for management.
• Maintain and update large datasets using Excel and Google Sheets with high accuracy.
• Apply advanced formulas such as VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, and IFERROR for data analysis.
• Ensure data accuracy, validation, and error identification across reports.
• Coordinate with multiple departments to collect, verify, and consolidate data.
• Develop and maintain automated reports and dashboards wherever possible.
• Manage and organize company databases, ensuring data integrity and accessibility.
• Create professional reports, presentations, dashboards, and visual summaries using Canva for management and internal communication.
• Convert complex data into easy-to-understand visual reports and presentations using Excel and Canva.

Requirements

• Strong working knowledge of MS Excel and Google Sheets.
• Good understanding of data analysis, reporting, and dashboard creation.
• Hands-on experience with Pivot Tables, charts, advanced formulas, and logical functions.
• Good knowledge of Canva for creating professional presentations, reports, and visual dashboards.
• Basic knowledge of Macros / VBA / Google Apps Script (preferred).
• Experience with Power Query will be an added advantage.

Key Skills

• Strong analytical and problem-solving skills.
• High attention to detail and accuracy.
• Good time management and organizational skills.
• Ability to handle large datasets efficiently.
• Effective communication and coordination skills.
• Ability to present data in a clear, professional, and visually appealing manner.
• Good Excel + Canva presentation skills.