Products Freight Analyst

Shell; Greater London; On-site; GBP 70,000 - 100,000; Full time

Job summary

Shell in the United Kingdom is seeking a Products Freight Analyst to join the Global Products Freight team. You will deliver tradeable market insights, build analytical tools, and partner with traders, finance, and other stakeholders to support profitable, compliant freight operations.

The role emphasizes developing short- and long-term analyses of supply/demand, building models in Python and Excel, creating MI dashboards, and presenting insights at routine commercial meetings.

Qualifications

• Strong analytical capability in freight, shipping, commodities, or maritime analytics.
• Advanced Excel (including VBA) required; Python or similar coding proficiency strongly preferred.
• Ability to automate datasets, build structured models, and translate data into meaningful insights.
• Solid understanding of maritime market fundamentals (vessel classes, flows, congestion, asset valuation).
• Experience with external freight analytics tools (e.g., Signal Ocean, Vortexa) beneficial.

Responsibilities

• Develop and own short-term and long-term analysis of Products Freight supply/demand, including vessel trends, regional flows, and seasonal patterns.
• Convert data from multiple sources into actionable trade insights.
• Build and enhance analytical models using Python and/or advanced Excel to support various analyses.
• Produce and present weekly freight market analysis and benchmarks for routine meetings.
• Lead MI dashboards development and automation; integrate third-party data for new modelling.

Skills

Freight analytics

Python

Excel VBA

Data automation

Market fundamentals

Stakeholder collaboration

Tools

Signal Ocean

Vortexa

Excel

Job description

United Kingdom

What's the role

The Products Freight Analyst plays a critical role within the Global Products Freight team, supporting commercial decision-making and contributing to profitable and compliant freight operations. This position is designed for an experienced analyst who can independently deliver high-quality tradeable market insights, develop analytical tools, and partner closely with traders, business development, finance, and wider Trading & Supply stakeholders.

This role offers excellent visibility, commercial impact, and the opportunity to shape how the Products Freight desk uses data and analytics to drive performance.

What you'll be doing

1. Develop and own advanced short-term and long-term analysis of Products Freight supply/demand, including vessel newbuild, scrappage trends, regional flows, congestion, and seasonal patterns.

   Convert data from multiple internal and external sources into actionable trade insights.

   Build and enhance analytical models using Python and/or advanced Excel (VBA) to support: Forward curve proxies Stress-testing of freight exposure Regression and correlation analysis across vessel classes Macro and micro market fundamentals

   Produce and present weekly freight market analysis, including fixtures, tonnage lists, bunker trends, emissions metrics, and competitor activity.

   Collaborate with Products trading and oil analytics teams to integrate refinery economics, arbitrage indicators, and product flow projections.

2. Lead the development and continuous improvement of MI dashboards, ensuring accuracy, automation, and clear storytelling.

   Maintain and enhance exposure sheets, outperformance benchmarking, and vessel/route analytics.

   Integrate third-party maritime, flows, and asset data into structured databases to enable automation and new modelling capabilities.

   Deliver high-quality presentations, book reviews, and insights for routine commercial meetings.

   Act as a path-finder in the team for new technology solutions to data problems

3. Work closely with freight traders to provide timely analysis during market events, fixture opportunities, and product trading flows.

   Partner with Business Development to evaluate opportunities such as COA structures, time-charter strategies, triangulation performance, and new product‑freight corridors.

   Engage with brokers, shipowners, and analysts to collect market intelligence and benchmark performance.

4. Maintain and enhance processes for Products Freight P&L reporting and variance analysis.

   Build and operate models that explain drivers of earnings across vessels, regions, and trading books.

   Ensure all systems of record remain updated, accurate, and aligned with trading activity.

What you bring

We are keen to hear from candidates with relevant experience in shipping, freight, energy analytics or trading support and have demonstrated the ability to lead analytical work rather than only supporting it. The ideal candidate will have a proven track record of independently designing, enhancing, and implementing analytical methodologies, coupled with a strong sense of accountability, ownership, and commercial acumen. They should also possess a growth mindset and a genuine desire to continuously deepen their technical expertise and understanding of market dynamics.

We'd also like to see the following:

Technical Skills

• Strong analytical capability with proven experience in freight, shipping, commodities, or maritime analytics.
• Advanced Excel (including VBA) required; Python or similar coding proficiency strongly preferred.
• Ability to automate datasets, build structured models, and translate data into meaningful insights.
• Solid understanding of maritime market fundamentals (vessel classes, flows, congestion, asset valuation, etc.).
• Experience with external freight analytics tools (e.g., Signal Ocean, Vortexa) beneficial.

Commercial & Behavioural Skills

• Demonstrated ability to operate autonomously, prioritise multiple workstreams, and work under time pressure.
• Strong interpersonal skills, with capability to communicate complex analysis to traders, leaders, and cross-functional partners.
• Curious, proactive, and able to challenge established thinking with data‑backed insights.
• Enterprise mindset-comfortable working across global offices and multiple stakeholders.
• Proven ability to identify performance drivers, optimise trading tools, and influence commercial outcomes.

What we offer

You bring your skills and experience to Shell and in return you work with talented, committed people on one of the most important challenges facing our planet. You'll have the opportunity to develop the skills you need to grow in an