Business Data Analyst . Job Reference: 1649586

Job ID: 712065
Salary: Competitive and Benefits negotiable
Job Views:

Competitive and Benefits

Date when vacancy closes
30 Jun 2017

Business Area
Head Office

Area of Expertise


Vacancy Details

What is the purpose of the job?

o RAD (Rapid Application Development)
o Technical advice and support to central planning
o Custom business tool creation and support
o Scheduled reporting on specified KPIs
o Business Intelligence & Process Improvement
o Adhoc reporting and support

What are you accountable for achieving?

o Creation of custom business tools fit for purpose
o Acquire user specification from business stakeholders
o Offer suggestions to enhance systems
o Providing detailed updates on workflow
o Balancing stock across the network to ensure higher sell through, higher ECom availability and reduced markdown
o Design a bespoke stock balancing system
o Forecast modelling
o Custom query engine
o Report module
o Site/UPC specific picklist generation
o Support and maintain the stock balancing process and system
o Liaise with eCom Allocators on stock level requirements and live product available on the website
o Liaise with Logistics to arrange stock movements around the network
o Update the business on progress and success when required
o Provide a link between Central Planning and technical stockholders
o Stock clearance of redundant lines in the network
o Identify UPCs in the network, which are at the end of their lifecycle. Then arrange the appropriate action
o Facilitate EDC/NDC departmental transition to the new network delivering stock targets and ways of working to ensure sustainability
o Provide Maintain and enhance the Push Allocation call centre database, providing user support when required
o Support Central Planning with Microsoft Office user questions
o Offer guidance and advice on new projects relating to technical requirements and possible shortfalls
o Regular scheduled reporting
o Daily
o Weekly
o Monthly
o Quarterly
o Yearly
o Support the commercial review process

o Provide cover and support to team members who are out of the office

What is the scope of the job?

o Reports to GM-Central Planning Manager
o Business Units, eCom, Outlets, International Franchise, Finance and Supply Chain
o IT, GM4, SaS Technical Support, Multichannel Foundation Programme

Technical skills/business skills required

o Advanced Microsoft Office skills
o MS Word
o MS Excel
o MS Access
o MS Outlook
o MS PowerPoint
o MS Visio
o Keen understanding of statistics and data modelling
o Advanced knowledge of RDMS creation, maintenance and support
o Systems knowledge (MS Office, VBA, VBS, .Net, SQL or similar coding experience)
o Automation techniques to maximise team utilisation
o Understanding of data integrity and reporting requirements
o Reporting competencies
o Business Objects (BI) understanding

o Knowledge of Big data sets (Hadoop or similar)

o Experience of big data visualisation (spotfire or similar)

o Advanced knowledge of excel and other MS office programmes

o Time management
Send to a Friend