Job Description: MIS Executive
We are looking for a detail-oriented MIS Executive with advanced Excel skills, Google Sheets expertise, Power Queries, and Range Look-up knowledge: to join in Bahadurgarh Haryana. The ideal candidate should have at least 3 years of experience in data analysis, reporting, and MIS management. This role requires strong analytical skills and the ability to work with large datasets to generate insightful reports for business decision-making.
Key Responsibilities:
- Develop and maintain MIS reports, dashboards, and data analysis using Excel, Google Sheets, and Power Query.
- Work with VLOOKUP, HLOOKUP, Index-Match, Pivot Tables, Power Queries, and Macros to organize and interpret data.
- Automate reporting processes to improve efficiency and accuracy.
- Analyze large datasets to provide valuable insights for business operations.
- Collaborate with different departments to generate accurate and timely reports.
- Ensure data accuracy and integrity by cleaning, formatting, and validating datasets.
- Support management with ad-hoc reports and data visualization for business insights.
- Maintain and update databases to track key performance metrics.
Requirements:
- Graduate
- Minimum 3 years of experience in MIS reporting, data analysis, or business intelligence.
- Expertise in Advanced Excel (Power Query, VLOOKUP, HLOOKUP, Pivot Tables, Macros, etc.).
- Strong knowledge of Google Sheets and automation tools.
- Ability to handle large datasets efficiently and generate meaningful insights.
- Experience in working with Power BI or SQL is a plus.
- Strong problem-solving and analytical skills.
- Excellent attention to detail and ability to meet deadlines.
- Knowledge of automation scripts (VBA, Google App Scripts) is an advantage.