Job DescriptionWhat is the opportunity?The Manager - Product Control reporting to the Associate Director, Corporate Treasury Product Control - ALM, will be responsible for producing weekly, monthly PnL reporting and attribution, GL reconciliations, management and regulatory reporting in a timely and accurate manner. This role also requires providing value-added analysis, develop analytical capabilities and insights using big data analytics tools and Python, blending financial expertise with advanced data skills.
What will you do?- Prepare weekly and monthly P&L reports and month-end GL reconciliations
- Investigate, explain PnL and BS variances and discrepancies and make corrective actions
- Extract, transform, and analyze large datasets from core banking systems (loans, mortgages, deposits) using SQL
- Lead ongoing projects to enhance reporting and analytical capabilities
- Collaborate with Finance, business, risk, and IT teams to enhance controls and improve processes
- Address queries on trade booking, P&L, spreads, and reporting issues
- Document processes and identify opportunities to streamline reconciliations and improve productivity
What do you need to succeed?Must have: - Bachelor's degree in Computer Science or Engineering
- Strong SQL & Python Skills to navigate, extract and analyze data from large databases
- Experience with big data analytics tools (Power BI, Tableau, Datameer etc.) Proficiency in Excel (formulas, pivot tables, data modeling)
- Experience in working with large datasets and building/re-engineering processes to help with reconciliations and enhance analytical capabilities
- Strong problem-solving skills, attention to details and ability to work under pressure with tight deadlines
- Excellent communications skills and ability to manage stakeholder relationships
Nice-to-have: - CFA, FRM designation (in progress or completed)
- 2+ years' experience in Capital Markets related field in a Financial institution
- Good understanding of Financial Instruments (bonds, swaps, FX, Money Market etc.)
- Good understanding of banking products, systems (loans, deposits, Mortgages etc.)
What's in it for you?- 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
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work
Job SkillsAutomation, Corporate Treasury, Data Query, Detail-Oriented, End Reporting, Finance, Financial Systems, General Ledger (GL), Internal Controls, Microsoft Excel, Month End Reporting, Multitasking, Reporting Processes, Structured Query Language (SQL)
Additional Job DetailsAddress:ROYAL BANK PLAZA, 200 BAY ST:TORONTO
City:Toronto
Country:Canada
Work hours/week:37.5
Employment Type:Full time
Platform:OFFICE OF THE CFO
Job Type:Regular
Pay Type:Salaried
Posted Date:2026-05-19
Application Deadline:2026-09-14
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
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.
