Decision Support Analyst 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.

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.

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.

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:

• 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.
• 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.

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.