Sql analyst Jobs in Halifax, NS

Job Description

What is the opportunity?

The role is part of North American and European Operations monitoring and processing of Corporate Action Events for RBC Capital Markets securities trading businesses and its clients. The role ensures that Corporate Action Events are captured, reconciled, monitored and funded where required. The operation’s role is a first line of defense to trading businesses, ensures accurate books and records are maintained whilst providing seamless client experience.

Position reports directly to Team Manager. We are seeking a highly motivated and detail-oriented individual to join our team in a critical Operations role.

What will you do?

• To ensure all daily tasks / controls are completed in line with the departmental PRIMA maps and procedures.

• To assist the Team Manager / Department Head on projects, process improvements or new business initiatives as requested.

• To continue to develop product / market knowledge to ensure daily processes are appropriate to reduce operational risks.

• To escalate any unusual behavior as well as any processing issues to the Team Manager or above in a timely manner following the Operations Escalation Policy.

• To understand and know how to locate central RBC policies and ensure PRIMA maps and procedures are up to date and follow RBC Policies.

• To investigate any processing issues and recommend a course of action to the Team Manager. Once approved, assist in the execution of the proposed change.

• To support colleagues during busy periods by sharing workloads as applicable. "To provide best in class client services to both internal and external clients by ensuring their queries are responded to within agreed timeframes

• To adhere to mandatory training requirements in Talentlink and take a proactive approach to suggesting appropriate additional training as required for the role. Asset Servicing - Responsible for the processing, balancing and reconciliation of positions related to mergers, conversions, and redemptions. Specifically, scrubbing announcements, balancing entitlements, processing mandatory actions, processing and supporting voluntary actions, processing protect and liability notices, processing and allocating dividend and interest payments. Asset Services functions contain the processes to monitor, manage and execute instructions related to corporate actions, stock records and assignments.

• Managing and processing corporate action events - Event Identification

• Position Identification and validation

• Processing Option Assignments & Expires - Processing of incoming/outgoing checks and wires for coupons and dividends

• The RBC attestation policy should be adhered to by account preparers and all accounts accurately assigned with an appropriate attestation status within the month end timetable. Where the policy or underlying reconciliation is not sufficiently understood, this should be escalated to the approving manager or group head

• Must ensure they understand and abide by the Payment Risk Standing Order at all times, ensuring the following; all payments have a justifiable business reason as to why the payment is required to be made, all payments will utilize a settlement instruction record when there is potential for a re-occurring payment to be made, all settlement instructions must be appropriately authenticated, all payments/ settlement authentication and/or settlement instruction records must adhere to the Segregation of duties requirements.

• Maintain regular communication with Front Office Sales and Trading teams, external brokers, and counterparties.

• Collaborate across internal Operations teams and other support functions, including Financial Control, Product Control, DMO, and GRM, to ensure seamless operations.

• Liaise with third-party providers, such as Settlement Agents, Nostro Agents, and Central Counterparties, as needed.

• Uphold RBC’s reputation and always ensure operational excellence.

• Identify and escalate operational risks, loss events, and control deficiencies promptly.

• Support Capital Markets trading businesses, brokers, and external clients in a fast-paced, dynamic environment.

• Ensure accuracy and attention to detail while meeting tight deadlines.

• Demonstrate flexibility in working hours during peak periods to support business requirements.

• Strong interpersonal and communication skills to effectively interact with internal teams, external counterparties, and third-party providers.

• Ability to work under pressure in a high-stakes, time-sensitive environment.

• Exceptional attention to detail and organizational skills.

• A proactive approach to identifying and escalating risks or issues.

• While the role does not involve direct budgetary or write-off authority, the financial and reputational risks associated with this function are significant. The candidate must exercise sound judgment to mitigate potential financial losses and safeguard RBC’s credibility.

• The role is office-based, with limited travel opportunities.

What you need to succeed?

• University degree or College Diploma or any equivalent combination of qualifications and/or experience.

• 1+ years in a Capital Markets and/or reconciliation-based role

• Strong organizational and time management skills.

• Problem Solving /Analytical Thinking.

• Diplomacy and tact to deal with staff and all levels of

• internal and external clients.

• Ensure working environment provides motivation and

• development opportunities.

• Promote ongoing cross-training for all positions to ensure availability of primary/secondary back up.

• Developing a culture of continuous self-development.

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation

• Leaders who support your development through coaching and managing opportunities

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

• Flexible work/life balance options

Job Skills

Capital Markets, Communication, Computer Literacy, Corporate Actions, Detail-Oriented, Equity Operations, Fixed Income Assets, High Accuracy, Selective Attention

Additional Job Details

Address:

90 WESTERN PKY:BEDFORD

City:

Bedford

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

CAPITAL MARKETS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-06-02

Application Deadline:

2026-06-17

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.