Assistant FP&A Manager

Job Overview

We are seeking an Assistant FP&A Manager responsible for creating and refining Power BI dashboards and automating financial management reports. This role demands building and maintaining comprehensive financial and operational data models, utilizing SQL and DAX to enhance Power BI reporting solutions. The candidate will streamline manual reporting processes, pinpoint opportunities for FP&A process enhancements, and drive digital innovation within the function.

Key Responsibilities

• Develop and enhance Power BI dashboards along with automated management reporting tools.
• Build and sustain robust financial and operational data models using SQL, DAX, and Power BI.
• Automate reporting tasks and identify process improvements to advance FP&A digital transformation.
• Coordinate the preparation of annual budgets, forecasts, and long-term financial plans.
• Conduct monthly variance analysis comparing actuals, budgets, forecasts, and prior-year data, identifying key business drivers.
• Analyze sales performance across business units, brands, branches, products, and customers.
• Evaluate revenue, sales volume, average selling price (ASP), gross profit margins, discounts, and product mix to uncover trends and business opportunities.
• Prepare profit & loss and profitability analyses segmented by business units, branches, and product lines.
• Produce Flash reports, monthly management reports, and dashboards for executive performance monitoring.
• Track key financial and operational KPIs, flagging risks, opportunities, and proposing corrective measures.
• Support various business units with detailed financial analysis, commercial insights, and decision-making assistance.
• Create financial models including scenario planning and sensitivity analyses for strategic decision support.
• Verify the accuracy, consistency, and reconciliation of financial and operational data utilized in management reports.
• Collaborate cross-functionally with Sales, Operations, Procurement, HR, and Finance teams to understand business performance and drivers.
• Provide ad-hoc financial analysis and management insights as needed.
• Continuously enhance FP&A reporting to transform from data delivery to actionable business intelligence.
• Lead AI-driven transformation efforts by identifying and implementing AI applications to improve reporting, forecasting, variance analysis, data interpretation, and insight generation.
• Utilize AI technologies to automate repetitive FP&A tasks, augment analytics capabilities, and elevate decision-making efficiency and quality.
• Explore and deploy AI-powered forecasting methods, predictive analytics, and intelligent management reporting tools.

Qualifications and Experience

• Professional certification such as CA, ACCA, or CMA is required.
• Minimum of 7 years of relevant experience in Financial Planning and Analysis.
• Proficiency with SAP, Power BI, SQL, SAP Analytics Cloud, advanced Excel functions, and financial modeling techniques.