Commercial Analyst & Process Improvement

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.

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 & Process Improvement to join the team.

• Full-time 37 hours per week, Permanent
• Hybrid – working from home and from the Stockport office

The Commercial Analyst & Process Improvement role is critical in protecting commercial value, ensuring revenue integrity, and driving data‑led decision making across the franchise network.

The role combines audit and validation activity, KPI reward calculations, and commercial and performance analysis
, supporting accurate franchise payments, correct franchise invoicing, and the ongoing alignment of commercial rates and incentives with work delivered in the field.

The balance of activity may vary over time in line with business priorities, audit cycles and commercial requirements.

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.

• Deliver structured audit activity across franchise job data, claims, charges and KPI outcomes using defined sampling techniques.
• Identify incorrect, inflated or non‑compliant claims and KPI outcomes by analysing trends, anomalies and exceptions in large datasets.
• Calculate franchise reward payments linked to KPI achievement, ensuring accuracy, consistency and adherence to agreed commercial rules.
• Validate KPI inputs, thresholds and reward logic to ensure payments reflect genuine performance and contractual terms.
• Investigate root causes of discrepancies, gather supporting evidence from franchises and internal systems, and quantify financial impact.
• Liaise closely with cashiering and finance teams to ensure accurate and timely payment of franchise rewards.
• Support the invoicing of clients for franchised activity and incentive‑related charges, ensuring alignment between operational data, rewards paid and revenue billed.
• Produce clear audit and reward calculation outputs highlighting exceptions, trends, financial exposure and control weaknesses.

• Analyse franchise job data including job types, job duration, number of visits and productivity metrics using Dynamics, SQL, Power BI and Excel.
• Perform external benchmarking and internal comparative analysis to ensure commercial rates and incentives align with work delivered.
• Translate operational performance into financial insight, linking activity and KPI outcomes to revenue and profit.
• Support pricing, rate reviews and incentive design with robust, evidence‑based analysis.
• Identify opportunities to improve efficiency, reduce cost leakage and strengthen commercial outcomes.

• Write, maintain and optimise SQL queries to extract, join and analyse large datasets across Dynamics 365 and related systems.
• Develop and maintain SQL views (and where applicable stored procedures) to provide trusted datasets for audit, reward calculations and Power BI reporting.
• Build audit and reward calculation datasets in SQL, including threshold‑based, rule‑driven and exception‑focused logic.
• Create SQL‑driven exception…