Oliver Wyman - Senior Analyst - Procurement

About Oliver Wyman

At Oliver Wyman, a Marsh (NYSE: MRSH) business, we bring deep industry insight, bold innovation, and a collaborative approach that cuts through complexity to help organizations navigate their most defining transformative moments.

As a business of Marsh, we work alongside the world’s leading experts across risk, reinsurance and capital, people and investments, and management consulting. Together with Marsh Risk, Guy Carpenter, and Mercer, we help organizations build resilience and competitive advantages from every angle. With annual revenue over $24 billion and more than 90,000 colleagues in 130 countries, Marsh helps build the confidence to thrive through the power of perspective.

For more information, visit oliverwyman.com, or follow us on LinkedIn and X

OW DNA Overview

The Oliver Wyman DNA is a distinguished center of excellence for business analytics and data analytics within Oliver Wyman. This group leverages data and information to provide business insights to Oliver Wyman consulting teams driving positive outcomes and tangible impact for Oliver Wyman’s clients. The group combines cutting edge data science expertise with core consulting expertise to augment engagement teams with analytical firepower to deliver outstanding results.

Role Summary:

The Senior Business Analyst will own and deliver end-to-end analytical work across procurement workstreams with a high degree of independence and ownership. This is a deeply technical and self-driven role—the right candidate structures their own thinking, writes their own code, builds their own models, and produces client-ready outputs with minimal hand-holding. The role demands expert-level SQL and advanced Excel modelling, and demonstrated hands-on experience applying AI and machine learning to procurement and spend analytics challenges. Consulting experience is a plus, but strong independent problem-solving and technical rigor are non-negotiable.

Key Responsibilities

This role is built around three core pillars. The right candidate excels across all three and is able to operate independently within each—owning the problem, the approach, and the output.

Technical Delivery & Procurement Analytics

• Extract, cleanse, classify, and harmonise spend data from ERP/AP/PO systems; build multi-dimensional spend cubes (category, supplier, BU, geography, time) with drill-down insights.

• Identify and quantify savings levers (price, demand, specification, supplier consolidation, process); build opportunity pipelines with clear assumptions and audit trails.

• Develop should-cost models using BOM, labour, overhead, logistics, commodity indices, and FX drivers; benchmark supplier quotes vs. modelled cost to support negotiations.

• Build advanced, well-structured, consulting grade Excel models that serve as standalone decision-support tools stakeholders can use directly.

• Write and optimise complex SQL queries and Python scripts for data extraction, transformation, modelling, and repeatable analytical pipelines.

• Interpret financial statements to uncover cost leakages, working capital inefficiencies, and commercial optimisation opportunities; link analytical outputs to measurable business value.

AI & Advanced Procurement Analytics

• Apply Generative AI tools (GPT-4o, GitHub Copilot, Microsoft Copilot) to accelerate contract analysis, category strategy drafting, RFP summarisation, and supplier benchmarking; build reusable prompt libraries and AI-assisted workflow templates for the team.

• Build and deploy ML-based spend classification pipelines that automate category tagging at scale, moving beyond manual taxonomy mapping.

• Develop predictive models for commodity price forecasting, demand volatility, lead-time variability, and supplier risk scoring using historical ERP and market data.

• Apply NLP and text-mining to extract structured insights from unstructured sources: contracts, invoices, supplier communications, and commodity news feeds.

Independent Problem Solving & Delivery

• Independently translate ambiguous business questions into structured problem statements, define the analytical approach, execute end-to-end, and package the output—without requiring day-to-day direction.

• Manage multiple workstreams simultaneously: own planning, task prioritisation, dependency tracking, and quality review across all deliverables.

• Build analytical frameworks, templates, and reusable assets that drive consistency and long-term efficiency across the team.

• Communicate findings in a clear, business-oriented manner to internal teams and senior stakeholders; translate insight into actionable recommendations.

• Proactively identify automation and AI opportunities within your own work and implement them—without waiting to be directed.

Experience & Skills Requirements

Must-Have

• 4–6+ years of hands-on experience in procurement analytics, spend analytics, cost modelling, or sourcing analytics.

• Advanced Excel proficiency: Expert in building excel models which help driving business decisions, Excel is a primary delivery medium in this role.

• Advance SQL and Python for data extraction, transformation, and modelling (non-negotiable)—you write and own your own code.

• Deep procurement domain knowledge: categories, sourcing, contracts, P2P/S2P, supplier management, and spend taxonomy

• Demonstrated hands-on experience applying AI or ML in a procurement or supply chain context, must be able to articulate specific tools used, use cases delivered, and measurable outcomes.

• First-principles thinking with the ability to independently structure problems, define an approach, and execute end-to-end with minimal supervision.

• Entrepreneurial and self-directed—proactively identifies opportunities, takes full ownership, and delivers without needing to be chased.

• Strong analytical rigour and data QA discipline: comfortable managing messy datasets and building repeatable, auditable outputs.

Good-to-Have

• Consulting or analytics-as-a-service background.

• Familiarity with ERPs and procurement suites

• Experience guiding or reviewing the work of junior analysts.

• Client-facing or stakeholder presentation experience at a senior level.