Mis Executive

Job Summary: We are seeking an experienced and detail-oriented MIS Executive to manage and streamline our management information systems. The ideal candidate will have a strong background in Excel (including advanced functions, Macros, and Pivot Tables), Power BI, and data visualization tools. You will be responsible for data management, reporting, analysis, and creating dashboards to support decision-making processes across departments. Key Responsibilities: Develop, maintain, and automate MIS reports and dashboards using Excel, Power BI, and other tools . Create and manage Pivot Tables, Pivot Charts , and Macros to analyze large datasets effectively. Use Advanced Excel functions (VLOOKUP, HLOOKUP, INDEX-MATCH, nested IFs, conditional formatting, etc.) for data manipulation and reporting. Develop and publish interactive dashboards in Power BI to visualize performance metrics and KPIs. Perform regular audits of data for accuracy, completeness, and consistency. Collaborate with cross-functional teams to gather data and reporting requirements. Provide support in automating routine processes and enhancing existing MIS frameworks. Monitor performance trends and generate actionable insights to support strategic planning. Ensure timely delivery of daily, weekly, and monthly MIS reports. Required Skills & Qualifications: Minimum 3 years of experience in an MIS Executive or similar role. Proficient in Microsoft Excel (including Advanced Excel features, Macros, Pivot Tables & Charts). Hands-on experience in Power BI (data modeling, DAX, report publishing, and dashboarding). Strong analytical and problem-solving skills. Knowledge of basic SQL (optional but preferred). Excellent communication and presentation skills. Ability to manage multiple tasks and deadlines in a fast-paced environment. Bachelors degree in Computer Science, Information Systems, Business Administration, or related field.