Purchasing Data Analyst

DS301– Purchasing Data Analyst

Location: Witney

Salary: £27000 - £30000

Overview:

First Military Recruitment are currently seeking a Purchasing Data Analyst on behalf of our clients.


Working closely with the Purchasing Director, IT Manager, and Purchasing Admin Manager, the Purchasing Data Analyst will be responsible for the data analysis of an extensive range of motorcycle and cycle products.



Duties and Responsibilities:


  • Compiling high level management reports for the Purchasing Director and other members of the management team utilising SQL Server Management Studio to interrogate the background tables of our ERP and WMS systems.
  • Providing detailed stock information and updates to the sales team when requested.
  • Managing and developing ordering reports to facilitate accurate stock-keeping.
  • Analysing sales history allowing for seasonality, extraordinary sales events and other unique criteria.
  • Maintenance of product files within the company’s systems.
  • Monitoring and updating our SQL databases for optimum performance.
  • Developing and updating Crystal Reports based report templates.
  • Utilisation of SQL, ODBC and Excel VBA skills to improve reporting and processes. 
  • Creating SQL based email notifications via Orbis Task Centre, for which full training will be given.
  • Maintaining and updating our SQL based KPI dashboards.

Skills and Qualifications:


  • An advanced knowledge of Microsoft Excel, VBA and SQL is essential.
  • The ability to create interactive parameter-driven reports using SAP Crystal Reports, presenting the output in a user-friendly format is also desirable. 
  • Furthermore, experience with SQL based ERP software such as Access Dimensions and warehouse management software such as Access Delta would be a distinct advantage.
  • Experience of Orbis Task Centre, programming Python, or utilising SQL Server Integration Services (SSIS) would be a bonus.

DS301– Purchasing Data Analyst

Location: Witney

Salary: £27000 - £30000





Share Job