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.
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.
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.
Supply Chain Business Analyst / Excel Modelling in England employer: Vallum Associates
As an Electronics Test Engineer at our company, you will be part of a dynamic and innovative team dedicated to pushing the boundaries of technology in a collaborative work environment. We offer competitive benefits, a strong focus on employee development, and opportunities for career advancement, all while being located in a vibrant area that fosters creativity and growth. Join us to make a meaningful impact in the field of electronics testing and enjoy a rewarding career with us.
