Middle Office Analyst

Location: Sant Just Desvern, B, ES, 08960
Location: Barcelona
City: Sant Just Desvern
Country: Spain (ES)
Requisition Number: 36893
BUNGE has an exciting opportunity available for a Middle Office Analyst . In this role, you will provide daily support to the Commercial team on the operational side including financial and position backup, translation of trading activities into a daily position and P&L report. Serve as a central point of contact for trading operation tasks supporting trade flow verifications and accuracy of each transaction as well as ensure consistency and completeness of the data flow across all other involved departments and systems. Additionally drive for automation and efficiency improvements to the current reporting processes and tools.
Some responsibilities of the Middle Office Analyst are:
Trade Administration / Trade Support ( Daily Positions & P&L )
Producing accurate and reliable daily VC Commodity Positions & P&L report.
Cash/flat activities/trades - new trades updated/reconciled with commercial team.
Freight position (+MTM) - reconciled against freight department/commercial team.
Futures/options position - reconciled against futures statements/ commercial team.
FX exposure & applications tracking - reconciled against accounting / commercial team.
Co-ordinate with trading/execution/logistic teams on vessel execution - and reflect impacts in Daily P&L.
Pricing monitoring/confirmation to contracts/execution/traders including tracking changes for accuracy across all systems.
Reconcile and publish the Daily Position & P&L.
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 drivers 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 P&L / 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).
• Liaise 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.
• 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.
If this description reflects your profile or ambition, we're looking forward to seeing your application and motivation in English by hitting apply!
In case of questions, please reach out to Aitor Alonso (Talent Acquisition Specialist at ***).
Acquisition by agencies is not appreciated, we do not use agencies at this moment for our recruitment. Open proposals of candidates are at own risk.
•