Mis Executive-Lucknow

Job Description

Job Description: We are seeking an experienced MIS Executive with advanced Excel skills to join our team. The ideal candidate will have a minimum of 3 years of experience working with large datasets, creating complex reports, and developing interactive dashboards. This role is crucial in providing insights to management through detailed analysis and data-driven decision-making. Key Responsibilities: Collect, organize, and analyze large datasets to generate MIS reports. Create and maintain advanced Excel reports, utilizing functions such as VLOOKUP, INDEX-MATCH, PivotTables, and Macros. Design interactive dashboards and visualizations for easy data interpretation. Track key performance indicators (KPIs) and provide actionable insights to stakeholders. Automate reporting processes using Excel to improve efficiency. Ensure data integrity and consistency across reports and dashboards. Collaborate with various departments to understand their data requirements and deliver customized reports. Conduct ad-hoc data analysis and assist with strategic decision-making by presenting data clearly. Monitor and analyze trends to help senior management make informed business decisions. Qualifications: Minimum 3 years of experience in an MIS Executive or similar data-related role. Advanced proficiency in Microsoft Excel, including PivotTables, VLOOKUP, INDEX-MATCH, advanced formulas, and Macros. Strong experience in data analysis, reporting, and dashboard creation. Familiarity with other data visualization tools (e.g., Power BI, Tableau) is a plus. Excellent analytical, problem-solving, and organizational skills. Strong attention to detail and the ability to work with large datasets efficiently. Effective communication skills and ability to present complex data clearly.