Requirements
The role requires advanced proficiency in Microsoft Excel (including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, complex formulas), Power Query for data transformation, and Excel Macros/VBA for automation. Strong analytical skills and the ability to manage large datasets under tight deadlines are essential. Experience with Power BI or other data visualization tools is a plus.
Description
Prepare and maintain daily, weekly, and monthly MIS reports for the Planning team. Extract, consolidate, validate, and analyze large volumes of data from multiple sources. Develop and maintain automated reports and dashboards to support business and planning decisions. Use advanced Excel functions, Power Query, and Macros/VBA to streamline reporting processes and reduce manual effort. Support the Planning team with analysis related to sales, inventory, stock movement, sell-through, and other key business KPIs. Ensure accuracy, consistency, and timely availability of all reports and data. Identify opportunities for process improvement and automation within existing reporting mechanisms. Create and maintain standardized reporting formats and databases. Support management presentations and periodic business review reports. Coordinate with cross-functional teams to gather data and fulfill reporting requirements. Advanced proficiency in Microsoft Excel, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, complex formulas, and data analysis. Strong hands-on experience with Power Query for data extraction, transformation, and automation. Knowledge and practical experience in Excel Macros/VBA for report automation. Ability to manage and analyze large datasets efficiently. Experience with Power BI or other data visualization tools will be an added advantage. Strong analytical skills and attention to detail. Ability to work under tight deadlines and manage multiple reporting requirements.