Role Purpose & Context
Role Summary
The Sourcing Assistant helps us buy things properly. Day-to-day, you'll be running smaller sourcing events, getting new suppliers set up, and generally making sure we stick to the rules when we're spending company money. You'll sit right in the middle of our Procurement team, making sure our internal clients get what they need, while Finance and Legal are kept happy.
When you do this job well, we save money, get better quality goods and services, and avoid all sorts of headaches with dodgy suppliers or contracts. If it's not done well, we end up overpaying, buying from risky companies, or worse, getting into legal trouble.
Honestly, the tricky part is often getting everyone internally on the same page about what they actually need. The reward, though? You'll see how your work directly impacts the company's bottom line and keeps our operations running without a hitch.
Reporting Structure
- Reports to: Senior Sourcing Analyst
- Direct reports:
- Matrix relationships:
Sourcing Analyst, Junior Buyer, Procurement Specialist,
Key Stakeholders
Internal:
- Internal Business Units (e.g., Marketing, IT, Operations) – they're the ones who need stuff bought.
- Finance Team – they care about budgets, invoices, and making sure we're not overspending.
- Legal Department – they check all the contracts and make sure we're not signing anything silly.
- Accounts Payable – they're the ones who actually pay the suppliers, so you'll work closely with them.
External:
- Existing Suppliers – you'll be their main point of contact for day-to-day stuff.
- Potential Suppliers – the companies we might buy from in the future, you'll help vet them.
Organisational Impact
Scope: Your work here directly impacts our ability to control costs, manage supplier risk, and ensure we're getting good value for money across the business. You're essentially a gatekeeper, making sure every pound we spend is spent wisely and compliantly. Get it right, and we save cash. Get it wrong, and we could face financial hits or operational delays.
Performance Metrics
Quantitative Metrics
- Metric: Requisition-to-PO Cycle Time
- Desc: How quickly you turn an approved internal request into a formal purchase order sent to the supplier.
- Target: Convert 95% of approved requisitions to POs within 48 hours.
- Freq: Weekly, reviewed monthly.
- Example: If we get 20 approved requisitions on Monday, you'll have 19 of those converted to POs and sent out by Wednesday morning.
- Metric: Supplier Master Data Accuracy
- Desc: Making sure all the supplier information in our system (bank details, addresses, contact info) is correct and up-to-date.
- Target: Achieve >98% accuracy in new supplier master data entry and contract metadata.
- Freq: Monthly audit checks.
- Example: Out of 100 new supplier records you set up, no more than 2 will have errors in their payment terms or contact details.
- Metric: RFQ Response Rate & Quality
- Desc: How many suppliers respond to the simple Requests for Quotation you send out, and how complete those responses are.
- Target: Achieve an average 70% response rate on RFQs, with 85% of responses being fully compliant.
- Freq: Per sourcing event, reviewed quarterly.
- Example: For an RFQ sent to 10 suppliers, 7 respond, and at least 6 of those provide all the info we asked for, making evaluation straightforward.
- Metric: Identified Savings (Small Scale)
- Desc: Spotting opportunities to save money on smaller, routine purchases or by consolidating orders.
- Target: Identify and track £5K-£10K in documented cost savings annually on routine items.
- Freq: Quarterly, reviewed annually.
- Example: You notice we're buying office supplies from three different vendors. You suggest consolidating to one, leading to a £7K saving over the year.
Qualitative Metrics
- Metric: Internal Client Satisfaction
- Desc: How happy our internal teams are with your support during the buying process.
- Evidence: You'll get positive feedback from internal stakeholders (e.g., 'always helpful', 'makes the process easy'). They'll come to you directly with questions, not just your manager. You'll be seen as someone who helps them get things done, not a roadblock.
- Metric: Process Adherence & Documentation
- Desc: How well you follow our established procurement processes and keep records updated.
- Evidence: Your sourcing files are always complete, easy to audit, and follow our templates. There are no surprises when your manager reviews a project. You're the person who remembers to file that signed NDA, even when no one asks.
- Metric: Supplier Relationship Quality
- Desc: Building good, professional relationships with our suppliers.
- Evidence: Suppliers respond promptly to your requests and see you as a fair, reliable point of contact. They're happy to work with us because you make the process clear and efficient. You handle minor issues with suppliers calmly and professionally, usually resolving them yourself.
Primary Traits
- Trait: Process-Minded
- Manifestation: You're the kind of person who naturally organises things into steps. You'll create your own little checklists for complex tasks, even if we don't ask you to. When a stakeholder tries to rush you or skip a step, you'll politely but firmly explain why we need to follow the process. You're also happy to document how you do things, just because it makes sense.
- Benefit: Honestly, in Procurement, process is king. If we deviate from our RFQ process, we could open ourselves up to legal challenges from unhappy suppliers or even accusations of unfairness. Missing a step in supplier onboarding could mean we accidentally work with a company that's a financial risk. Your adherence to process protects us all, plain and simple.
- Trait: Forensic Detail-Orientation
- Manifestation: You're the one who spots that a supplier's bid has quoted 'price per box' when our RFQ asked for 'price per unit'. You'll notice a contract clause that seems to contradict something we agreed in the email chain. You'll double-check the bank details on a new supplier form three times before hitting save. It's about catching those tiny errors that can become huge problems.
- Benefit: A single misplaced decimal point in a bid comparison spreadsheet could mean we award a £500K contract to the wrong supplier, costing us a fortune. Mis-entering a payment term could lead to late payment penalties. Your ability to spot these small things prevents big, expensive mistakes. You're our last line of defence against costly blunders.
- Trait: Professional Resilience
- Manifestation: You can calmly tell a frustrated internal client that, no, we can't just 'fast-track' their preferred supplier without proper due diligence. You'll push back professionally when someone gives you an unrealistic deadline. You can handle a supplier complaining about a decision without taking it personally, explaining the 'why' clearly and objectively.
- Benefit: Procurement often has to say 'no' or enforce policies that aren't popular. If you can't handle that pushback, you'll either burn out or start caving to pressure, which undermines our entire function. We need people who can stand firm, explain the rules, and keep things fair, even when it's uncomfortable. It's not about being aggressive; it's about being firm and fair.
Supporting Traits
- Trait: Inquisitive
- Desc: You'll naturally ask 'why' a few times when someone asks you to buy something. Not to be difficult, but to truly understand the business need behind the request. This helps us find the right solution, not just the first one.
- Trait: Organised
- Desc: You'll be juggling a few small sourcing events, chasing suppliers, and helping internal teams. Keeping track of everything, knowing what's urgent and what can wait, is super important. Things won't fall through the cracks on your watch.
- Trait: Collaborative
- Desc: You're not working in a silo. You'll need to chat with people in Legal, Finance, and various business units. Being able to work well with different personalities and get everyone on board is key to getting things done.
Primary Motivators
- Motivator: Making Things Run Smoothly
- Daily: You get a real kick out of seeing a process work perfectly, from the initial request to the final purchase order. Sorting out a messy supplier issue or streamlining a small buying process genuinely makes your day.
- Motivator: Being the 'Go-To' for Getting Things Done Right
- Daily: You enjoy being the person who knows the system, knows the process, and can help others navigate it. People come to you because they trust you to handle things accurately and compliantly.
- Motivator: Protecting the Company's Interests
- Daily: You feel a sense of responsibility for ensuring company money is spent wisely and that we're not taking unnecessary risks with suppliers. You're happy to be the 'guardian' of good spending.
Potential Demotivators
Honestly, this role isn't for everyone. You'll often feel like you're playing 'Procurement Police,' enforcing rules that some people find annoying. You'll spend a fair bit of time chasing people for information they should have given you already. And sometimes, you'll put a lot of effort into a sourcing event only for the business to change its mind and cancel it. If you need constant praise for every piece of work or struggle with repetitive tasks, you might find it tough.
Common Frustrations
- The 'Hurry Up and Wait' Cycle: Being told something is urgent, you drop everything, then you're left waiting weeks for stakeholder input.
- Requirement Ambiguity: Getting vague requests like 'we need some new software' and having to pull teeth to figure out what they actually want.
- The Data Janitor: Spending hours cleaning up messy spreadsheets from internal teams before you can even start your analysis.
- Being the Scapegoat: Getting blamed for delays when, frankly, it was someone else's indecisiveness or slow response that held things up.
What Role Doesn't Offer
- High-level strategic decision-making – that comes later, once you've mastered the basics.
- Constant novelty – there's a lot of process, and while projects change, the underlying steps are pretty consistent.
- Direct management of people – you're focused on your own output.
- A 'wild west' approach to spending – we're all about control and compliance here.
ADHD Positives
- The varied nature of managing multiple RFQs and supplier interactions can provide stimulating, shifting focuses.
- The need for quick problem-solving when issues arise with POs or suppliers can be engaging.
- Clear, structured processes (when followed) can provide a helpful framework for task management.
ADHD Challenges and Accommodations
- Repetitive data entry for supplier onboarding or contract metadata might be challenging; we can discuss tools or breaks to help.
- Staying focused on long, detailed contract reviews can be tough; breaking these down into smaller chunks or using AI summarisation tools can help.
- Managing multiple open tasks requires strong organisational systems; we can help you set up digital tools and reminders.
Dyslexia Positives
- Strong verbal communication skills can be a real asset when dealing with suppliers and internal teams.
- A 'big picture' understanding of the procurement process can help you connect the dots, even if the details are tricky.
- Problem-solving skills, especially for unexpected issues, are highly valued.
Dyslexia Challenges and Accommodations
- Reading and reviewing lengthy RFQ documents or contracts can be time-consuming; we encourage using text-to-speech tools and providing summaries.
- Ensuring accuracy in written communication (emails, reports) is critical; we use grammar checkers and encourage peer review.
- Data entry and spreadsheet work might require extra care; we can provide templates and double-check processes.
Autism Positives
- The clear, logical processes inherent in procurement (RFx steps, P2P cycle) can be very appealing and provide a sense of order.
- A strong focus on detail and accuracy is incredibly valuable for spotting errors in bids or contracts.
- The ability to concentrate deeply on tasks like data analysis or system configuration can lead to high-quality output.
Autism Challenges and Accommodations
- Navigating complex social dynamics with multiple internal stakeholders or demanding suppliers can be tiring; we encourage direct, clear communication and can help you script difficult conversations.
- Unexpected changes to priorities or processes can be unsettling; we aim to give as much notice as possible and explain the 'why' behind changes.
- Sensory overload in an open-plan office might be an issue; we offer noise-cancelling headphones and quiet zones for focused work.
Sensory Considerations
Our main office is typically a modern, open-plan environment, so expect some background noise and general chatter. We do have quiet zones and meeting rooms you can use for focused work or calls. Visually, it's a standard office setup, nothing too overwhelming. Socially, you'll have daily interactions with your team and regular contact with internal clients and suppliers, mostly through email and video calls, but some in-person meetings too.
Flexibility Notes
We're pretty flexible here. We understand that everyone works best in slightly different ways. If you need specific tools, a different desk setup, or adjustments to your working pattern to help you thrive, just talk to us. We're open to hybrid working, mixing office and home days, usually 2-3 days in the office, but we can adjust that for the right person.
Key Responsibilities
Experience Levels Responsibilities
- Level: Sourcing Assistant (Mid-Level)
- Responsibilities: Independently run simple Requests for Quotation (RFQs) from start to finish. This means drafting the RFQ document using our templates, sending it to our Preferred Supplier List, collecting responses, and doing the initial comparison. You'll make sure we're getting competitive prices for things like office supplies or basic software licences.
- Manage the full supplier onboarding process for new vendors. This involves collecting all their paperwork (bank details, insurance, compliance docs), getting them set up in our P2P system (SAP Ariba, usually), and making sure all the due diligence checks are completed. Get this wrong, and we can't pay them, or worse, we onboard a risky supplier.
- Perform basic spend analysis for specific categories. You'll take raw spend data from our ERP, clean it up in Excel (yes, it's often messy), categorise it, and flag obvious opportunities for savings or consolidation to your Senior Analyst. Think simple PivotTables and VLOOKUPs.
- Support the contract administration process. You'll upload executed contracts into our CLM system (DocuSign CLM), make sure all the metadata fields are populated correctly, and track key dates like expiry or renewal. This helps us avoid nasty auto-renewals or missing opportunities to renegotiate.
- Process purchase requisitions and convert them into purchase orders (POs) in our system. You'll check that the requisition is complete and approved, then issue the PO to the supplier. This is a core part of keeping the buying cycle moving.
- Act as the first point of contact for routine supplier queries and internal client questions about the procurement process. You'll answer questions about PO status, invoice queries, or how to get a new item bought. If you can't answer, you'll know who to ask.
- Keep our procurement documentation tidy and up-to-date. This means making sure all sourcing event files, supplier records, and contract summaries are stored in the right place, following our naming conventions. Honestly, it's not glamorous, but it's crucial for audits and for anyone else picking up your work.
- Supervision: You'll have weekly check-ins with your Senior Sourcing Analyst to discuss your workload, any blockers, and progress on your projects. For routine tasks, you'll work independently, but for anything new or complex, you'll get clear guidance and support.
- Decision: You'll make routine decisions within established guidelines, like selecting a supplier from a pre-approved list for a simple RFQ or deciding the best way to categorise a new spend item. Anything outside of these guidelines, or anything involving significant financial risk (say, over £5K), you'll escalate to your Senior Analyst or Manager for review. You're not signing off on big contracts just yet.
- Success: You're successful when your simple RFQs run smoothly and deliver good value, new suppliers are onboarded quickly and accurately, and your spend data analysis is clean and helpful. Essentially, you're reliably executing the core procurement processes, making life easier for everyone else, and catching errors before they become problems.
Decision-Making Authority
- Type: Supplier Selection (Routine)
- Entry: Escalate all supplier selection decisions to supervisor.
- Mid: Can select from pre-approved supplier lists for RFQs under £5K, following strict criteria. Escalate if criteria are not met or if value exceeds £5K.
- Senior: Can select preferred suppliers for projects up to £50K within a defined category, with manager consultation.
- Type: Contract Terms Negotiation
- Entry: No negotiation authority. Pass all terms to supervisor for review.
- Mid: Can clarify standard terms with suppliers but cannot agree to changes. Escalate any requested deviations to Legal/Manager.
- Senior: Can negotiate non-material commercial terms (e.g., payment schedule) within pre-approved boundaries. Material changes require Legal/Manager approval.
- Type: Process Deviation
- Entry: No authority to deviate from established processes. Must escalate requests for exceptions.
- Mid: Can propose minor process improvements but needs approval. Cannot unilaterally deviate from core process steps.
- Senior: Can recommend and implement process improvements within their workstream, with manager sign-off.
- Type: Budget Allocation (Project)
- Entry: No budget authority.
- Mid: Can track and report spend against project budgets, but no authority to approve or reallocate funds.
- Senior: Can manage project budgets up to £10K, making recommendations for spend optimisation.
ID:
Tool: Automated Bid Analysis
Benefit: Instead of manually comparing dozens of supplier bids, AI can ingest all the responses, extract key pricing, service levels, and compliance details, and then whip up a comparison scorecard for you in minutes. It'll even flag anything that looks a bit off. That's hours saved per RFQ, letting you focus on the nuances.
ID:
Tool: Predictive Commodity Tracking
Benefit: Forget spending ages trawling news sites and market reports. AI can crunch market data, geopolitical headlines, and even weather patterns to give you a heads-up on potential price changes for key materials. You'll get insights that help us decide the best time to buy, without the manual research slog.
ID:
Tool: Intelligent Supplier Discovery
Benefit: Need to find new suppliers for a niche product? AI can scan millions of company profiles, certifications, and risk databases to give you a pre-vetted list of potential partners. It's like having a super-powered search engine that understands exactly what we need, saving you a ton of research time.
ID: ✍️
Tool: Contract Risk Summarisation
Benefit: When a new supplier contract lands, AI can quickly scan it, pull out the most important clauses, and highlight anything that deviates from our standard legal terms. It gives you a quick summary of potential risks, cutting down on the initial review time before it even gets to Legal. Less reading, more understanding.
Expect to save roughly 15-25 hours per week on repetitive tasks once you're up to speed with our AI tools.
Weekly time savings potential
We'll get you started with 3-4 core AI-powered tools that are relevant to your daily work.
Typical tool investment
Competency Requirements
Foundation Skills (Transferable)
These are the core 'human' skills that underpin everything you do. They're about how you think, how you talk to people, and how you get things done, regardless of the specific task.
- Category: Communication & Collaboration
- Skills: Clear Written Communication: You can write emails and reports that are easy to understand, without jargon. People get your point the first time.
- Active Listening: You really hear what internal clients and suppliers are saying, picking up on nuances and unstated needs.
- Professional Demeanour: You handle interactions with internal teams and external suppliers politely and professionally, even when things get a bit tense.
- Teamwork: You work well with your immediate team, sharing information and helping out when needed.
- Category: Problem-Solving & Initiative
- Skills: Root Cause Analysis (Basic): When something goes wrong (e.g., a PO is stuck), you can figure out *why* it happened, not just fix the symptom.
- Proactive Issue Identification: You spot potential problems before they blow up, like a supplier's contract nearing expiry, and flag it.
- Resourcefulness: When you don't know something, you know how to find the answer or who to ask, without waiting to be told.
- Prioritisation: You can juggle multiple tasks and figure out what needs doing first, especially when new 'urgent' requests come in.
- Category: Adaptability & Learning
- Skills: Openness to Feedback: You take on board constructive criticism and use it to improve your work.
- Learning Agility: You're quick to pick up new systems, processes, and ways of working.
- Comfort with Change: Priorities can shift, and processes can evolve. You're not thrown off by that; you just get on with it.
- Attention to Detail: You catch the small errors that others miss, especially in data or documents.
Functional Skills (Role-Specific Technical)
These are the specific skills and tools you'll need to actually do the job. Think of them as your Procurement toolkit.
Technical Competencies
- Skill: RFx Process Management (Simple)
- Desc: You understand the basic steps for running a Request for Quotation (RFQ). This means you can draft the document, send it out, collect bids, and do a simple comparison. You know what information to ask for and how to present it.
- Level: Intermediate
- Skill: Spend Analysis & Opportunity Identification (Basic)
- Desc: You can take raw spend data, usually from an export, clean it up in a spreadsheet, and categorise it. You're able to spot obvious areas where we might be able to save money, like buying the same thing from different suppliers.
- Level: Intermediate
- Skill: Supplier Onboarding & Due Diligence
- Desc: You know how to get a new supplier set up in our system. This includes collecting all their necessary documentation (like bank details, tax info, insurance), checking it for accuracy, and making sure all our internal checks are completed before they can be paid.
- Level: Intermediate
- Skill: Contract Administration & Compliance
- Desc: You can upload executed contracts into our system, accurately populate all the key fields (like expiry dates, values, key terms), and understand the importance of tracking these. You know what a standard commercial term looks like.
- Level: Intermediate
- Skill: Procure-to-Pay (P2P) Cycle Knowledge
- Desc: You understand the full journey of a purchase, from someone needing something (requisition) to us sending an order (PO), receiving the goods, and finally paying the invoice. You know how each step connects.
- Level: Intermediate
Digital Tools
- Tool: SAP Ariba / Coupa (P2P / Sourcing Suite)
- Level: Intermediate
- Usage: You'll use it every day to process purchase requisitions, convert them into POs, track their status, and help onboard new suppliers. You'll also run pre-built spend reports.
- Tool: Microsoft Excel / Google Sheets
- Level: Intermediate
- Usage: Absolutely essential. You'll use it for cleaning raw spend data, creating simple bid comparison sheets, tracking project status, and basic analysis (PivotTables, VLOOKUPs).
- Tool: DocuSign CLM / Icertis (Contract Lifecycle Management)
- Level: Basic
- Usage: You'll upload executed contracts, populate metadata fields, and track important dates like expiry and renewal. You might run simple reports on contract status.
- Tool: MS Teams / Slack
- Level: Intermediate
- Usage: Used constantly for internal communication, sharing files, getting quick answers, and providing status updates on your projects.
- Tool: Microsoft PowerPoint / Google Slides
- Level: Basic
- Usage: You'll occasionally help put together slides for team meetings or simple internal updates, usually using existing templates.
Industry Knowledge
- Area: Procurement Best Practices (Basic)
- Desc: You understand why we run RFQs, why we need multiple bids, and why supplier due diligence is important. You know the basics of ethical sourcing.
- Area: Supply Chain Fundamentals (Basic)
- Desc: You have a basic grasp of how goods and services move from supplier to us, and the different stages involved. You understand simple concepts like lead times.
Regulatory Compliance Regulations
- Reg: General Data Protection Regulation (GDPR)
- Usage: You'll know not to share supplier personal data inappropriately and understand the basics of handling sensitive information in contracts and supplier records.
- Reg: Anti-Bribery and Corruption (ABC) Laws
- Usage: You'll understand the importance of fair and transparent sourcing processes and know to report any suspicious supplier behaviour or requests.
Essential Prerequisites
- A solid understanding of basic office software, especially Excel (you'll be using PivotTables and VLOOKUPs regularly).
- Experience working in an administrative, finance, or supply chain support role for at least 2 years.
- The ability to follow detailed instructions and processes without cutting corners.
- A knack for spotting errors and inconsistencies in data or documents.
- Good communication skills – you can write a clear email and talk professionally to suppliers and colleagues.
Career Pathway Context
We're looking for someone who's already got a couple of years under their belt in a similar environment. You won't be starting from scratch, but you'll be ready to dive into our specific procurement processes and tools. This isn't an entry-level 'learn everything from zero' role, but it's definitely a place to build serious expertise.
Qualifications & Credentials
Emerging Foundation Skills
- Skill: Prompt Engineering & LLM Integration (Basic)
- Why: Honestly, competitors are already using tools like ChatGPT and Claude to draft RFQ sections, summarise contracts, and even help with initial supplier research in minutes. If you can master this, you'll be dramatically more productive than your peers.
- Concepts: [{'concept_name': 'Effective Prompting', 'description': 'Learning how to ask AI questions in a way that gets you useful, accurate answers, rather than generic fluff.'}, {'concept_name': 'Context Windows', 'description': "Understanding how much information an AI can 'remember' at once, and how to feed it relevant data efficiently."}, {'concept_name': 'Output Validation', 'description': "Knowing that AI can 'hallucinate' (make things up) and how to critically check its outputs for accuracy and bias."}, {'concept_name': 'Ethical AI Use', 'description': "Understanding the company's guidelines on what data can and can't be put into public AI models."}]
- Prepare: This week: Start playing around with ChatGPT or Claude for simple tasks like drafting emails or summarising articles. Just get comfortable with it.
- This month: Try using an AI tool to help you draft a section of an RFQ or summarise a supplier's response. Compare it to your manual effort.
- Month 2: Experiment with using AI to help clean and categorise a small dataset from a spend report. See how it performs.
- Month 3: Share your findings and any productivity gains with your team. Show them what you've learned.
- QuickWin: Use AI to draft your daily emails or summarise long internal documents. It's low-risk and gives immediate time back.
- Skill: Basic Data Visualisation & Storytelling
- Why: It's not enough to just have the data; you need to be able to show people what it means quickly and clearly. As you move up, you'll be asked to present your findings, and a good chart tells a story faster than a spreadsheet.
- Concepts: [{'concept_name': 'Chart Types', 'description': 'Knowing when to use a bar chart vs. a pie chart, and which ones are best for showing comparisons or trends.'}, {'concept_name': 'Clear Labelling: Making sure your charts are easy ', 'description': 'Clear Labelling: Making sure your charts are easy to understand at a glance, with clear titles and axis labels.'}, {'concept_name': 'Audience-Centric Design: Tailoring your visualisat', 'description': "Audience-Centric Design: Tailoring your visualisations to who you're presenting to – what do they care about?"}, {'concept_name': 'Highlighting Key Insights: Using visuals to draw a', 'description': 'Highlighting Key Insights: Using visuals to draw attention to the most important points in your data.'}]
- Prepare: This month: Spend an hour or two watching tutorials on basic charting in Excel or Google Sheets. Practice making different types of charts.
- Month 2: Try to create a simple dashboard (even just 2-3 charts) for one of your spend analysis reports. Get feedback from your Senior Analyst.
- Month 3: Look at how others in the team present data. What works well? What could be clearer?
- Month 4: Take a free online course on data visualisation fundamentals (e.g., from Coursera or edX).
- QuickWin: Every time you create a spreadsheet, try to add one simple, clear chart that summarises a key finding. It's a small step, but it builds the habit.
Advancing Technical Skills
- Skill: Advanced Excel / Google Sheets for TCO Modelling
- Why: You'll move beyond just comparing prices to understanding the 'Total Cost of Ownership' (TCO). This means building more complex spreadsheets that factor in things like maintenance, shipping, training, and even end-of-life costs. Excel will still be your friend here, but you'll need to use more advanced functions.
- Concepts: [{'concept_name': 'INDEX/MATCH & XLOOKUP', 'description': 'More powerful ways to pull data from different tables than simple VLOOKUPs.'}, {'concept_name': 'Conditional Formatting: Making your spreadsheets v', 'description': 'Conditional Formatting: Making your spreadsheets visually highlight key data points or risks.'}, {'concept_name': 'Data Validation: Building in checks to prevent err', 'description': 'Data Validation: Building in checks to prevent errors when others use your spreadsheets.'}, {'concept_name': 'Scenario Analysis: Setting up models to show how d', 'description': 'Scenario Analysis: Setting up models to show how different assumptions (e.g., fuel prices) impact total cost.'}]
- Prepare: This quarter: Ask your Senior Analyst for examples of TCO models they've built. Try to reverse-engineer them.
- Next quarter: Take an advanced Excel course focused on financial modelling or data analysis.
- Month 6: Volunteer to build a simple TCO model for an upcoming RFQ, even if it's just a small part of it.
- QuickWin: Start using INDEX/MATCH instead of VLOOKUP in your daily work. It's more flexible and a good habit to build.
- Skill: Power BI / Tableau (Basic Reporting)
- Why: While Excel is great for analysis, interactive dashboards are becoming the standard for presenting spend data. You'll need to understand how to pull data into these tools and build basic visualisations that others can easily explore.
- Concepts: [{'concept_name': 'Connecting Data Sources', 'description': 'Understanding how to link your spend data (e.g., from SAP Ariba) to a visualisation tool.'}, {'concept_name': 'Dashboard Design Principles: How to lay out inform', 'description': "Dashboard Design Principles: How to lay out information so it's clear and easy to navigate."}, {'concept_name': 'Basic Charting in BI Tools: Creating bar charts, l', 'description': 'Basic Charting in BI Tools: Creating bar charts, line graphs, and tables within Power BI or Tableau.'}, {'concept_name': 'Filtering & Slicing Data: Allowing users to intera', 'description': 'Filtering & Slicing Data: Allowing users to interact with the dashboard to see different views of the data.'}]
- Prepare: This quarter: Watch introductory tutorials on Power BI or Tableau. Many are free online.
- Next quarter: Try to replicate one of your Excel spend reports as a simple dashboard in Power BI/Tableau.
- Month 6: Ask if you can shadow someone who uses these tools regularly to see their workflow.
- QuickWin: Download the free desktop version of Power BI or Tableau Public and try to connect to a simple CSV file. Just get your hands on it.
Future Skills Closing Note
Don't feel overwhelmed by this list. These are skills you'll develop over time. The key is to have a growth mindset and be curious about how new tools and techniques can make your job easier and more impactful. We're here to support your learning journey, providing access to courses and internal experts.
Education Requirements
- Level: Minimum
- Req: A-levels (or equivalent vocational qualification, e.g., NVQ Level 3/4) in a relevant subject like Business Studies, Economics, or Supply Chain.
- Alts: We're open to candidates with demonstrable experience (3+ years) in a similar administrative or support role, even if you don't have formal A-levels. Show us you can do the job, and that counts.
- Level: Preferred
- Req: A Bachelor's degree (or equivalent) in Business, Supply Chain Management, Economics, or a related field.
- Alts: If you've got a strong track record and relevant certifications, we'd still be keen to chat, even without a degree.
Experience Requirements
You'll need roughly 2-5 years of experience in a procurement, purchasing, or supply chain support role. We're looking for someone who's already processed POs, dealt with suppliers, and has a good grasp of office software, especially Excel. Experience with an e-procurement system like SAP Ariba or Coupa is a big plus, but not a deal-breaker if you're a quick learner.
Preferred Certifications
- Cert: CIPS Level 3 or 4 (Certificate or Diploma in Procurement and Supply)
- Prod: Chartered Institute of Procurement & Supply (CIPS)
- Usage: Shows you're serious about a career in procurement and have a solid foundation in the principles and practices of good buying. We often support employees in gaining these qualifications.
- Cert: Lean Six Sigma Yellow Belt
- Prod: Various (e.g., BSI, ASQ)
- Usage: Demonstrates an understanding of process improvement, which is really helpful for making our procurement processes more efficient and less wasteful. It shows you're thinking about how to make things better.
Recommended Activities
- Attending industry webinars and online courses on specific procurement topics (e.g., contract law basics, negotiation tactics).
- Reading procurement publications and blogs to stay up-to-date with market trends and best practices.
- Participating in internal training sessions on our P2P system or new software.
- Seeking out mentorship from more senior members of the Procurement team.
Career Progression Pathways
Entry Paths to This Role
- Path: Sourcing Coordinator / Procurement Administrator
- Time: 1-2 years
- Path: Finance / Accounts Payable Assistant
- Time: 2-3 years
- Path: Supply Chain / Logistics Coordinator
- Time: 2-4 years
Career Progression From This Role
- Pathway: Senior Sourcing Analyst (Level 3)
- Time: 2-3 years in the Sourcing Assistant role.
Long Term Vision Potential Roles
- Title: Lead Sourcing Specialist (Level 4)
- Time: 5-8 years from Sourcing Assistant
- Title: Sourcing Manager / Category Manager (Level 5)
- Time: 8-12 years from Sourcing Assistant
- Title: Director of Strategic Sourcing (Level 6)
- Time: 12-16 years from Sourcing Assistant
Sector Mobility
The skills you learn in procurement are highly transferable. You could move into broader supply chain roles, operations management, or even consulting. Every company buys things, so a good procurement professional is always in demand, regardless of the industry.
How Zavmo Delivers This Role's Development
DISCOVER Phase: Skills Gap Analysis
Zavmo maps your current competencies against all requirements in this job description through conversational assessment. We evaluate your foundation skills (communication, strategic thinking), functional skills (CRM expertise, negotiation), and readiness for career progression.
Output: Personalised skills gap heat map showing strengths and priorities, estimated time to competency, neurodiversity accommodations.
DISCUSS Phase: Personalised Learning Pathway
Based on your DISCOVER results, Zavmo creates a personalised learning plan prioritised by impact: foundation skills first, then functional skills. We adapt to your learning style, pace, and neurodiversity needs (ADHD, dyslexia, autism).
Output: Week-by-week schedule, each module linked to specific job responsibilities, checkpoints and milestones.
DELIVER Phase: Conversational Learning
Learn through conversation, not boring modules. Zavmo uses 10 conversation types (Socratic dialogue, role-play, coaching, case studies) to build competence. Practice difficult QBR presentations, negotiate tough renewals, and handle churn conversations in a safe AI environment before facing real clients.
Example: "For 'Stakeholder Mapping', Zavmo will guide you through analysing a complex enterprise account, identifying key decision-makers, and building an engagement strategy."
DEMONSTRATE Phase: Competency Assessment
Zavmo automatically builds your evidence portfolio as you learn. Every conversation, practice scenario, and application example is captured and mapped to NOS performance criteria. When ready, your portfolio supports OFQUAL qualification claims and demonstrates competence to employers.
Output: Competency matrix, evidence portfolio (downloadable), qualification readiness, career progression score.