IT recruitment consultancy | Quantica Technology


Job description SQL Analyst - Supply Chain Job reference: MTSQL1 Location: City of London Salary: £40000 - £41000 per annum SQL Analyst - Supply Chain Background to vacancy The Logistics Strategy Team have developed two Microsoft SQL databases to enable the GM and Foods supply chains to be analysed and to provide data to support modelling and simulation tools. A further database is in development to model GM inventory. What is the purpose of the job? The successful applicant will be responsible for maintaining the databases and for providing data and analysis to support modelling, simulation and business projects. Data acquisition is at day-location-UPC level so the data volumes are challenging (c. 5Tb for GM and 2Tb for Foods). However, correctly managed they provide an invaluable insight into the operation of the supply chain supporting key decisions on strategic direction. This is a great opportunity for someone who wants to develop a deep understanding of how the companies supply chain operates at the most detailed level and help explore how we can drive sales, value and efficiency for the business. What do you need to achieve? Daily, weekly and monthly administration tasks to ensure all data has been successfully acquired, processed, validated and secured. Analyse information requirements for modelling, simulation and project tasks and create proposals to deliver data, reports and tools to meet the requirements. Implement approved proposals to agreed timescales. Provide ad-hoc support and analysis as required. Technical skills/business skills required Microsoft SQL Server experience. You will be dealing with IT support teams so must have good technical knowledge, e.g. basic knowledge of SQL Server System Processes, the ability to read process Ids and deduce server performance bottlenecks. SQL query development experience (ideally Transact SQL). Excellent Microsoft Access and Excel skills including Visual Basic programming. Excellent numerical skills including knowledge and application of statistics. Basic understanding of retail supply chains. A working knowledge of M&S supply chain processes and systems would be ideal but this can be developed in candidates with the right technical skills. Ability to develop strong and effective relationships with IT support teams. Ability to analyse data in high volumes and to interpret results in a commercial context. Good interpersonal and communication skills. How to apply If you are interested in the position above please apply by sending your CV to Please clearly state the role you are applying for.	Latest jobs MS Dynamics Developer MS Dynamics Developer - XRM , ... Job reference: MS Dynamics Location: Durham Salary: Market rates System Support Engineer - SAN Storage - Surrey System Support Engineer - SAN ... Job reference: SAN2 Location: Epsom Salary: £38000 - £45000 per annum + excellent benefits Product Manager / Project Manager Agile, e-commerce Job Title: Product ... Job reference: 0876NMC Location: City of London Salary: £40000 - £50000 per annum	Industry news Follow the latest technology news that matters to UK IT leaders and IT professionals, as it happens, from the UKâs leading technology publication. Mobile threats demand focus on data protection, says Websense Fri, 18 May 2012 10:58:02 EDT - Business needs to focus on data protection as cyber criminals turn to mobile malware, says Websense. Businesses at risk from 'unfair' cloud contracts Fri, 18 May 2012 09:49:50 EDT - Businesses are unwittingly signing cloud computing contracts that could leave them liable for failures by their supplier. Security Think Tank: Outsource only run-of-the-mill security functions Fri, 18 May 2012 09:19:15 EDT - What should and what should not be outsourced in IT security?

ERP jobs Infrastructure jobs Development jobs Microsoft Technologies jobs Digital jobs Projects jobs North East jobs London jobs North West jobs England jobs Midlands jobs South East jobs South West jobs C#.NET DEVELOPER/ ANALYST PROGRAMMER � PERMANENT � BIRMINGHAM SENIOR/ PRINCIPAL SQL BI CONSULTANT � LONDON - PERM � up to �70,000 Digital Marketing Manager IT SERVICE DESK SUPERVISOR IT SERVICE DESK TECHNICIAN-1st/2nd Line Programme Manager VB6/VB.NET Developer		Privacy Policy \| Diversity Policy \| Legal Site Map \| Kellan Group Plc

Job description

SQL Analyst - Supply Chain