Supply Chain Business Analyst / Excel Modelling

Learn more about the general tasks related to this opportunity below, as well as required skills.

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. xwzovoh

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.