Strategic Tender & Forecasting Analyst

Rubicon Consulting; Ellesmere Port; On-site; GBP 30,000 - 60,000; Full time

Job summary

Rubicon Consulting seeks a data-driven role to support the Head of Pre-Construction & Tendering (UK) by improving consistency, quality and commercial accuracy of UK tenders. The role maintains a resource forecast that translates the live tender pipeline into forecast headcount demand and provides an evidence-based view on cost build-ups and commercial treatments.

The candidate will identify inconsistencies, errors and risk, without owning tender prices or bid decisions, and will work to enhance

Qualifications

• Bachelor's degree or comparable career experience required.
• Excellent written communication and ability to document processes clearly.
• Understanding of commercial terms, cost build-ups, margin, escalation and contingency.

Responsibilities

• Review as-built cable schedules and compare quantities against live projects to mitigate design risk.
• Review tenders for commercial accuracy in cost build-up logic, escalation and indexation.
• Analyse live tenders to ensure pricing consistency across the portfolio by project type, complexity and location.
• Review tender process documentation, templates, checklists and gate deliverables.
• Set up Excel structures to forecast project archetypes and headcount demand.
• Apply probability weighting to pipeline for realistic forecast trends.
• Compare forecast demand against current establishment and committed resources.
• Produce scenario views to support recruitment and subcontracting decisions.
• Refresh, publish and explain the forecast on a monthly cycle.

Skills

Critical thinking

Challenge upward

Multi-tasking

Self-driven

Plain language communication

Microsoft Excel

Education

Bachelor's degree or comparable career experience

Tools

Excel

Job description

Rubicon Consulting seeks a data-driven role to support the Head of Pre-Construction & Tendering (UK) by improving consistency, quality and commercial accuracy of UK tenders. The role maintains a resource forecast that translates the live tender pipeline into forecast headcount demand and provides an evidence-based view on cost build-ups and commercial treatments.

The candidate will identify inconsistencies, errors and risk, without owning tender prices or bid decisions, and will work to enhance