OVERALL PURPOSE OF THE JOB:
- Key responsibilities encompass comprehensive
Financial Reporting
(Internal & External), Variance Analysis
and support for shaping and presenting the Rolling Forecast
to management and other internal stakeholders. - This role
works very closely with the Finance Manager- FP&A and supports Head Business Planning & Analysis
for all the financial planning and reporting matters. - This role involves close
collaboration with multiple cross functional teams such as Pricing
, Revenue Growth Management (RGM)
, and Marketing
to extract valuable business insights and action points for areas of concern. - The role requires
technical proficiency
in Microsoft Excel, Power point and other in-house analysis and reporting tools (Anaplan, Datalens, Polaris and JDE) - The role holder should possess
problem-solving approach
and demonstrate strong Inter- personal skills
.
KEY RESPONSIBILITIES:
REPORTING (ANAPLAN and DATALENS)
- Deliver automated
monthly volume reports
with zero external linkages to improve data integrity and reduce manual errors. - Build comprehensive
Rolling Forecast reporting formats
, including interactive volume files, zonal dashboards, and Net Sales/ Profitability analysis
across years. - Develop advanced
visualization tools
such as Bubble Charts
and monthly zonal dashboards for P&L line-item insights. - Conduct
UAT for Power BI and Anaplan dashboards
and reports to ensure data accuracy and reporting reliability.
BUSINESS REVIEWS & PRESENTATIONS
- Build files, formats, and reports to
automate analysis in the most precise, accurate and timely manner
using existing tools (Anaplan & Polaris) - Accountable for
in-depth analysis
of financial statements on a monthly, quarterly, annual and need basis. - Responsible for preparation of
Rolling Forecasts
and long-range Strategic plans
for the entire India business. - Design dashboards and trackers to support
Pre-Executive and Executive S&OP
reviews. - Facilitate
comprehensive comparisons (e.g., YoY, MoM phasing)
to support informed decision-making during reviews. - Regularly develop
ad-hoc Excel and PowerPoint decks
tailored for urgent and high-priority stakeholder requirements.
BUSINESS SUPPORT AND COLLABORATION
- Collaborate with the pricing team to ensure
accurate and timely preparation
of the transfer prices
for International Whiskies (BIO - Bottled in Origin) - Regularly prepare
Gross Margin bridge
and engage in discussions with the RGM team based on the analysis to identify action plans and highlight any risks. - Collaborate closely with the Commercial team to gather, align, and validate data for
Allowance & Discount analysis
. - Initiate and implement corrections in
existing Anaplan modules and dashboards
, enhancing reporting workflows for Finance.
PEOPLE MANAGEMENT
- Ability to
communicate effectively with peers, managers, and other team members
. Adaptable
to the needs of the team and the organization, flexibility in various work situations and openness to new ideas and perspectives.
- Engaging with both internal and external stakeholders to identify areas for improvement and enhance processes through collaborative efforts.
- Demonstrate leadership in
content creation and resource building
, consistently supporting team members with tools and quick-turnaround deliverables.
KEY INTERFACE
INTERNAL STAKEHOLDERS
- Demand Planning & Sales Finance
- Revenue growth Management
- Sales and Marketing
- Corporate Accounts
- Strategy and Transformation
- Pernod Ricard-HQ FP&A
JOB REQUIREMENTS
QUALIFICATIONS
Qualified Chartered Accountant/ MBA
EXPERIENCE
2-3 years post qualification work experience, ideally experience in strategic / financial planning, forecasting and financial analytics.
FUNCTIONAL AND BEHAVIOURAL COMPETENCIES
- Good Knowledge of Processes and Information Systems
- Business Acumen & Strong Analytical skills
- Attention to detail
- Effective collaboration
- Good Communication and Presentation Skills
- Strong Time Management with Ability to Multitask