Lead Data Analyst - Commercial Analytics

NextGenEnergyJobs; Greater London; On-site; GBP 80,000 - 110,000; Full time

Job summary

Octopus Energy in the UK is seeking a Lead Data Analyst for Commercial Analytics to own pricing intelligence, performance reporting, and growth insights across tariffs and channels. You will shape data platforms, drive cross-functional impact, and mentor a small data team.

You will partner with Finance, Marketing, Sales and Energy Markets to deliver actionable insights, dashboards, and forecasting that support competitive pricing and business growth.

Qualifications

• Strong commercial acumen and ability to translate data into actionable business insights.
• Experience mentoring data professionals and influencing non-technical stakeholders.
• Track record of delivering insights that impact pricing, margins and growth.

Responsibilities

• Own end-to-end pricing operations and reporting for tariffs, price changes, and margin intelligence.
• Drive pricing strategy and optimisation through competitor and market analysis.
• Lead and evolve commercial reporting pipelines across channels and campaigns.
• Deliver growth and customer insight through metric reporting, funnel analysis, forecasting and retention initiatives.
• Mentor a small team of data analysts and align with cross-functional partners.

Skills

Pricing analytics

Growth analytics

Mentoring

Communication

Tools

SQL

Python

pandas

dbt

Databricks

Lightdash

Streamlit

Airflow

GitHub

CircleCI

Terraform

Spacelift

AWS

Job description

Lead Data Analyst - Commercial Analytics

In just 10 years, Octopus Energy has evolved from a disruptive challenger into the UK’s largest energy retailer and a well-loved brand, serving more than 8 million customers.

Key Responsibilities

• Own end-to-end pricing operations for domestic tariffs, including launches, quarterly price changes, margin reporting and intelligence, and ensuring regulatory / price cap compliance for millions of customers.
• Drive pricing strategy and optimisation through competitor intelligence, market analysis, and data-driven recommendations to the Senior Leadership Team.
• Own and evolve commercial reporting pipelines across customer switching, sales activity from all channels, marketing campaigns, retention and competitor insight.
• Deliver growth and customer insight, including key metric reporting, funnel analysis, customer forecasting, and retention initiatives.
• Set priorities, coordinate and review the work of a small, high-performance team of data analysts.
• Partner with Commercial, Sales, Marketing, Energy Markets, Flexibility, Gross Margin and Strategic Finance teams to provide customer forecasting inputs, KPI reporting, margin analysis and strategic support.
• Contribute to and collaborate with our global working groups to ensure aligned reporting and shared analytics projects.
• Champion data best practices and continuous improvement in analytics engineering, tools and automated processes.

Requirements

• Hands-on expertise with modern data platforms and analytical tools (especially SQL and python - see our full stack below).
• Strong commercial acumen, preferably in pricing, margin optimisation, and/or growth analytics.
• Proven experience mentoring and developing data professionals.
• Strong communication skills to influence non-technical stakeholders and senior leadership.
• A track record of delivering actionable insights that drive measurable business impact.
• Python, pandas and SQL in Jupyter notebooks for analysis
• dbt and Databricks data platform with Delta Lake
• Lightdash as our BI tool and semantic layer
• Streamlit for interactive data applications
• Airflow for orchestration
• CI/CD with GitHub and CircleCI
• Infrastructure on AWS, deployed with Terraform / Spacelift