Job 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.
Similar jobs
- Senior Manager, Financial MIS & Shared Services.Injaz - Corporate Affairs - MIS & Projects.Corporate Affairs
Mashreq · United Arab Emirates
- Assistant Manager – MIS & Reporting
The Kanoo Group · Dubai, United Arab Emirates
- Senior Officer, CCS - MIS & Projects
First Abu Dhabi Bank (FAB) · Abu Dhabi, Abu Dhabi Emirate, United Arab Emirates
- Aftersales Systems Support (MIS) Supervisor | Al-Futtaim Automotive | FAMCO
Al-Futtaim · Dubai, Dubai, United Arab Emirates