Commercial Analyst

Job Description

Join us, be part of more.

We’re so much more than an energy company. We’re a family of brands revolutionising how we power the planet. We're energisers. One team of 21,000 colleagues that's energising a greener, fairer future by creating an energy system that doesn’t rely on fossil fuels, whilst living our powerful commitment to igniting positive change in our communities. Here, you can find more purpose, more passion, and more potential. That’s why working here is #MoreThanACareer. We do energy differently - we do it all. We make it, store it, move it, sell it, and mend it.

About your team:

At Dyno-Rod, our mission is to mend it.

We’re one of the UK’s largest plumbing and drainage forces. From blocked drains to burst pipes, we’re here to help our customers. We’re proud to offer 24-hour emergency response across the UK, using a combination of the latest technology and good old-fashioned expertise to fix a wide range of home emergencies.

Dyno-Rod has an exciting opportunity for an experienced Commercial Analyst to join our team.

Please Note: This is a 12 – 18 month secondment / fixed term contract

• Full-time 37 hours per week
• 12 – 18 month secondment / fixed term contract
• Hybrid – working from home and from the Stockport office

The Commercial Analyst plays a key role in driving strong commercial performance across the franchise network by delivering high‑quality analysis, insight and commercial models.

The role focuses on commercial performance, rate modelling, contract schedules, franchise collaboration and data‑led insight, working closely with Franchisor teams, Franchisees, and central Finance teams. The Commercial Analyst ensures commercial frameworks remain aligned to work delivered, supports ongoing rate and contract reviews, and enables informed decision‑making through robust data and reporting.

This role requires strong analytical capability, advanced systems knowledge (Power BI, Dynamics 365, SQL, Excel), and a solid understanding of commercial and financial drivers including revenue and profitability.

Key Accountabilities (but not limited to)

Commercial Analysis & Performance Insight:

• Analyse franchise operational and commercial data to assess performance against agreed rate structures, commercial frameworks and contractual terms.
• Translate job activity (job types, visits, job duration, travel time, materials usage) into clear commercial insight, linking activity to revenue and margin outcomes.
• Identify trends, risks and opportunities across franchises, channels and territories to support commercial decision‑making.
• Provide clear, evidence‑based insight to Commercial, Finance and Operational stakeholders to drive performance improvement.

Rate Models, Reviews & Commercial Frameworks:

• Build, maintain and enhance commercial rate models, ensuring assumptions reflect real‑world delivery and remain commercially sustainable.
• Support ongoing rate reviews across channels (e.g. BG, Key Accounts, DRD), including interim and annual reviews.
• Analyse job times, visit patterns and job mix year‑on‑year, including franchise‑level comparisons and behavioural drivers (e.g. multiple issues per visit, booking constraints).
• Review materials spend, thresholds and banding logic, assessing true cost impact to both Dyno‑Rod and franchises and proposing alternative models where required.
• Support the maintenance and governance of rate cards, contract schedules and regional uplifts, ensuring accuracy, consistency and transparency.
• Analyse the commercial impact of proposed rate changes, banding updates or contractual amendments, clearly articulating financial implications.

Franchise & Stakeholder Collaboration:

• Work closely with Franchisor teams, Franchisees, Commercial and Finance teams to support strong commercial outcomes.
• Act as a trusted analytical partner to franchises, supporting discussions on performance, rates, materials, labour assumptions and commercial queries.
• Support the creation and maintenance of commercial FAQs and guidance, clearly explaining rate logic, inclusions/exclusions, methodologies and assumptions.
• Support franchise‑facing reporting and views, improving transparency of charges, rates and performance.

SQL, Reporting & Data Ownership:

• Use SQL queries to extract, join and analyse large datasets from Dynamics 365 and related systems.
• Develop and maintain trusted datasets and views to support commercial analysis, rate reviews and Power BI reporting.
• Reconcile commercial datasets against D365 source data to ensure accuracy, completeness and consistency.
• Design, build and maintain dashboards and MI in Power BI, improving visibility of commercial and operational performance.
• Document assumptions, methodologies and data logic to ensure outputs are transparent, repeatable and well‑governed.

Process Improvement & Commercial Governance:

• Identify and implement process improvements that improve efficiency, accuracy and consistency across commercial reporting and analysis.
• Support the automation of elements of the rate model (e.g. salary banding, regional uplifts) to reduce manual intervention.
• Work with Systems and Data teams to document, resolve and prevent data or reporting issues.
• Support governance of commercial deductions, charges and schedules, ensuring alignment across systems and stakeholders.
• Contribute to cross‑functional initiatives including external rate model reviews and commercial deep dives.

The Person

• Commercially astute and strongly data‑led.
• Agile thinker with a proactive, problem‑solving mindset.
• Confident collaborator who builds strong relationships across teams and franchises.
• Driven to improve how commercial insight is produced and applied.
• Passionate about learning and developing analytical and technical skills.

Skills, Experience & Qualifications Required

Essential:

• Experience in a commercial analyst, finance or data‑driven analytical role.
• Strong commercial and analytical mindset with a clear understanding of revenue and profitability drivers.
• Strong SQL capability, including writing queries to extract, join and analyse large datasets.
• Proven experience using Power BI to build dashboards and commercial MI.
• Advanced Excel skills, including formulas, analysis and structured modelling.
• Ability to interpret complex and sometimes conflicting datasets to identify true performance drivers.
• Strong attention to detail with high standards for accuracy and consistency.
• Ability to clearly communicate commercial insight to non‑technical stakeholders.

Desirable:

• Working knowledge of Dynamics 365 or similar ERP / CRM systems.
• Experience supporting rate modelling, rate reviews or contract schedules.
• Experience working with franchise, partner or multi‑channel operating models.
• Exposure to continuous improvement, reporting automation or external commercial reviews.

Qualifications:

• Degree (or equivalent experience) in Finance, Business, Economics, Data Analytics, Mathematics or a related discipline.
• Professional finance or data qualifications are desirable but not essential.

Why should you apply?

We’re not a perfect place – but we’re a people place. Our priority is supporting all of the different realities our people face. Life is about so much more than work. We get it. That’s why we’ve designed our total rewards to give you the flexibility to choose what you need, when you need it, making sure that you and your family are supported not only financially, but physically and emotionally too. Visit the link below to discover why we’re a great place to work and what being part of more means for you.

https://www.morethanacareer.energy/dyno

If you're full of energy, fired up about sustainability, and ready to craft not only a better tomorrow, but a better you, then come and find your purpose in a team where your voice matters, your growth is non-negotiable, and your ambitions are our priority.

Help us, help you. We would love for you to share any information about yourself throughout our recruitment process so that we can better understand you and help shape your journey.