Middle Office Analyst - Power & Gas

ZipRecruiter; London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading commodity trading firm is seeking a Middle Office Analyst to join their London team. The role involves producing daily PnL reports, validating pricing data, and supporting various commodity projects. Ideal candidates will have 4–6 years of experience in financial services, strong knowledge of European Energy markets, and excellent Excel skills.

Qualifications

• 4-6 years of experience in a financial services or trading environment.
• Strong knowledge of European Power and Gas PnL reporting.
• Excellent Excel skills (pivot tables, VLOOKUPs, formulas, VBA).

Responsibilities

• Produce daily Profit & Loss (PnL) reports, including intraday estimates and end-of-day checks.
• Validate and reconcile pricing data and T+1 actuals.
• Work closely with teams to resolve issues.

Skills

European Power and Gas PnL reporting

Excel

Problem-solving

Attention to detail

Job description

Job Description

A leading commodity trading firm is looking for a Middle Office Analyst with experience in European Power and Gas to join their London team.

Key Responsibilities:

• Produce daily Profit & Loss (PnL) reports, including intraday estimates and end-of-day checks
• Validate and reconcile pricing data and T+1 actuals
• Work closely with teams such as Settlements, Treasury, Accounting, and Credit to resolve issues
• Provide support across a range of commodities, including oil, metals, and agricultural products
• Contribute to system development and improvement projects, including new product launches

What You’ll Need:

• 4–6 years of experience in a financial services or trading environment
• Strong knowledge of European Power and Gas PnL reporting
• Excellent Excel skills (pivot tables, VLOOKUPs, formulas, VBA)
• High attention to detail and strong problem-solving ability
• A collaborative approach and ability to manage daily priorities effectively

If you are itnerested, please do apply or reach out to Paula at Marlin Selection.