Middle Office AnalystDate: Apr 8, 2026
Location: Sant Joan Desvern, B, ES, 08960
City: Sant Joan Desvern State: Barcelona (ES-B) Country: Spain (ES) Requisition Number: 44837
Note: you are ideally located in Barcelona to obtain this job.
Some responsibilities of the Middle Office Analyst are:
Trade Administration / Trade Support (Daily Positions & P&L;)Producing accurate and reliable daily VC Commodity Positions & PL report:
Cash/flat activities/trades – new trades updated/reconciled with commercial team.
Freight position (+MTM) – reconciled against freight department/commercial team.
Co-ordinate with trading/execution/logistic teams on vessel execution – and reflect impacts in Daily PL.
Pricing monitoring/confirmation to contracts/execution/traders including tracking changes for accuracy across all systems.
Reconcile and publish the Daily Position & PL.
Send trade slip to contract admin in case I/Co sales out of Geneva.
Interoffice futures transfers in case of I/Co sales out of Geneva.
Consolidate, transform and analyze data from multiple sources to meet reporting requirements.
Prepare and explain daily P&L; changes, including analysis on the main drives of the daily result.
Provide information, assistance and analysis to the commercial team.
Optimize Excel-based reports to reduce rote tasks, minimize human error and improve production speed.
Ad hoc reports & projects and other duties as requested.
Pre-Load Execution
Provide, monitor and check with traders/operations/contracts consistency of any operations/contractual changes (cross checking impact).
Extra Costs / Bad Debt
Review accruals reports, extra costs and Bad Debts reports.
Follow up and align with commercial owners and finance departments to understand the drivers/impacts of the financial PL / reconciliation.
Closing the books
Collect, review and confirm month end inputs required for the closing: prices, freight rates, base locations, volumes etc.
Reconciliation of monthly results with Accounting (MTM, prices, execution, extra costs etc).
Liase across functions to identify and resolve gaps during month end closing process.
Results analysis
Margin analysis – identify main buckets of the margin structure/drivers:
Understand and explain drivers of structural component of the margin.
Understand and explain trading component of the margin.
We are looking for different skills / experience:
University degree in accounting, finance, economics or related field level.
Minimum 3 years of experience in accounting, finance or control preferably in the commodity trading industry.
Good knowledge of SAP.
Fluent English – other language an asset.
High proficient Excel skills.
Ability to deal with complex problems involving non-standardized situations.
Strong analytical skills and business acumen - good understanding of commodity trading and mark to market is a plus.
Ability to work in a team/independently and to prioritize and handle multiple tasks.
Meticulous attention to details.
Strong interpersonal skills.
#J-18808-Ljbffr