At a Glance
- Tasks: Join a bespoke drinks brand to manage and reconcile inventory data.
- Company: Exciting London-based brand redefining premium beverages.
- Benefits: Short-term contract with potential for future opportunities.
- Why this job: Perfect for detail-oriented individuals who thrive in fast-paced environments.
- Qualifications: Experience with Sage and advanced Excel/Google Sheets is essential.
- Other info: Opportunity to contribute ideas for process improvements.
Are you a detail-driven data wrangler with a sharp eye for inconsistencies and a knack for bringing order to chaos?
We're working with an exciting bespoke drinks brand in London that’s redefining what premium means in the beverage space. As they scale rapidly, they’re looking for immediate support on a data reconciliation project central to their inventory and operational infrastructure.
This is a short-term temp contract (4–8 weeks) perfect for someone who thrives in a fast-paced environment, has strong experience working with Sage, and can confidently manage, structure, and reconcile large, occasionally ambiguous datasets across multiple sources.
The Project:
- Cross-check and align internal inventory records (Google Sheets) with Sage accounting data to build a clean, reliable master list.
- Liaise with third-party storage partners to collect their inventory reports and structure the data into a consistent format.
- Reconcile internal vs external data, highlight variances, and investigate discrepancies to establish a clear and accurate inventory picture.
Key Skills & Experience:
- Advanced Excel / Google Sheets – Lookups, pivot tables, conditional logic (must-have).
- Sage – Hands-on experience essential; confident navigating and reconciling against Sage data.
- Data Management – Comfortable working with large datasets that may contain gaps or inconsistencies.
- Organisation & Initiative – You’ll be expected to proactively chase down missing data from third parties and keep everything clearly documented.
Bonus Points:
- Process improvement mindset – ideas and observations welcomed as the team looks ahead to a potential systems upgrade later this year.
- Experience working with fast-moving start-ups or scale-ups.
If the role and responsibilities sound like a good fit for you, then I’d love to speak to you!
Please get in touch with Victoria Winter or click “Apply Now” to be considered for this vacancy.
Data Analyst - Inventory employer: The Advocate Group
Contact Detail:
The Advocate Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Inventory
✨Tip Number 1
Familiarise yourself with Sage and Google Sheets before the interview. Brush up on your skills, especially in using lookups and pivot tables, as these are crucial for the role. Being able to demonstrate your proficiency will set you apart.
✨Tip Number 2
Prepare examples of how you've successfully reconciled data in the past. Think about specific challenges you faced and how you overcame them, particularly in fast-paced environments. This will show your problem-solving skills and adaptability.
✨Tip Number 3
Research the bespoke drinks brand and understand their products and market position. Being knowledgeable about their business will help you tailor your conversation and demonstrate genuine interest during discussions.
✨Tip Number 4
Showcase your organisational skills by preparing a plan for how you would approach the data reconciliation project. Outline steps you would take to manage and structure the data effectively, which will highlight your initiative and process improvement mindset.
We think you need these skills to ace Data Analyst - Inventory
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with data management, particularly with Sage and Excel/Google Sheets. Use specific examples that demonstrate your ability to reconcile large datasets and manage inconsistencies.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your relevant skills and experiences, especially your proactive approach to data reconciliation and your ability to work in fast-paced environments.
Showcase Relevant Skills: Emphasise your advanced skills in Excel and Google Sheets, including lookups and pivot tables. If you have experience with process improvements or working in start-ups, make sure to include that as well.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or inconsistencies. A polished application reflects your attention to detail, which is crucial for a Data Analyst role.
How to prepare for a job interview at The Advocate Group
✨Showcase Your Data Skills
Be prepared to discuss your experience with Excel and Google Sheets in detail. Highlight specific functions like lookups, pivot tables, and conditional logic that you've used in past projects, especially in relation to data reconciliation.
✨Familiarise Yourself with Sage
Since hands-on experience with Sage is essential for this role, make sure you can confidently explain how you've navigated and reconciled data using this software in previous positions.
✨Demonstrate Your Problem-Solving Abilities
Expect questions about how you've handled discrepancies in data before. Prepare examples that showcase your analytical skills and your ability to investigate and resolve inconsistencies effectively.
✨Emphasise Organisation and Initiative
This role requires proactive data management. Be ready to discuss how you keep track of missing data and ensure everything is documented clearly. Share any strategies you've used to stay organised in fast-paced environments.