Data Business Analyst | Energy Trading | Market Data | SQL | Python | IR35

Data Business Analyst | Energy Trading | Market Data | SQL | Python | £700/Day Inside IR35

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

This Data centric Business Analyst role is ideal for someone who thrives in fast‑paced Front Office environments
, has strong experience working with data coming in third parties (Bloomberg, Zema etc) the exchanges (Nordpool, EPEX etc) &/or out of ETRMs and other internal systems
, and enjoys solving data 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),
UIs and APIs
, Legacy spreadsheets in Excel and deep diving into the 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.

• Support Front Office teams by building curves using market data pulled from third party sources
• 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
• Strong SQL skills – able to write and optimise complex queries and scripts
• Experience integrating third party data sources - establishing APIs
• 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

• 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 Data Business Analyst – Energy Trading role, please apply to the advert or send your CV to sam

Data Business Analyst | Energy Trading | Market Data | SQL | Python | £700/Day Inside IR35