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.  
  

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 & 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.

Key Accountabilities (but not limited to)

Audit, Validation, Rewards & Revenue Protection:

• 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.

Commercial & Performance Analysis:

• 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.

SQL, Reporting & Process Improvement:

• 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 reporting to identify duplicate claims, out‑of‑tolerance job times, rate mismatches and incorrect KPI outcomes.
• Perform data reconciliation using SQL to validate source vs reporting outputs and quantify financial variances.
• Design and maintain automated dashboards and MI in Power BI, reducing reliance on manual Excel‑based calculations.
• Embed reporting, reward logic and controls within Dynamics 365 and Power BI to improve scalability, accuracy and efficiency.
• Document SQL logic, KPI rules, assumptions and data lineage to ensure transparency, auditability and repeatability.
• Continuously identify and implement process improvements that strengthen controls, reduce manual effort and improve data quality.

Skills, Experience and Qualifications Required

Essential:

• Strong experience in a commercial analyst, finance, audit or data‑driven role.
• Strong SQL capability, including complex joins, building views and query optimisation.
• Proven experience building dashboards and reports in Power BI (data modelling).
• Working knowledge of Dynamics 365 or similar ERP / CRM systems.
• Advanced Excel skills, including complex formulas, reconciliations and structured calculations.
• Experience calculating or validating KPI‑based rewards, incentives or performance payments.
• Strong understanding of commercial and financial concepts, including revenue, gross margin, cost drivers and profitability.
• Proven ability to investigate issues, validate data and clearly communicate outcomes to commercial, finance and operations teams.

Desirable:

• Experience in validation, audit, revenue assurance or incentive/reward calculation environments.
• Experience aligning operational performance, payments and client invoicing.
• Exposure to scripting, automation or data engineering concepts (e.g. Power Query, stored procedures).
• Experience working with franchise or partner‑based business models.

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.