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

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

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