MIS Executive

Job Description – MIS ExecutivePosition: MIS Executive

Job SummaryWe are looking for a detail-oriented and analytical MIS Executive with strong Microsoft Excel skills to manage, analyze, and maintain business data. The ideal candidate should be proficient in creating reports, dashboards, and MIS while ensuring data accuracy and timely reporting.

• Key ResponsibilitiesPrepare daily, weekly, and monthly MIS reports.
• Collect, verify, and analyze data from multiple sources.
• Create and maintain Excel dashboards for business tracking.
• Generate reports for management to support decision-making.
• Ensure data accuracy, consistency, and confidentiality.
• Monitor KPIs and identify trends through data analysis.
• Coordinate with different departments to collect required information.
• Automate repetitive reports using advanced Excel features wherever possible.
• Required SkillsExcellent knowledge of Microsoft Excel (Mandatory).
• Strong command of:
• Pivot Tables & Pivot Charts
• VLOOKUP, HLOOKUP, XLOOKUP
• INDEX & MATCH
• IF, IFS, SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• TEXT, LEFT, RIGHT, MID, CONCAT, TEXTJOIN
• IFERROR
• Data Validation
• Conditional Formatting
• Sorting & Filtering
• Remove Duplicates
• Flash Fill
• Advanced Charts & Dashboards
• Knowledge of Power Query and basic VBA/Macros is an added advantage.
• Good analytical and problem-solving skills.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• QualificationsBachelor's degree in Commerce, Business Administration, Computer Applications, or a related field.
• 1–3 years of experience in MIS, Data Analysis, or a similar role preferred.
• Freshers with excellent Excel skills are also encouraged to apply.
• Preferred SkillsKnowledge of Google Sheets.
• Familiarity with Power BI is an added advantage.
• Ability to work under deadlines and handle large datasets efficiently.