Trade Support Analyst

Royal Bank of Canada•Calgary, AB

3d•Onsite

About The Position

To provide full ‘first line of defence’ trade support coverage to the Commodities trading desks in multiple time zones and markets - Oil and Gas in Calgary (MST) and Houston (CST), Base and Precious Metals in London (GMT), Toronto and New York (EST), Power, Index, Agriculture, Carbon and Precious Metals in Toronto (EST). To ensure the efficient and accurate daily processing of all commodities OTC and Exchange Traded derivatives and physical trades on Openlink systems. This involves completion of trade validation/verification, trade reconciliation, daily/weekly/monthly reporting, daily trade resets/fixing, loading of curves and prices (MTM, settlement, and volatilities) and generation of Intraday flash trading PnL. Ensure smooth run of critical EOD batch processes to mitigate any detrimental impact on downstream feeds, risk reporting and operational losses to the firm. Involvement in all issues and queries pertinent to internal process flow of the assigned Commodities trading desks and frequent engagement in the development of new business and project initiatives, PnL break analysis and system troubleshooting as a key player across all functional parts.

Requirements

Bachelor’s Degree or equivalent (BBA / BComm / BMath / BSc)
High degree of accuracy
Strong analytical, problem-solving, interpersonal and communication skills.
High level of adaptability in a fast-paced dynamic team environment
Ambitious, results-driven achiever.
Decisive problem-solver.
Conceptual / Strategic thinker willing to challenge organizational paradigms
Intermediate to Advanced Excel Skills (Pivot Tables and Macros)
Sound knowledge of trading practices/terminology and derivatives products

Nice To Haves

Intermediate to advanced knowledge of VBA and SQL
Experience in Capital Markets Operation or Technology positions
Experience in Openlink and/or OPICS systems
Relevant industry experience with an emphasis on Electricity, Carbon, Oil, Gas, Precious and Base Metals Markets.
Derivative product experience and understanding of physical and financial Commodities Markets
Strong understanding of risk concepts and risk management practices

Responsibilities

Perform trade validation for Commodities derivatives and physical trades booked into the Openlink booking systems.
Analyze the downstream impact of new deals, amendments, cancellations and actively communicate issues to relevant stakeholders.
For trade capture errors, monitor results & exceptions, analyze underlying causes and ensure appropriate, corrective action are taken to reduce the frequency of occurrence and minimize loss due to error.
Liaise with FO and all cross functional teams as Commodity Operations’ primary contact for all queries and issues and effectively monitor, track, and escalate any potential risks in a timely manner.
Work closely with Futures/Clearing teams to identify and resolve trade breaks on a daily basis.
Responsible for ensuring successful Intraday/EOD processes within strict timelines throughout the day to mitigate any detrimental impact on downstream feeds and reports.
Ensure that all trade discrepancies and position breaks are actioned and resolved in a timely manner prior to EOD kick-off.
Ensure that there are adequate checks on the accuracy of all historical rates entered or imported into the system & appropriate sign off.
Work with the relevant groups on sourcing new and missing prices from available publication sources.
Responsible for performing daily checks for Dodd Frank / EMIR / CSA reporting.
Escalate issues to the relevant IT support groups and follow up until resolution is achieved.
Perform system troubleshooting and develop technology tools (e.g., VBA macro) as required to support day-to-day responsibilities seamlessly
Assist Senior Analysts and Reporting Officer with reviewing deal templates for new product setup (OTC & Exchange).
Liaise with cross functional teams in testing and sign off.
Create and dispatch intraday, daily, weekly, monthly and quarterly client MTM statements.
Collaborate with FO for creating bespoke Commodities Index linked notes daily client MTM statements.
Ensure time sensitive deadlines are strictly adhered to.
Prepare and monitor FO Supervisory (Late, Cancelled and Amended Trade Reports) for FO, MO and other stakeholders as required.
Analyze and provide commentary to FO supervisors for large PnL impact on the Daily Cancelled & Amended Trades.
Ensure that daily and monthly procedures, as detailed in the group’s procedures and standing orders are strictly observed.
Maintain and update operational procedures and PRIMA maps related to these functions on an ongoing basis.
Proactively identify opportunities to further streamline processes.
Recommend cost efficient and effective controls for Commodity trade processing with the introduction of new processes, products and systems.
Initiate and implement recommendations for automation.
Perform system troubleshooting and develop technology tools (e.g., VBA macro) as required to support trade validation/reconciliation responsibilities seamlessly

Benefits

bonuses
flexible benefits
competitive compensation
commissions
stock where applicable
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact.
Work in a dynamic, collaborative, progressive, and high-performing team.
Flexible work/life balance options.
Opportunities to do challenging work.
Opportunities to take on progressively greater accountabilities.
Access to a variety of job opportunities across business.