The primary purpose of this role is to serve as the analytical core for the General Manager, translating complex business data into clear, decision-ready insights. The Business Analyst will be responsible for producing executive-level reports, building interactive Power BI dashboards, designing high-impact presentations with strong visual storytelling, and automating recurring workflows using Microsoft Power Platform tools. The role demands mastery of the full Microsoft 365 ecosystem and the ability to turn raw data into compelling narratives that drive strategic decisions at the leadership level.

Roles and Responsibilities

• Design and produce executive-level analytical reports for the General Manager, covering performance across all departments, branches, and key business KPIs.

• Build, maintain, and continuously enhance interactive Power BI dashboards that provide real-time visibility into sales, service, aftersales, marketing and operational performance metrics.

• Create visually compelling presentations for the GM using advanced PowerPoint design, storytelling techniques, and structured data narratives that communicate insights clearly to senior leadership.

• Develop and manage advanced Excel models, including dynamic dashboards, complex formulas, pivot tables, and automated reporting tools that support performance tracking and business planning.

• Design, build, and deploy workflow automation solutions using Microsoft Power Automate (MS Flow) and Power Apps to eliminate manual processes, reduce turnaround time, and improve operational efficiency across departments.

• Leverage Microsoft Copilot across the M365 suite to accelerate report generation, extract insights from large datasets, and enhance the quality and speed of analytical outputs for GM-level consumption.

• Collaborate with department heads and team leaders to gather data requirements, understand business context, and ensure all analytical outputs are relevant, accurate, and action oriented.

• Identify and implement automation opportunities for recurring reporting cycles, data consolidation, and approval workflows using Power Automate, Power Apps, and SharePoint integration.

• Ensure adherence & compliance to policies, procedures, BMW QMA & ISO standards, Health & Safety requirements, ethical code of conduct & values.