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 professional growth and development.
- Why this job: Be part of a team that drives innovation and supports diverse commodities, enhancing your skills.
- 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 focusing on advanced functions 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: In your cover letter, explain why you are interested in the Middle Office Analyst position and how your background aligns with the key responsibilities listed in the job description. Mention your collaborative approach and problem-solving abilities.
Highlight Technical Skills: Emphasise your Excel skills, especially your proficiency with pivot tables, VLOOKUPs, formulas, and VBA. Consider providing examples of how you've used these skills in previous roles to produce reports or analyse data.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for this role.
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 previous experience with PnL reports and how you've handled intraday estimates and end-of-day checks.
✨Excel Skills are Key
Since excellent Excel skills are a must for this role, brush up on your pivot tables, VLOOKUPs, and VBA. You might even want to prepare a few examples of how you've used these skills in past roles to demonstrate your proficiency.
✨Collaboration is Crucial
This role requires working closely with various teams like Settlements, Treasury, and Accounting. Think of examples where you've successfully collaborated with different departments to resolve issues or improve processes, and be ready to share them.
✨Attention to Detail Matters
Highlight your problem-solving abilities and attention to detail during the interview. Prepare to discuss specific instances where your meticulous nature helped prevent errors or improved outcomes in your previous roles.
