Sr. MIS Executive

MACOM; New Delhi; On-site; INR 500,000 - 700,000; Full time

Job summary

MACOM in Delhi, India is seeking a skilled MIS and analytics professional to design and automate reporting processes. The role focuses on building dashboards, data models, and reliable data pipelines to support management decisions.

You will collaborate with multiple departments, maintain data integrity, and generate actionable insights from daily, weekly, and monthly reports. Proficiency in Excel and Google Sheets is essential, with automation using macros and pivot tables.

Qualifications

• Experience creating MIS reports for business requirements.
• Ability to transform data into actionable insights for management.
• Proficiency in building dashboards and trackers to monitor KPIs.

Responsibilities

• Prepare, maintain, and update MIS reports monthly/weekly/daily as required.
• Develop dashboards, trackers, and data models in Advanced Excel & Google Sheets.
• Perform data cleaning, validation, and analysis for accurate reporting.
• Automate reports using advanced formulas, pivot tables, macros, and charts.
• Collaborate with departments to gather and consolidate data.
• Generate actionable insights to support management decisions.
• Maintain confidentiality, accuracy, and integrity of company data.

Skills

Advanced Excel

Data analysis

Data visualization

Cross-functional collaboration

Tools

Excel

Google Sheets

Macros

Pivot tables

Job description

• 1. Prepare, maintain, and update daily/weekly/monthly MIS reports as per business requirements.
• 2. Develop dashboards, trackers, and data models in Advanced Excel & Google Sheets.
• 3. Perform data cleaning, validation, and analysis for accurate reporting.
• 4. Automate reports using advanced formulas, pivot tables, macros, and charts.
• 5. Collaborate with different departments to gather and consolidate data.
• 6. Generate actionable insights to support management in decision-making.
• 7. Maintain confidentiality, accuracy, and integrity of company data.