Centrica

Commercial Analyst

Centrica

full-time

Posted on:

Location Type: Hybrid

Location: Stockport • United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Junior

Tech Stack

SQL

About the role

  • 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
  • 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
  • Work closely with Franchisor teams, Franchisees, Commercial and Finance teams to support strong commercial outcomes
  • Use SQL queries to extract, join and analyse large datasets from Dynamics 365 and related systems
  • 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

Requirements

  • 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
  • Degree (or equivalent experience) in Finance, Business, Economics, Data Analytics, Mathematics or a related discipline
Benefits
  • Flexible time
  • Professional development opportunities
  • Total rewards for financial, physical, and emotional support
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPower BIExceldata analysiscommercial rate modelsdata extractiondata joiningfinancial analysisperformance analysiscost impact assessment
Soft Skills
analytical mindsetattention to detailcommunicationproblem-solvingstakeholder engagementprocess improvementcommercial insightaccuracyconsistencydecision-making