Decision Support Analyst

Decision Support Analyst - 15 MONTH FTC 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, including: Absolut vodka, Ballantine’s, Chivas Regal, Royal Salute, and The Glenlivet Scotch whiskies, Jameson Irish whiskey, Martell cognac, Havana Club rum, Beefeater, Malfy and Monkey 47 gins, Malibu liqueur, Mumm and Perrier-Jouët champagnes. Here in the UK In the UK, Pernod Ricard is made up of 4 businesses: • Pernod Ricard UK, which markets, sells and distributes our products in the UK market • Chivas Brothers, the largest brand company in the Group, responsible for the production and management of our award-winning Scotch whisky portfolio • Pernod Ricard Global Travel Retail, the global and EMEA home of the group’s duty free, air travel and cruises business. • The Absolut Group, the brand owner of our global white spirits portfolio, whose Gin brand unit and Business Acceleration team sit in London. We are an organisation of 2,000 employees in the UK, headquartered in London, in a brand-new office designed with sustainability, ‘conviviality’ and collaboration in mind. We also have offices in Scotland and various distilleries and production sites across the UK from Plymouth to London to Speyside. 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 for 15 months. 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. Formulating data management techniques for quality data collection to ensure adequacy, accuracy of data and devising and implementing efficient and secure procedures for data management and analysis. 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. Your blend of talent 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. • Experienced in using delivery tools such as Jira. 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! You can access lots of gifts & discounts, including an allowance each year to spend on our brands in our staff shop and employee discounts from a range of high street retailers. 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. Conviviality: the Pernod Ricard Way We have our own way of doing things. We call it conviviality! It’s our way of being, and something unique you feel and experience when working for Pernod Ricard. We’re committed to conviviality, and with this, you’ll be Proud to Belong to our Pernod Ricard family. You’ll be Empowered to Perform, supported to succeed, and acknowledged for the value you bring. We combine all this with our Commitment to Care: we are unlocking the magic of human connection to transform our industry and make a positive impact on the world though our strong focus on sustainability and responsibility. 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. In our teams, we proactively foster a diverse work force and an inclusive culture – an environment where we can truly be ourselves. We will assess your application for this role based on your skills, experiences and achievements, not your gender, age, ethnic or educational background or any other such factors. Please feel free to leave these off your CV and application form if you so wish. Similarly, if you would like to discuss opportunities for flexible working or require accommodations or support to complete our application process, please let us know. Responsible drinking As ‘Créateurs de convivialité’, we want to turn social interactions into genuine and friendly experiences of sharing and wellbeing. In our culture, we want to create diverse teams in which our differences contribute to our success. Therefore, all are welcome at Pernod Ricard, regardless of your religious beliefs or personal choices on the consumption of alcohol. In our business, we work together with industry members, civil society, governments, local authorities and UN bodies to promote responsible drinking.