Home
Jobs
VirtueTech Recruitment Group
Data Business Analyst | Energy Trading | Gas | Power | SQL | Excel | £800/Day Inside IR35

Data Business Analyst | Energy Trading | Gas | Power | SQL | Excel | £800/Day Inside IR35

Hybrid

London, United kingdom

Freelance

06-11-2025

Share this job:

Score my CV

Skills

Python Tableau SQL Databases Agile

Job Specifications

Data Business Analyst | Energy Trading | Gas | Power | SQL | Excel | £800/Day Inside IR35

A Data Business Analyst is required for an exciting long-term contract opportunity within the Energy Trading sector

This SQL & Excel centric Business Analyst role is ideal for someone who thrives in fast-paced Front Office environments, has strong data coming in and out of ETRMs, and enjoys solving data and Excel-based challenges that directly impact trading operations.

You’ll be joining a highly agile Front Office support team that operates on an ad-hoc tactical basis, dealing with incidents and data discrepancies as they arise. This role will see you working closely with traders, quants, and other front office stakeholders to ensure their data and tools run smoothly across Gas, Power, and other commodities.

The role involves working with data feeding from ETRMs (Endur, Coral, Previse), UIs and APIs, and integrating this information into spreadsheet-based tools in Excel. You’ll need to dive deep into legacy Excel macros, diagnose issues, and trace data back to its source, often pulling large datasets directly from SQL databases.

As part of the role, you’ll investigate inconsistencies across trade bookings, modelling, or valuation systems —making judgment calls on which issues can be quickly resolved versus those that need long-term development.

The SQL & Excel Business Analyst Contract

⏰ 6 Months Rolling Contract

£800/Day Inside IR35

Hybrid Working (2-3 days in London)

Front Office Support – Energy Trading (Gas & Power)

Key Responsibilities

Support Front Office teams by troubleshooting issues in Excel macros and SQL-driven tools
Investigate and resolve data inconsistencies between ETRM systems, models, and spreadsheets
Extract, analyse, and validate data using SQL queries and stored procedures
Understand ETRM data workflows, exposure, and P&L from a troubleshooting perspective
Liaise with traders and business users to prioritise issues and determine short vs. long-term fixes
Ensure accuracy and reliability of spreadsheet-based reporting tools used by Front Office

Essential Skills

Strong SQL skills – able to write and optimise complex queries and scripts
Deep Excel expertise, including experience working with macros and legacy spreadsheets
Understanding of ETRM systems (Endur, Coral, Previse) and trade data structures
Knowledge of Front Office operations within Energy Trading (Gas & Power)
Experience with exposure and P&L troubleshooting
Ability to analyse data pipelines from UI/API to database to spreadsheet

Nice to Haves

Familiarity with Python scripting (used by Front Office teams)
Experience with Tableau or other BI tools
Knowledge of LNG or Carbon Emissions markets

If you are interested in this SQL & Excel Business Analyst – Energy Trading role, please apply to the advert or send your CV to sam@virtuetech.io

Data Business Analyst | Energy Trading | Gas | Power | SQL | Excel | £800/Day Inside IR35

About the Company

From start-ups to unicorns, you need great people to grow, so at VirtueTech we do recruitment differently. We believe companies are defined by their people, so connecting clients and candidates through mu-tual values is key for a thriving business. With a joint brand mission being paramount for success, you need an agency aligned with that purpose. Which is precisely where we come in... At VirtueTech jobs are more than just a salary, they're a passion. So we understand and reflect our clients values, in both ourselves and... Know more