Data Analyst | Commodities & Energy Trading - Front office | London, Hybrid | up to £120k + Bon[...]

Data Analyst | Commodities & Energy Trading - Front office | London, Hybrid | up to £120k + Bonus, Benefits

A Data Analyst is sought by a leading utility-backed global energy trading organisation to support a high-impact analytics function embedded across Trading, Operations, and Technology. This Data Analyst role plays a pivotal part in how the business collects, structures, analyses, and interprets market, trading, and operational data to drive informed decision-making, portfolio optimisation, and transparency across the full seaborne energy trade lifecycle.

Acting as a hands‑on data analyst, you will work closely with traders, operators, and technology teams to deliver analysis across small to medium‑sized initiatives, developing data models, dashboards, and analytical outputs that support front‑to‑back trading processes. You will translate complex commercial and operational questions into clear data requirements, interrogate large and diverse datasets, ensure data quality and governance standards are maintained, and produce actionable insights that enable the business to identify trading opportunities, optimise portfolios, manage risk, and enhance security of supply across fast‑moving global energy markets.

The role involves close day‑to‑day collaboration with LNG front‑office traders, providing analytical support on market fundamentals, pricing, freight, and portfolio performance. As a data analyst embedded within the trading environment, you will help transform real‑time and historical data into insights that inform trading strategies, scenario analysis, and commercial decision‑making in a fast‑paced, highly dynamic LNG trading desk.

The salary on offer for this Data Analyst Role is up to £120,000 + Bonus and Benefits package.

The company works a hybrid model, with 3 days per week in the office, close to major tube stations, including Liverpool Street.

As a Data Analyst you will:

• Analysing Risk data sourcing, how it flows and is housed in the organisation. You will map how to acquire data from primary and secondary sources and maintain data systems.
• The migration of the legacy data warehouse to the strategic data platform.
• Identifying, collecting and migrating data to and from a range of systems into the central Data Platform, working closely with the Data Management Team.
• Analysis of normalised transactional data and analytic data sources.
• Analysis of semi‑structured and file‑based data extracts.
• Data modelling to transform operational data into analytic/reporting structures such as Kimball‑style multi‑dimensional models.

Essential Skills for the Data Analyst:

• Proven Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas (Working the commodities or energy trading space would be a plus).
• Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation.
• Familiarity with Data warehousing and analytical data structures.
• Data quality assurance, validation and linkage.
• Experience creating BI models and dashboards, ideally in Power BI .
• Software development methodologies (Sprints/Agile) and project management software (Jira Software).
• Databricks (or Alternative Modern Data Platform such as Snowflake)
• Knowledge of Orchestration Tools and processes (e.g SSIS , ODI, Informatica, Data Factory)

If you are interested in this Data Analyst role, please reply with your latest CV or send it to

#J-18808-Ljbffr