Executive - MIS

Apparel Group; Dubai; On-site; AED 134,000 - 201,000; Full time

Job summary

Apparel Group is seeking a Data & Reporting Analyst to drive robust reporting and data-driven decision making. You will prepare daily to monthly MIS reports for the Planning team, extract data from multiple sources, and build automated dashboards to support sales, inventory and KPI reviews.

The role emphasizes advanced Excel (Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH), Power Query for data transformation, and VBA for automation, with Power BI experience considered a plus.

Qualifications

• Experience with Excel: Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, complex formulas and data analysis.
• Proficient in Power Query for data extraction, transformation and automation.
• Experience with Excel Macros/VBA for report automation.
• Strong analytical skills and meticulous attention to detail.
• Ability to manage multiple reporting requirements under tight deadlines.
• Familiarity with Power BI or similar data visualization tools is a plus.

Responsibilities

• Prepare and maintain MIS reports for Planning on daily, weekly, and monthly cadences.
• Extract, consolidate, validate and analyze large data sets from multiple sources.
• Develop automated reports and dashboards to support planning decisions.
• Utilize advanced Excel functions and Macros to streamline reporting and reduce manual effort.
• Support analysis of sales, inventory, stock movement, and key KPIs.
• Ensure accuracy and timely availability of all reports and data.
• Identify opportunities to improve and automate reporting processes.
• Create standardized reporting formats and databases.
• Support management presentations and periodic business reviews.
• Coordinate with cross-functional teams to gather data and satisfy reporting requirements.

Skills

Advanced Excel

Power Query

VBA/Macros

Pivot Tables

XLOOKUP/VLOOKUP

Index-Match

Complex Formulas

Data Analysis

Power BI

Attention to detail

Deadline-driven

Cross-functional collaboration

Tools

Power BI

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.