Vallum Associates
Supply Chain Business Analyst / Excel Modelling
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
About the Company
We are looking for an experienced Business Analyst and Excel Modelling Consultant to support a focused assessment of a complex global supply-chain operation.
About the Role
Working within a small consultancy project team, you will gather, structure and analyse operational information from more than 30 international sites. You will then develop the Excel-based models needed to understand the current operation, identify improvement opportunities and support the design of a future operating solution.
Responsibilities
- Manage and track information received from more than 30 sites.
- Review submissions and identify missing, inconsistent or unclear data.
- Consolidate information from different sites and systems into a controlled, consistent structure.
- Build and maintain the core Excel assessment and modelling suite.
- Analyse sites, parts, suppliers, inventory, demand, performance and operating arrangements.
- Segment and compare sites, suppliers and part categories.
- Develop the data and analysis behind a global supply-chain network model.
- Model current operational performance and potential improvement opportunities.
- Build scenarios and sensitivities to test alternative assumptions and solutions.
- Compare different service-delivery and operating-model options.
- Quantify potential cost savings, efficiencies and working-capital improvements.
- Support the development of the value case and commercial proposal.
- Prepare analysis for selected site visits and update models following those assessments.
- Present analytical findings clearly to the Assessment Director and wider project team.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Excel Modelling Requirements
A significant part of the assignment will involve developing practical Excel-based models that allow the project team to interrogate the operation and test different solution options. The modelling suite is expected to include:
- Site and network modelling
- Site segmentation and comparison
- Part and product-category analysis
- Supplier and sourcing analysis
- Demand and consumption analysis
- Inventory and working-capital modelling
- Current operational performance
- Service and operating-model comparisons
- Opportunity and value modelling
- Scenario and sensitivity analysis
- Solution-costing and commercial-model inputs
The models must be robust, controlled, transparent and easy for other members of the project team to understand and use.
Qualifications
- Strong, practical Business Analysis and modelling experience.
- Advanced Excel skills, with evidence of building complex models from scratch.
- Experience using functionality such as Power Query, advanced formulas, pivot tables, data validation and scenario analysis.
- Experience consolidating and analysing large datasets from multiple sites, business units or international operations.
- Strong understanding of supply-chain operations, including inventory, demand, suppliers, sourcing or logistics.
- Ability to identify patterns, anomalies, gaps and relationships within incomplete data.
- Experience building models that allow assumptions, scenarios and sensitivities to be adjusted.
- Confidence working directly with operational stakeholders to clarify requirements and challenge inconsistent information.
- Ability to translate detailed analysis into clear findings and commercial recommendations.
- Comfortable working independently within a fast-paced consultancy environment.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Required Skills
Experience in one or more of the following would be particularly valuable:
- Manufacturing or engineering supply chains
- Complex multi-site or global operations
- Supply-chain network assessment or optimisation
- Inventory and working-capital analysis
- Procurement and supplier analysis
- Demand planning and forecasting
- Logistics and material flow
- Bid, tender or commercial modelling
- Cost, pricing or business-case modelling
- Managed services, outsourcing, 3PL or 4PL environments
- ERP data from systems such as SAP, Oracle or Microsoft Dynamics
- VBA, macros, Power BI or SQL
Pay range and compensation package
- Contract: 3 months - initial term
- Day rate: £350–£500 per day
- IR35 status: Outside IR35
- Location: Flexible, with potential travel for selected site assessments
Equal Opportunity Statement
We are committed to diversity and inclusivity.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location