Menu

Systems Analyst – Excel and SQL inc dashboards – Leeds Hybrid REF 1054

Published
January 23, 2023
Location
Yeadon, United Kingdom
Category
Job Type
Salary
34,000
Work Hours
37.5
Industry
Global FMCG
Qualifications
Industry standard
Contact number
01133572045

Description

Job Duties:

Work directly with the IT Manager and Directors to provide detailed reports to analyse total

product profitability and service cost to support sales decisions

Collate and analyse core financials and KPI data and develop current reporting in-order to form

further insights and recommendations

Review & automate to improve current manual data processes

Create dashboards using advanced Excel techniques and queries

  • Support IT Manager with any other associated tasks
  • Periodically assist with any first line support issues for a very limited number of users
  • Develop & maintain internal & external relationships

Job Duties:

Work directly with the IT Manager and Directors to provide detailed reports to analyse total

product profitability and service cost to support sales decisions

Collate and analyse core financials and KPI data and develop current reporting in-order to form

further insights and recommendations

Review & automate to improve current manual data processes

Create dashboards using advanced Excel techniques and queries

  • Support IT Manager with any other associated tasks
  • Periodically assist with any first line support issues for a very limited number of users
  • Develop & maintain internal & external relationships
  • Very strong IT and analytical skills – essential
  • Substantial experience in Microsoft Excel – essential
  • Power Query and SQL – desirable
  • Excel JET is advantageous, training will be considered
  • Experience in Business Central tables – training will be considered
  • Ability to work as part of a team and on own initiative - essential
  • Strong communication skills - essential
  • Good time management and able to work to challenging deadline – essential
  • Proven track record of developing and implementing data analysis – essential

Responsibilities

This family-owned FMCG global distributor established in the 1960 partner with global children’s brands to supply products across the retail market. With offices in the UK, USA and Hong Kong, they work with suppliers and retailers in over 50 countries worldwide and manage more than 35 thousand pallet movements per year.

With more than half a million sq. ft. of owned and operated warehousing space. They are responsible for the stock, both inbound and outbound, and have a great team of people keeping the business running efficiently to not only achieve OTIF compliance but also the targeted K.P.I’s within the business.

Role:

The successful candidate will increase business productivity by taking a proactive and collaborative approach to data analysis and forecasting, this could mean acquiring data from multiple sources for analysis. The post holder will need have a minimum of 3 to 5 year’s experience, with advanced Excel queries and an excellent understanding interpreting data and how it can benefit businesses. It is crucial that the successful candidate has the ability to visually represent data to managers and other stake holders within the business and in a palatable form. It will be your role to own the data estate and help manage the data with a new and exciting business intelligence outlook.

Business news

  • The organisation is a £30m+ distributor supplying branded products to major retailers all over the world. They have unparalleled relationships across the industry and their pre-Covid financial year marked their biggest and most successful, in a 50+ year history.
  • A high-quality Technology function is at the heart of ambition to grow to a £50m business over the next three years, and this opportunity is therefore business critical.
  • The European business employs 50 people across three sites, throughout the UK. The org retain their people remarkably well, with a friendly culture and generous, performance- based remuneration.
  • Project work – create reports and functional dashboards to understand the profitability of key areas of the business this will include UK, European warehouses and our Ecommerce business. Develop and intelligent way of working with data by developing reporting tools and dashboards.
Apply
Drop files here browse files ...

Read our Privacy Policy

Read our Privacy Policy