Commercial Analyst

JOHN LEWIS; Darwen; On-site; GBP 47,000 - 50,000; Full time

Job summary

Herbert Parkinson, part of the John Lewis Partnership, seeks a Commercial Analyst to safeguard margins and drive growth through pricing execution and margin analysis. You will own BOMs, labour timings, and ensure data integrity across the ERP system from our Darwen office.

The role emphasises data-driven pricing and collaboration with Finance, Sales, and Supply Chain to support budgeting and negotiations.

Qualifications

• Demonstrable experience in a cost analyst or product data role in manufacturing sector.
• Advanced proficiency in data modelling techniques & analytics.
• Ability to translate complex data into clear, concise reports & recommendations.
• Possesses excellent interpersonal skills.
• Attention to detail.

Responsibilities

• Build and maintain product cost models to evaluate labour, raw material, and other variable costs, ensuring target gross margins are achieved on all new and existing products.
• Monitor raw material price fluctuations, labour inflation, and market trends to recommend timely price adjustments and mitigate margin erosion.
• Support in the creation & validation of customer quotes, price lists, and promotional pricing structures.
• Provide clean, validated commercial data to Finance, Sales, and Supply Chain teams to support budgeting, forecasting, and contract negotiations.
• Manage the accurate creation and continuous maintenance of product setups, labour timings and BOMs within the ERP system.
• Support the Product manager in the timely exiting of products & removal of associated BOMs and timings.

Skills

Cost analysis

Data modelling

Data translation & reporting

Interpersonal skills

Attention to detail

Tools

ERP system

Job description

About the role

At Herbert Parkinson, a proud and historic part of the John Lewis Partnership, we are embarking on an exciting transformation journey to secure our long-term success. By investing in state-of-the-art manufacturing capabilities, streamlining our operations, and creating broader, more fulfilling roles for our Partners, we are building a more sustainable and agile future. Join us as we continue to deliver exceptional quality and service for our customers while empowering our partners to thrive.

As a Commercial Analyst, you will protect business margins and power commercial growth through accurate pricing execution, thorough margin analysis, and immaculate system data. Bridging pricing strategy, product costing, and system setup, you will take ownership of BOMs and labour timings data while driving strict data integrity across the ERP system.

• Expected salary - £46,500 - £50,000 (dependent on experience).
• Contract type - This position is a Permanent role. 38.75 Hours per week
• Location - This role is based at our Herbert Parkinson Office in Darwen, Lancashire.

Key responsibilities

• Build and maintain product cost models to evaluate labour, raw material, and other variable costs, ensuring target gross margins are achieved on all new and existing products
• Work with internal stakeholders to monitor raw material price fluctuations, labour inflation, and market trends to recommend timely price adjustments and mitigate margin erosion
• Support in the creation & validation of customer quotes, price lists, and promotional pricing structures
• Provide clean, validated commercial data to Finance, Sales, and Supply Chain teams to support budgeting, forecasting, and contract negotiations
• Manage the accurate creation and continuous maintenance of product setups, labour timings and Bill of Materials (BOMs) within the ERP system. Processing BOM and timing changes stemming from material changes, product redesigns or supplier updates to support accurate costing and protect business margins
• Support the Product manager in the timely exiting of products & removal of associated BOMs and timings in the most efficient way ensuring no business risk or impact to customers

Essential skills/experience you'll need

• Demonstrable experience in a cost analyst or product data role in manufacturing sector
• Advanced proficiency in data modelling techniques & analytics
• Ability to translate complex data into clear, concise reports & recommendations
• Possesses excellent interpersonal skills
• Attention to detail

Desirable skills/experience you may have

• Sounds knowledge of Continuous Improvement methodologies

The partnership

We're the largest employee owned business in the UK and home of our cherished brands, John Lewis and Waitrose. We're not just employees, we're Partners, driven by our purpose to build a happier world. As we look to our future, there's never been a more exciting time to join us.

We're ruthlessly focused on being brilliant at retail. We continue to innovate, adapt and diversify. Never Knowingly Undersold on price, quality and service in John Lewis and passionately serving food-lovers in Waitrose.

As Partners we all share the responsibility of ownership and in its rewards. We use our voices to contribute to our success, working together through the good and challenging times, holding true to our behaviours and treating everyone with kindness and respect.

We all own making the Partnership somewhere we belong. Embracing our differences and creating an environment where we're free to be ourselves and can THRIVE. Growing ourselves individually, and as a collective.

As Partners, we make all the difference. And, we all own it.

Important points to note:

It's important to note that some of our roles are subject to pre-employment vetting (which may include DBS checks for successful candidates). If required, you'll be informed and provided with information about vetting during the recruitment process and we encourage you to complete any vetting documents quickly to avoid delays. Any DBS checks required will be carried out by a third-party registered body and financial probity checks may also be required for some of our roles.

We occasionally close vacancies early in the event we receive a high volume of applications, and therefore, we recommend you apply early. If you require a reasonable adjustment due to a disability which means you may need longer to complete your application please contact us as soon as possible.

We want all of our Partners to have a good work-life balance and we support flexible working. This might mean flexible or compressed hours, job sharing or shorter hour contracts, where possible. Please discuss this further with the hiring manager during your interview.