Commercial Analyst

SUMMARY:
Enable the customer engagement team to produce high quality and trusted information and support to the PRSA commercial teams.

POSITION INFO:

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 on 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 of 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

Key Competencies and Experience

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

Qualifications and Experience:

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