Commercial Analyst

Utility Warehouse; City Of London; Hybrid; GBP 50,000 - 75,000; Full time

Benefits offered by this job

Flexible hybrid work

Discounts on services

Pension & life Assurance

Private health insurance

Employee assistance

Career progression

Job summary

Utility Warehouse is seeking a Commercial Analyst to own models guiding energy metering strategy and major commercial commitments. You will ingest and calibrate data for Smart Demand planning, balancing demand with installer capacity to support thousands of smart meters this year.

You will model and forecast our metering portfolio, building scenario and sensitivity frameworks to protect margins and manage commercial risk, while turning ad-hoc requests into strategic insights that shape the

Qualifications

• 2–3 years of commercial or analytical experience.
• STEM or numerical degree preferred.
• Strong Excel skills for complex logic and sensitivity tables.
• Willingness to learn SQL and Python under mentorship.

Responsibilities

• Own models that guide energy metering strategy and major commercial commitments.
• Ingest and calibrate data for Smart Demand planning and meter delivery to support thousands of smart meters.

Skills

Excel

SQL

Python

Data analysis

Commercial finance

Education

STEM or numerical degree

Tools

SQL

Python

Job description

This isn't a back-office reporting role where work disappears into a drawer. As a Commercial Analyst, you will have direct ownership of models that guide our energy metering strategy and ensure we deliver on our major commercial commitments.,

• Powering Smart Meter delivery: From day one, your flagship focus will be our Smart Demand planning. You will ingest and calibrate complex data streams-balancing customer demand against third-party installer capacity-to help UW stay on course to install thousands of smart meters this year.
• Driving P&L optimisation: You will model and forecast our growing metering portfolio, building scenario and sensitivity frameworks that actively capture margin and protect against commercial risk.
• Influencing major contract levers: You'll evaluate commercial trade-offs across key supplier relationships, delivering the evidence base that senior leaders rely on to negotiate and make strategic calls.
• Moving from data to direction: You'll turn ad-hoc requests into strategic opportunities, providing regular, high-visibility insights that shape our energy team's roadmap.
• We get it done together. Your team and the people you will work with… At Utility Warehouse, nobody works in a silo. We believe the best results come from high trust, open communication, and genuine collaboration.
• Dedicated technical mentorship: You will report directly to a Senior Commercial Analyst, an exceptional data specialist who will coach you day-to-day, helping you take your modelling skills to the next level and teaching you advanced analytics tools like SQL and Python as you grow.
• Strategic leadership & commercial vision: You'll work alongside our Head of Commercial Contracts, and Commercial Managers who will guide your commercial instincts, contractual awareness, and executive stakeholder presence.
• Executive visibility: You'll have direct exposure to our Energy Director, regularly presenting data that underpins key commercial decisions for the entire energy division.
• External partner collaboration: You'll work closely with key external partners like our primary metering provider, fostering a collaborative, joint problem-solving relationship that balances commercial rigour with shared operational success.
• How we work: We enjoy a flexible hybrid setup. Our formal baseline is two days per week in our vibrant Farringdon office, for collaborative days, meeting, workshops, and team lunches., Claire Fennell will be your point of contact throughout the recruitment process.
• Are sharp with spreadsheets, sharper with context: You are confident wrangling messy, multi-layered data in Excel (from complex logic to sensitivity tables), but your real superpower is connecting that analysis to commercial P&L drivers and margins.
• Have 2-3 years of commercial or analytical experience: You might have a STEM or numerical degree, or proven experience in business analytics, commercial finance, or supply chain. Prior energy sector experience is welcome, but by no means a dealbreaker.
• Love to learn: You don't need to be a finished SQL or Python developer today. What matters is that you have a proactive mindset, strong numerical intuition, and an appetite to expand your technical toolkit under dedicated mentorship.
• Keep it simple: You can take a complicated operational scenario and translate it into a clear, compelling insight that anyone can understand and act on.
• An industry-benchmarked salary. We'll share it during your first conversation.
• Flexible hybrid working - 2 days a week in our London hub
• Discounts on our services
• Matched-contribution pension scheme and life assurance up to 4x salary.
• Family-friendly policies designed to help you and your family thrive.
• Discounted private health insurance, Employee Assistance line and free Virtual GP.
• Belonging groups helping shape an inclusive future.
• A commitment to learning and progression through our Career Framework