Sql analyst Jobs in North York, ON

Job Description

What is the opportunity?

As part of a high performing team, you will ensure the operational and administrative effectiveness for RBC Global Asset Management Inc, as well as support cost controls and operational efficiencies for the RBC Mutual Funds. You will be responsible for the valuation and reporting of unit prices for assigned Mutual Funds within fixed deadlines enabling the unitholder systems to properly calculate the value of client’s holdings and process mutual fund transactions. Please visit: http://www.rbcgam.com/landing.html

What will you do?

• Ensure all transactions (i.e. unitholder subscriptions and redemptions, management fees, expense accruals, security trades) are entered in an accurate and timely manner into the accounting system.

• Reconcile each portfolio daily to ensure that cash, security, and unit positions correctly reflect the client’s holdings

• Ensure corporate actions are entered into the accounting system and reflect all relevant securities and tax regulations, analyze market value impacts of corporate actions

• Analyze daily fund activity, trade discrepancies against market data and report daily fund prices and income factors to unitholder systems and external sources for publication

• Review and sign-off on daily fund prices and income factor delivery to internal/external parties

• Research, analyze and validate daily price discrepancies within valuation policy; Review and sign-off on daily price discrepancies breaching valuation policy thresholds

• Create and implement solutions to streamline Valuations processes

• Maintaining internal procedures/policies to ensure controls are followed.

• Train staff on operational processes and lead senior staff with daily process queries

• Lead reporting activities including taking on ad-hoc requests

• Work on specialized projects including Eagle Investment and Electra systems

• Assist in the creation of semi-annual and annual mutual fund financial statements

• Assist in periodic tax distribution calculations for all mutual fund types

What you need to succeed?

Must have:

• Post-Secondary education in Finance or related field

• 4+ years relevant industry experience

• Ability to work in a team environment with strong communication, time management and problem solving skills

• Practical knowledge of financial products, Mutual Fund valuation and general ledger system.

• Experience with derivatives and corporate action processing

• Experience with MS Excel, Access, VBA/Macros, SQL, Tableau and database queries.

• High attention to detail and accuracy.

Nice to have:

• Completion of CIM or CFA Level 2

• working towards Finance/Accounting designation, ie. CPA

• Knowledge of Electra Recon and Eagle Investment Systems

• Experience with pricing/data applications Bloomberg and Thomson One Financial, etc.

• Basic accounting skills, corporate action knowledge and cash management experience

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, commissions, and 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 and geographies

Job Skills

Additional Job Details

Address:

RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

WEALTH MANAGEMENT

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-08-10

Application Deadline:

2026-08-22

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

Compensation for this position (including salary and discretionary/variable payments) will be determined by factors, including but not limited to candidate's experience, skills, registration status, performance, individual goals, market conditions, and business needs.

Pay Range

The expected pay range for this position is:

$55,000.00 - $90,000.00

The pay range provided is for the primary work location referenced in the Additional Job Details section of this job posting. Pay ranges may differ based on location. If the posting lists multiple job locations, a recruiter can confirm availability of the role and the relevant pay rage for the additional locations listed. RBC supports pay transparency and we strive to ensure all pay ranges are competitive, fair, and equitable.

You have the potential to earn RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided that business meets its performance targets and you meet your individual goals.

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.