Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Produce daily PnL reports and validate pricing data in a dynamic trading environment.
- Company: Join a leading commodity trading firm making waves in the Power and Gas sector.
- Benefits: Enjoy a collaborative culture with opportunities for system development and improvement projects.
- Why this job: Be part of a team that values problem-solving and offers exposure to various commodities.
- Qualifications: 4-6 years in financial services, strong Excel skills, and a keen eye for detail required.
- Other info: Reach out to Paula at Marlin Selection if you're interested!
The predicted salary is between 43200 - 72000 £ per year.
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 interested, please do apply or reach out to Paula at Marlin Selection.
Middle Office Analyst - Power & Gas employer: Marlin Selection Recruitment
Contact Detail:
Marlin Selection Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Middle Office Analyst - Power & Gas
✨Tip Number 1
Familiarise yourself with the latest trends and regulations in the European Power and Gas markets. This knowledge will not only help you during interviews but also demonstrate your genuine interest in the role.
✨Tip Number 2
Network with professionals in the commodity trading sector, especially those who work in middle office roles. Attend industry events or join relevant online forums to make connections that could lead to valuable insights or referrals.
✨Tip Number 3
Brush up on your Excel skills, particularly in areas like pivot tables and VBA. Consider taking a short course or using online resources to enhance your proficiency, as this is crucial for the role.
✨Tip Number 4
Prepare to discuss specific examples of how you've contributed to system development or improvement projects in your previous roles. Highlighting your collaborative approach and problem-solving abilities will set you apart from other candidates.
We think you need these skills to ace Middle Office Analyst - Power & Gas
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in financial services or trading environments, particularly focusing on your knowledge of European Power and Gas PnL reporting. Use specific examples to demonstrate your skills.
Craft a Strong Cover Letter: Write a cover letter that showcases your problem-solving abilities and attention to detail. Mention your collaborative approach and how you can effectively manage daily priorities, as these are key traits for the role.
Highlight Technical Skills: Emphasise your Excel skills in your application. Include specific functions you are proficient in, such as pivot tables, VLOOKUPs, and VBA, as these are crucial for the position.
Show Enthusiasm for the Role: In your application, express your genuine interest in the Middle Office Analyst position and the company. Mention any relevant projects or experiences that align with the responsibilities outlined in the job description.
How to prepare for a job interview at Marlin Selection Recruitment
✨Know Your PnL Inside Out
Make sure you understand the intricacies of Profit & Loss reporting, especially in the context of European Power and Gas. Be prepared to discuss your experience with daily PnL reports and how you've handled intraday estimates and end-of-day checks.
✨Excel Skills are Key
Since strong Excel skills are a must for this role, brush up on your pivot tables, VLOOKUPs, and VBA. You might be asked to demonstrate your proficiency, so consider preparing a small project or example to showcase your abilities.
✨Collaboration is Crucial
Highlight your experience working with various teams such as Settlements, Treasury, and Accounting. Be ready to share examples of how you've resolved issues collaboratively, as this will show your ability to work effectively in a team environment.
✨Attention to Detail Matters
Given the nature of the role, having a high attention to detail is essential. Prepare to discuss specific instances where your attention to detail has made a significant impact on your work, particularly in validating and reconciling pricing data.
