Assistant Manager - Planning & Reporting

dentsu; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Bcoe in Bangalore is seeking a senior FP&A professional to join the UK&I team, responsible for budgeting, forecasting, and month-end processes at Brand, Client and Channel levels. You will update trackers, perform variance analysis and prepare scenario-based recommendations while coordinating across media and service lines.

The role requires strong Excel/PowerPoint skills, Power BI experience, and the ability to partner with cross-functional teams in a high-pressure environment.

Qualifications

• MBA Finance with 5+ years experience or Qualified Accountant 3+ PQE (CA/ACCA/CIMA or equivalent)
• Previous FP&A experience in Revenue and costs
• Advanced Excel and PowerPoint skills
• Knowledge and experience of Power BI System
• Strong communication skills, written and verbal
• Ability to work across functions and levels, high-pressure prioritization
• Experience with AI GL, SAC, Power BI, Planning & Consolidation Systems is a plus

Responsibilities

• Prepare Budgets, Quarterly forecasts and Month-end Reviews with liaison to client leads
• Coordinate FP&A requirements for Brand Level Revenue and Channel forecasting
• Provide variance analysis and remedial action proposals
• Share forecasts with Commercial Finance leads and communicate variances
• Prepare PowerPoint presentations for service line reviews
• Conduct trend analysis and Salesforce pipeline reviews
• Produce monthly service line reporting
• Identify standardisation opportunities in Media Service revenue
• Maintain Excel and other team formats
• Submit budgets and forecasts to SAC Planning System
• Coordinate consolidation of ODOM brands like B2B, D2D/DDL

Skills

Communication skills

Analytical mindset

Cross-functional collaboration

Problem-solving

Education

MBA Finance

CA/ACCA/CIMA

Tools

Power BI

Excel

PowerPoint

SAC (Planning & Consolidation)

Planning & Consolidation Systems

Job description

This role is part of the overall UK&I FP&A team based out of Bangalore. The responsibilities include preparation of the Annual budget, Monthly forecasting and month end process for Revenue at Brand, Client and Channel Level. This role will involve preparation of the base budgets and forecasts plus review of same, including detailed variance analysis, identifying problem areas and proposing scenario-based solutions[VK1.1]. This role will be required to maintain and update various formats, trackers/repositories as required from time to time.

Job Description:

• Key Accountabilities

• Prepare Budgets, Quarterly forecasts and Month-end Reviews, including appropriate liaison with and challenge to client leads

• Co-ordinate, communicate and oversee all FP&A requirements in respect of Media LOB for Brand Level Revenue and Channel forecasting

• Review and validation of output from above to ensure accuracy, consistency, and provide informed variance analysis

• Share forecasts and budgets with [Media] Commercial Finance leads, communicating identified variances, risks and agree remedial action as appropriate

• Preparation of Power-Point presentations to support [service line] reviews at Capability / Channel / Practice Area level

• Trend analysis including review and validation of Salesforce pipeline to inform analysis and forecasts

• Produce monthly and other reporting requirements of the Service Line

• In-depth review of [Media Service] revenue and identify opportunities for further standardisation and efficiencies

• Maintain Excel and other formats required by the team

• Submission of Service Line budgets and forecast to SAC Planning System

• Review and validation of output from above to ensure accuracy, consistency, and provide informed variance analysis

• Co-ordinate consolidation of ODOM brands such as B2B, D2D/DDL

Business Partnering:

• Monthly interaction with Client Accounting teams to understand deviations in actual performance and incorporate into monthly analysis and future forecast impact
• Feed into monthly close process to ensure key accruals and inaccuracies have been resolved in liaison with Financial Control
• Provide monthly commentary analysis to Commercial Finance and other FP&A teams and resolve any queries
• Support and work collaboratively with wider FP&A team, Commercial Finance and Operational Finance

Team Development:

• Be an active part of the UK FP & A team, focusing on developing a professional, high performing function. This will include prioritising staff development and putting in place the best structure to deliver the FP&A vision for the business.
• Build strong team ethos with the Commercial Finance and other Finance teams.

Key Requirements

• MBA Finance with 5+Years experience or Qualified Accountant 3+Years PQE (CA/ACCA/CIMA or equivalent)
• Previous experience of FP&A in Revenue and costs profile
• Advanced Excel and Power Point skills
• Knowledge and experience of Power BI System
• Good communication skills, both written and verbal
• Confident with working across functions and levels
• Demonstrable experience of informed review and analysis of results and forecasts
• Problem-solving and analytical mindset
• Ability to effectively prioritize and execute tasks in a high-pressure
• Experience of Artificial Intelligence (AI) GL, SAC, Power BI, Planning & Consolidation Systems will be an added advantage

Location:

Bangalore

Brand:

Bcoe

Time Type:

Full time

Contract Type:

Permanent