SAP Data Analyst

We are looking for a SAP Data Analyst to manage data across two business units, plan for future business and data changes, to work with wine suppliers for accurate data and be able to flex and adapt to the changing needs of the business within the company.

We are dedicated to creating an open and inclusive working environment, and this starts with our recruitment practices. We try to ensure that everybody who is interested in joining our team has equal opportunity and ability to start that journey with us. We intend to have flexible and accessible hiring practices and will make every attempt to adapt to your needs throughout. We welcome any requests for adjustments in our processes.

Key Responsibilities

· Data management across two business units

· Creation of plan for processing and consolidating data

· Data accuracy and uploading

· Planning for future business and data changes

· Working with wine suppliers for accurate data

Financial Elements

· Responsible for setting up and maintaining SAP products and pricing and Merlin

· Upload annual price increases on SAP and Merlin

· Responsible for costing and maintaining of the cost of materials in all plants on SAP & Merlin

· Prepare an annual mass costing upload and release them for the new year at the year end

· Maintain and control of Master data in SAP such as Procurement block, deletion flag for obsoletes

· Master data and Pricing query management - resolve any errors in relation to processing Sales orders or MIGO/MIRO transactions caused by the Master data or the pricing issues

· Create and maintain supplier master data (Non-wine suppliers)

· Overseeing commodity codes

· Create a link between Merlin and SAP

· Ensuring consistent data for Vision and it closely links between Merlin and SAP

· Establish excellent working relationships with other departments

Operations Master Data

· Create and extend new and existing SAP & Merlin materials

· Data analysis of materials - investigating and amending material data

· Creating and maintaining customer master data

· Data analysis of customer master data - investigating and amending master data including customer hierarchies

· Creating and maintaining supplier master data (wine suppliers)

· Create purchase Info Records and Source lists

· Plant and storage location set up

· Monitoring inventory levels of SKUs for marking as obsolete.

· Preparation of data files for mass upload

· Other cleansing and planning activities as required.

· Working knowledge of SAP and or Merlin is advantageous

· Strong attention to detail and problem solving ability

· A proficient level of Excel, e.g. V look ups & pivot tables

· Good organization and time-management abilities

· Analytical and multitasking skills

· Able to flex and adapt to the changing needs of the business within the company

Freixenet Copestick are a major player in the UK's drinks market and the leading supplier of Sparkling wine. The company boasts an extensive portfolio across Still Wine, Sparkling Wine, Beer and Spirits.

Working Environment:

• Monday to Friday, 37.5 hours per week


• Hybrid working, average of three days per week in the office


• Primary work location is wheelchair accessible, with step free access and on-site parking, 25 days holiday + 1 day off for birthday + public holidays


Additional Company Pension Contributions

Discretionary Annual Bonus

Private Health Cover

Employee Assistance Programme

Life Assurance - 4 x basic salary

Income Protection Insurance

Group Accident Insurance

Company Maternity Pay - 13 weeks at full pay

Paternity Pay - 2 weeks at full pay

Time off for Volunteering

Generous staff discount