Data Analyst

Proactive Personnel Ltd; Lancashire; On-site; GBP 24,000 - 25,000; Full time

Job summary

A local recruitment agency is seeking a Sales Data Analyst to manage forecasting and stock management at their Burnley client. The role requires advanced Excel skills for data analysis and presentation of findings. The position offers a starting salary of £24,000 - £25,000 and working hours from Monday to Thursday 08:30am - 5:00pm, and Friday 08:30am - 12:30pm.

Qualifications

• Strong understanding of complex Excel sheets, including pivot tables.
• Experience with Excel formulas such as VLOOKUP and logical functions.
• Ability to self-teach and improve workload efficiency.

Responsibilities

• Forecasting and stock management for product inventory.
• Analyzing current stocks, outstanding orders, and future requirements.
• Maintaining order analysis documents and producing costing documents.

Skills

Advanced Excel

Data analysis

Presentation skills

Job description

Overview

Proactive Personnel are currently looking for a Sales Data Analyst to start work for our client in Burnley on a permanent basis.

Responsibilities

• As a Sales Data Analyst, you will be responsible for all aspects of forecasting and stock management for products throughout our business.
• This will involve analysing current stocks held, outstanding orders, and our future requirements - all based on monitoring sales from central reports.
• Within this are other various tasks which include maintaining order analysis documents on Microsoft Excel, producing Stock Commitments for customers, and producing costing documents.

Requirements

• Can understand and create complex Excel sheets, including the use of pivot tables and transferring data from a central workspace system
• Experience using excel formulas such as VLOOKUP and LOGICAL functions
• Ability to self-teach other formulas, to assist you in updating and making your workload more efficient
• Able to present information clearly, in various formats (PowerPoint/Excel/face-to-face)

Hours of work are Monday to Thursday 08:30am- 17:00pm and Friday 08:30am- 12:30pm.

Starting salary from 24,000- 25,000.

If interested, please apply now.