Financial Planning Systems and Reporting Partner in Glasgow

Your manager: Business Analysis Manager Planning & Reporting

Team: Finance

Location: Glasgow

We operate a hybrid working approach, which allows you to manage your time between home and office.

Be part of something big. We are Pernod Ricard, a leading company in the global spirits industry with over 19,000 employees globally. We own 16 of the world’s top 100 Spirits Brands and hold one of the most prestigious and comprehensive brand portfolios in the industry with 240 premium brands available in over 160 countries.

Your new team: This position sits in our Chivas Brothers business. At Chivas Brothers, our 1,600-strong team across 27 sites is committed to upholding the heritage of Scotch and ensuring its sustainable future, as well as opening it up to new audiences across the globe.

Role purpose: Please note, this role is a fixed term contract until August 2027. Reporting into the Financial Planning & Analysis team, our team is responsible for providing Financial Reporting, Analysis and Insight. Aligned to the HQ calendar and planning requirements, Decision Support are accountable for efficient interfaces between finance reporting and business transactional systems.

Your unique contribution: The key responsibilities of the role are:

• Monthly & Forecast population of Essbase Cubes and Oracle Planning and Budgeting Cloud Services (PBCS) with data from Oracle JD Edwards Enterprise (E1) – with emphasis on accuracy and data integrity to facilitate the production of high quality, accurate and timely reporting that effectively informs and drives the business.
• Lead the monthly extraction, reconciliation, and validation of data from JD Edwards Enterprise (E1) into the Polaris Reporting Tool, as well as quarterly intercompany loads, ensuring data accuracy and integrity to support the delivery of high-quality, timely, and business-critical reporting.
• Population of Forecast data to Polaris Reporting Tool, ensuring accuracy, completeness, and alignment with reporting timelines.
• Management of Master Data Hub Platform to ensure full data integration for Polaris Reporting Tool.
• Management and optimisation of Power BI Dashboards to deliver accurate, actionable reporting insights.
• Maintain Data Repositories. Ensure that data repositories are updated regularly and follow a consistent structure or format.
• Perform root cause analysis of data inconsistencies and propose corrections in coordination with Tech Teams.
• Champion data driven decision making, using key performance indicators, models and tools, ensuring practices across the business are integrated to optimise analysis and insight.
• Navigating Database Software, managing data integration procedures from business transactional tool to Financial Reporting & Planning Tools.
• Develop and implement procedures for effective data management. Responsible for identifying areas to increase efficiency, automation of processes, data quality and production.
• Proactively evaluate data sources and reporting systems to safeguard the quality, consistency, and credibility of analytical insights.
• Provide user support, administer user accounts, security roles, and access controls within EPBCS and Essbase, ensuring appropriate system access and compliance with governance standards.
• Demonstrate decision making and problem-solving skills. Key focus on supporting the team - Delivery Management.

Essential requirements:

• Solid understanding of accounting principles and processes.
• Good knowledge of business processes and brand awareness.
• Experience in Data Analysis. Proven analytical skills. Able to demonstrate a methodical and adaptable approach. Able to synthesise information into meaningful output for stakeholders.
• Strong data visualisation / documentation skills with the ability to create relevant documentation.
• Strong technical, analytical, problem-solving and decision-making skills.
• Experienced in data analytics and able to build models using Excel.
• Proven experience in Excel, Formula, Pivots etc.
• Experienced in using delivery tools such as Jira.
• Good interpersonal and communication skills.
• Resilient to change, able to drive to clarity in ambiguous situations and adapt quickly.
• Enthusiasm to motivate others. Commitment to be part of a team and to support others in making the wider team a success.
• Strong and reliable team player who can deliver results under pressure.
• Ability to use initiative and react proactively with little or no supervision.
• Working experience of Hyperion Essbase or similar OLAP tool.

Desirable requirements:

• Programming languages, such as SQL, Oracle and Python.
• Understanding of report generation, database file/table structure, data extract and load for databases such as SQL Server.
• Develop and maintain documentation to describe program development, logic, coding, testing changes and corrections.
• Working experience of JD Edwards Enterprise (E1).

Our mix of benefits: For your health, we offer private medical insurance, income protection and a comprehensive Employee Assistance Programme. Our lifestyle benefits include 28 days’ annual holiday, your employee pension, share incentive plan, season ticket loans, payroll giving and more!

We have regular events in our very own office bar, employee-run networks, a culture of flexibility and trust and a variety of tools and resources to help you focus on your wellbeing and mental fitness.

We’re committed to diversity and inclusion. People are at the heart of everything we do at Pernod Ricard and are the foundation of our collective spirit as ‘Créateurs de Convivialité’. We promote diversity and inclusion throughout our business and supply chain.

Responsible drinking: As ‘Créateurs de convivialité’, we want to turn social interactions into genuine and friendly experiences of sharing and wellbeing.