Middle Office Analyst

Onyx Capital Group; London; On-site; GBP 35,000 - 50,000; Full time

Job summary

A leading financial firm seeks an entry-level Middle Office Analyst for its Risk team in London. The role involves running reconciliations, P&L reporting, and administration of trading platforms. Proficiency in Python, SQL, and communication skills are essential. This position offers an opportunity to engage with various stakeholders and develop dashboards using PowerBI.

Qualifications

• Proficient in running reconciliations and P&L reporting.
• Experience with Python and SQL required.
• Good communication skills to engage with stakeholders.

Responsibilities

• Conduct daily T-1 position and trade reconciliation.
• Report P&L to trading desks and Finance department.
• Maintain and develop PowerBI dashboards.

Skills

Problem Solving

Communication

Python

SQL

Excel VBA Macros

Education

Bachelor's degree

Tools

PowerBI

Job description

Onyx Capital Group was founded, by traders, on the principles of expertise, vision and excellence. The company has rapidly grown to command across the entire spectrum of oil derivative products. Our aim is not just to be market leaders but to build a unique franchise that continuously pushes boundaries. We know that our success is derived from a total commitment to pursue excellence in both our people and our technology which we heavily invest in.

We are looking for an entry-level Middle Office Analyst to join our Risk team with experience in running reconciliations, P&L reporting and administration of trading platforms.

The candidate will need to be proficient at problem solving and have good communication skills in order to identify discrepancies, establish what needs to be done and communicate this to various stakeholders.

The role also involves other day-to-day tasks including portfolio rebalance notifications, counterparty trade notifications, NAV calculations, managing trader and account permissions and liaising with the Finance department and traders to ensure correct P&L reporting.

Responsibilities:

• Daily T-1 position and trade reconciliation
• Calculation and reconciliation of Mark-to-Market and P&L
• P&L reporting to trading desks, Finance department and Management
• Onboarding of traders and set up of risk limits on multiple derivatives exchanges
• Automatisation of operational processes
• Maintenance and development of PowerBI dashboards
• Monitoring of risk management tools and alerts

• Working knowledge of Python, SQL and Excel VBA Macros. Minimum able to:

a. Write and run simple SQL queries.

b. Write a Python module that imports and exports data from Excel

• Basic knowledge of P&L, Risk Management (Value-at-Risk) and Futures
• Basic knowledge of PowerBI a plus
• Bachelor's degree