Job Description

Key Responsibilities:

-------------------------



FP A Manager Client Engagement Responsibilities Manage operational activities through managers and team leads ensuring accuracy timeliness and actionable insight in all financial deliverables Manage execution and resolve operational deficiencies with a hands on analytical approach using Excel based dashboards and variance models Build and sustain a trusted business relationship with Client by interpreting large data sets identifying financial trends and recommending actions Develop interpret and present Management Information MI including P L bridges volume mix price analysis cost variance reports and rolling forecasts using advanced Excel and visualization tools Use Excel Power Query and Power Pivot to connect multiple data sources transform raw data and create self refreshing models that feed into Power BI or executive dashboards Create dynamic scenario models and driver based forecasts using tools like Data Tables Goal Seek Scenario Manager and sensitivity analysis techniques Ensure KPI and SLA compliance by building trend dashboards with automated variance commentary using functions like INDEX MATCH OFFSET and dynamic named ranges Support process improvement and automation by designing macros VBA where applicable to streamline repetitive FP A activities such as report refreshes and reconciliations Collaborate with business stakeholders to ensure finance analytics and MI reports align with operational and strategic decision making Qualifications Skills Education CA MBA Finance from reputed B School or equivalent qualification CMA CPA preferred Experience 12 14 years in FP A management reporting and financial analysis preferably in retail or consumer facing industries Technical Skills Excel and Analytics Excel Advanced Functions INDEX MATCH XLOOKUP SUMIFS INDIRECT OFFSET TEXT DATE functions dynamic arrays and nested IFs Data Modeling Automation Power Query data transformation Power Pivot data modeling DAX Power BI integration and Excel Macros VBA basics Scenario Sensitivity Analysis Data Tables Scenario Manager Goal Seek Solver break even and regression tools Visualization PivotTables PivotCharts conditional formatting and dynamic dashboards with slicers timelines Data Integrity Controls Use of structured tables named ranges and data validation for consistent reporting ERP BI Integration Working knowledge of SAP S 4HANA Oracle or Hyperion ability to extract and reconcile large datasets into Excel models Other Skills Clear and concise communication ability to translate data into business narratives for senior stakeholders Proven record of driving forecast accuracy margin improvement and operational alignment through analytics led insights Leadership skills to mentor analysts on Excel data interpretation and financial storytelling

Preferred Skills:

---------------------


BPM->Leadership - JL6A