Sql Data Analyst

  • Competitive
  • Faversham, Kent
  • Shepherd Neame Ltd

The Role:

We are looking for an experienced data analyst to help provide data-driven insights and to ensure all of our system interfaces are well built and supported. Data is critical to our business and this role sits at the heart of that.

In this varied role you will work within a small team to build solutions and provide technical support for a wide range of business systems across the Brewery, support office and managed pub estate. You will have the opportunity to solve complex day-to-day issues and make a significant contribution on projects to support future business success.

The Ideal Candidate:

We’d love to hear from talented data analysts with a passion for data, excellent SQL skills and a problem-solving mind-set. You will be keen to learn, skilled at multi-tasking and know how to effectively prioritise workload in order to best support the team and our customers.

Our ideal candidate will also be:

• Flexible, adaptable and have a can-do approach

• Inquisitive and analytical

• An excellent communicator with a love for knowledge sharing

• Confident to work independently and in a small team

• Skilled at building effective working relationships with a range of stakeholders

Key Responsibilities

• Provide technical support for all our MS-SQL Server database environments, in particular our Reporting servers

• Manipulate, analyse and interpret complex data sets

• Design, build & maintain data extracts, reports and dashboards

• Set-up and maintain automated data processes

• Support and enhance existing applications and interfaces

• Perform data modelling & ETL

• Troubleshoot applications/programs, down to program code level

• Perform system administrator duties

Systems and technologies

It will beneficial to have experience of the following:

• SQL Server 2008 to 2019

• T-SQL and Query optimisation

• SQL Reporting Services (SSRS)

• SQL Server Integration Services (SSIS)

• Web technologies e.g. web service functions/APIs, SOAP

• Data file formats e.g. CSV, XML, JSON, SAP IDocs

• File transfer technologies e.g. FTP, SFTP

• Middleware technologies for message translation

• ERP - preferably SAP ECC6, ABAP

• BI - preferably QlikView, QlikSense

• Advanced MS-Excel, VBA

Benefits:

• Competitive salary

• Contributory Pension scheme

• Share Incentive Plan

• Staff discount scheme in all Shepherd Neame Managed House pubs and hotels

• A variety of fun company events

• Access to a counselling service

• Access to a Mental Wellbeing Platform

• 25 days holiday (+ bank holidays)

The Company:

Britain’s oldest brewer Shepherd Neame has been based in the market town of Faversham, Kent for over 300 years. An independent family business, we boast an award-winning visitor centre and more than 300 pubs and hotels throughout London and the South East, from the historic heart of the City to the Kent coastline. We employ around 1,500 team members across our pub estate, and more than 270 at our brewery and head office. Perhaps best known for great British classic ales such as Spitfire Amber, which carries the Royal Warrant, our diverse portfolio includes Five Grain Lager, the Bear Island Collection and the Whitstable Bay Collection. We also brew international lagers under licence including premium Thai lager Singha and American best-seller Samuel Adams Boston Lager, and are the sole UK distributor for Truly hard seltzer.

Diversity, equality, and inclusion matter to Shepherd Neame. If you think you would be suited this role we would welcome your application regardless of age, disability status, ethnicity, gender, religion or sexual orientation. We strive to provide an inclusive and supportive working environment where all employees feel respected and supported in fulfilling their potential.

Application Closing Date: 11th February 2022

  • Advertiser: Direct Employer