Pricing Analyst

We are working with a leading provider of specialist cleaning and facilities management solutions. As they continue to expand, they are looking for a detail-oriented Pricing Analyst to bridge the gap between the Sales and Finance teams, ensuring every tender and contract is both competitive and profitable. The Pricing Analyst will be the commercial engine behind the customer proposals. You will take operational data (labor hours, cleaning frequencies, material costs) and financial targets to build accurate, data-driven pricing models. Working directly with the Sales team (to win business) and Finance (to protect margins), you will ensure the business remains the preferred choice for clients without compromising on profitability.

Key Responsibilities

• Data Analysis and Pricing (Excel Heavy): Input, organize, and cleanse large datasets (e.g., square footage, site visit frequencies, wage data) to calculate per-customer cleaning service pricing. Develop and maintain complex Excel pricing models using advanced formulas, VLOOKUPs, and pivot tables to simulate labor scheduling and cost absorption. Analyze historical contract performance to recommend price adjustments for renewals or upsells.
• Cross-Functional Collaboration: Partner with the Sales team to translate client Requests for Proposals (RFPs) into accurate cost-to-serve models. Work with Finance to embed overhead allocation, National Living Wage changes, and PPE/chemical costs into all pricing templates. Act as the gatekeeper for pricing governance, ensuring no bid goes to a client without a validated margin check.
• Template and Tool Management: Maintain and update the business master pricing templates and tools, ensuring they reflect current supplier costs (e.g., janitorial supplies) and labour legislation. Build standardized what-if scenarios to help Sales quickly adjust service levels (daily vs. weekly cleaning) without breaking profitability.
• Reporting and Insights: Generate weekly/monthly pricing reports to show win/loss ratios by service type and margin leakage. Provide post-bid analyses to explain why certain pricing won or lost a contract, offering actionable insights for future tenders.
• Compliance and Governance: Ensure all proposed pricing complies with the business pricing policies, financial targets, and minimum margin thresholds. Maintain an audit trail of pricing versions to support client negotiations.

Qualifications and Requirements

Essential

• Advanced Excel Proficiency: You must be comfortable with nested formulas, pivot tables, data validation, and lookups (INDEX:MATCH/XLOOKUP). Ability to build a dynamic pricing model from scratch is a plus.
• Numerical Accuracy: Flawless attention to detail; the ability to spot a misaligned decimal or incorrect labor minute before it costs the company thousands.
• Communication Skills: You can explain to a Salesperson why a price went up (due to travel time, consumables, etc.) without using complex finance jargon.
• Deadline-Driven: Ability to manage 5+ concurrent pricing requests during peak tender season without sacrificing accuracy.

Desirable (but Not Required)

• Previous experience in Facilities Management, Cleaning, or Logistics (understanding of minimum wage bands, holiday pay accrual, or shift-based staffing).
• Experience with CRM/ERP systems (e.g., Salesforce, Sage, or Power BI).
• Basic understanding of UK employment law regarding wage calculations (if UK-based) or relevant local labor laws.