Commercial Analyst

at  Pernod Ricard

Main Purpose of the Role

• Enable the customer engagement team to produce high quality and trusted information and support the PRSA commercial teams.
• Support the design and implement short, medium and long term strategies and enable the evolution of information, products, tools, technologies and programs.
• To support the empowerment of the commercial leadership team & the field sales teams to make data driven decisions by providing them with KPI driven reporting and actionable insights derived from the analysis of sell in data.
• To bridge the gap between data sets and enable the consolidation of sell in, sell out and trade data in a single platform.
• To enhance the BI landscape through designing and scoping the strategic information landscape.
• Drive a creative, positive team culture that values conviviality as a way of working.
• Maintain the values of Pernod Ricard, including an entrepreneurial perspective that continuously surveys the commercial environment for improvement opportunities.

Key Duties and Responsibilities

• Business support of key strategic objectives
• Master data management, segmentation, database maintenance and governance in alignment with the data governance team
• Sell-in business data stewardship, which entails accountability and responsibility for data and related processes that ensure effective control and use of sell-in data. Work closely with the data governance department to create and manage metadata, document business rules and data standards, manage data quality issues and execute operational data governance activities.
• Consolidation, analysis and generation of actionable insights
• Weekly, monthly and quarterly routine updates and ad hoc reporting and insight requests
• WOW - monthly engagement with Sales Teams and ASDs on actions derived for SA, Troubleshooting and resolving reporting queries for volume and value
• Quarterly data allocation validation with ASDs for DC moves
• Active participation in JDE CRM maintenance and alignment with other systems for fields like segmentation and sales hierarchies following the approved process
• Duly following delegation of duty when authorizing any changes in business rules, calculations or databases with all stakeholders in the loop
• Providing capability support if and when required
• Proving regional input for PowerBI models and taking local accountability for usage and adoption
• Support to local, global, KDP project or programs if and when they arise
• Input into the strategic 3 to 5 year plan
• Growth model updates quarterly in alignment with Commercial leadership and global commercial excellence or business development teams
• Providing targets, reporting and presentations to: Sales Director, PRSA Leadership Team, CODI, KAMs, Sales Managers and other stakeholders within new created routines, promo reviews, customer meetings and/or ad hoc requests
• Adherence to all SIP deadlines, process and management as guided by the SIP champion
• Providing annual or bi-annual channel performance updates to HQ

Functional & Behavioral Competencies

• Strong systems understanding, coupled with experience in sales analytics and behavioral reporting, advanced excel skills and ability to design and use leading business analytic applications like PowerBI
• Attention to detail
• Experience in data modeling and system integration, for example ERP data, common language and customer and product solution mapping
• Excellent communication, writing, facilitation and presentation skills including the ability to relay complex topics simply
• Good judgment & decision making
• Critical and forward thinking
• Active learning & listening ability
• Strong social and interpersonal skills to build trust
• Team-oriented and flexible
• Collaborate effectively and build beneficial relationships with key stakeholders
• Excellent commercial acumen
• Rigorous, detail-orientated & proactive
• Ability to interrogate detail and generate insights which are relevant to business strategy and field actions
• Influencing skills and stakeholder engagement at all levels
• Creative problem solving

Qualifications and Experience

• University Degree in relevant field
• Minimum of 3 years’ post qualification experience as a national analyst in FMCG or alcoholic

Job Posting End Date:
Target Hire Date:
2024-11-01
Target End Date

Main Purpose of the Role

• Enable the customer engagement team to produce high quality and trusted information and support the PRSA commercial teams.
• Support the design and implement short, medium and long term strategies and enable the evolution of information, products, tools, technologies and programs.
• To support the empowerment of the commercial leadership team & the field sales teams to make data driven decisions by providing them with KPI driven reporting and actionable insights derived from the analysis of sell in data.
• To bridge the gap between data sets and enable the consolidation of sell in, sell out and trade data in a single platform.
• To enhance the BI landscape through designing and scoping the strategic information landscape.
• Drive a creative, positive team culture that values conviviality as a way of working.
• Maintain the values of Pernod Ricard, including an entrepreneurial perspective that continuously surveys the commercial environment for improvement opportunities

Key Duties and Responsibilities

• Business support of key strategic objectives
• Master data management, segmentation, database maintenance and governance in alignment with the data governance team
• Sell-in business data stewardship, which entails accountability and responsibility for data and related processes that ensure effective control and use of sell-in data. Work closely with the data governance department to create and manage metadata, document business rules and data standards, manage data quality issues and execute operational data governance activities.
• Consolidation, analysis and generation of actionable insights
• Weekly, monthly and quarterly routine updates and ad hoc reporting and insight requests
• WOW - monthly engagement with Sales Teams and ASDs on actions derived for SA, Troubleshooting and resolving reporting queries for volume and value
• Quarterly data allocation validation with ASDs for DC moves
• Active participation in JDE CRM maintenance and alignment with other systems for fields like segmentation and sales hierarchies following the approved process
• Duly following delegation of duty when authorizing any changes in business rules, calculations or databases with all stakeholders in the loop
• Providing capability support if and when required
• Proving regional input for PowerBI models and taking local accountability for usage and adoption
• Support to local, global, KDP project or programs if and when they arise
• Input into the strategic 3 to 5 year plan
• Growth model updates quarterly in alignment with Commercial leadership and global commercial excellence or business development teams
• Providing targets, reporting and presentations to: Sales Director, PRSA Leadership Team, CODI, KAMs, Sales Managers and other stakeholders within new created routines, promo reviews, customer meetings and/or ad hoc requests
• Adherence to all SIP deadlines, process and management as guided by the SIP champion
• Providing annual or bi-annual channel performance updates to H