Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an Inventory Systems Analyst, mastering Oracle and MS Access to optimise inventory management.
- Company: Be part of a long-established business dedicated to customer-focused results in the supply chain industry.
- Benefits: Enjoy a hybrid work model, competitive salary, and opportunities for professional growth.
- Why this job: This role offers hands-on experience with advanced systems and a chance to drive impactful improvements.
- Qualifications: Advanced skills in MS Access, Excel, and SQL are essential; inventory management knowledge is a plus.
- Other info: Applicants must have the right to work in the UK; no visa sponsorship available.
The predicted salary is between 36000 - 42000 £ per year.
Location: Warwick on a Hybrid basis 3 days a week
Salary: £45,000 - £50,000 + benefits
Summary: Fantastic opportunity to join a long-established business that is highly committed to achieving customer focused results. The successful candidate will utilise a strong blend of analytical and systems capability (including advanced MS Access) together with a depth of operational inventory management knowledge to develop effective and efficient forecasting and inventory management solutions and processes.
Key Responsibilities:
- Oracle SCM Planning System Expertise: Act as a subject matter expert by mastering system functionality, ensuring data integrity, managing upgrades, and developing intuitive layouts, views, and reports.
- Process & Reporting Development: Design efficient planning and inventory management processes, and build dynamic reports using tools like Oracle FBDI, SQL, MS Access, Business Objects, and Excel to support data-driven decisions.
- Training & Documentation: Create structured training materials and reference documentation for both planners and system administrators to ensure effective system use.
- Operational Support & Issue Management: Monitor system operations, proactively manage issues, and support the Inventory team in achieving KPIs related to product availability, stock quality, and consumer satisfaction.
Key Skills/Experience:
- Advanced Technical & Analytical Skills: Demonstrated advanced capability in MS Access, together with Excel and SQL, for managing and analysing complex datasets, with strong ability to interpret data and provide actionable insights.
- Inventory Management Knowledge: Hands-on experience with inventory systems and planning concepts, including forecasting, safety stock, parameters, master data and technical setup/configuration.
- Problem-Solving & Detail Orientation: Skilled in identifying data anomalies, performing root cause analysis, and implementing lasting solutions with high attention to detail.
- Effective Communication & Continuous Improvement: Strong communicator with the ability to train others, challenge existing processes constructively, and drive continuous improvement using tools like Power BI, Power Automate, and Power Apps.
All applicants must have an unrestricted right to work in the UK as our client will not support visa sponsorship for this role.
Inventory Systems Analyst - Oracle & MS Access employer: Bis Henderson
Contact Detail:
Bis Henderson Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Inventory Systems Analyst - Oracle & MS Access
✨Tip Number 1
Familiarise yourself with Oracle SCM Planning System functionalities. Understanding the ins and outs of this system will not only help you in interviews but also demonstrate your commitment to mastering the tools you'll be using.
✨Tip Number 2
Brush up on your MS Access and SQL skills. Since advanced knowledge in these areas is crucial for the role, consider working on personal projects or online courses that can showcase your capabilities.
✨Tip Number 3
Prepare to discuss your experience with inventory management concepts. Be ready to share specific examples of how you've successfully managed inventory processes or solved related problems in previous roles.
✨Tip Number 4
Practice your communication skills. As the role involves training others and driving continuous improvement, being able to articulate your thoughts clearly and effectively will set you apart from other candidates.
We think you need these skills to ace Inventory Systems Analyst - Oracle & MS Access
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your advanced skills in MS Access, SQL, and Excel. Include specific examples of how you've used these tools in inventory management or data analysis to demonstrate your expertise.
Craft a Compelling Cover Letter: In your cover letter, emphasise your experience with Oracle SCM Planning Systems and your ability to develop efficient processes. Mention your problem-solving skills and how you can contribute to continuous improvement within the company.
Showcase Relevant Experience: When detailing your work history, focus on roles where you managed inventory systems or developed reporting processes. Use metrics to quantify your achievements, such as improvements in stock quality or consumer satisfaction.
Prepare for Potential Questions: Anticipate questions related to your technical skills and experience with inventory management. Be ready to discuss specific challenges you've faced and how you resolved them, showcasing your analytical and problem-solving abilities.
How to prepare for a job interview at Bis Henderson
✨Showcase Your Technical Skills
Make sure to highlight your advanced skills in MS Access, SQL, and Excel during the interview. Prepare examples of how you've used these tools to manage and analyse complex datasets, as this will demonstrate your capability to handle the technical demands of the role.
✨Demonstrate Inventory Management Knowledge
Be ready to discuss your hands-on experience with inventory systems and planning concepts. Share specific instances where you've successfully implemented forecasting or managed safety stock, as this will show your understanding of the operational side of inventory management.
✨Prepare for Problem-Solving Questions
Expect questions that assess your problem-solving abilities. Think of examples where you've identified data anomalies or performed root cause analysis, and be prepared to explain the solutions you implemented and their impact on the business.
✨Communicate Effectively
Strong communication skills are essential for this role. Practice explaining complex concepts in a clear and concise manner, and be prepared to discuss how you've trained others or driven continuous improvement in previous positions.
