What is the opportunity?
The Manager, Data Engineering and Analytics will be responsible for developing, enhancing, and automating complex ETL and reporting processes for the Analytics and Portfolio Management team. Working closely with business, IT, Risk and Technology partners to deliver solutions that inform key business insights and drive accurate, clear, productivity gains. Leading tech infrastructure development, identifying gaps/opportunities in reporting and automation pipelines. And working with large and complex data sets to solve a wide array of challenging problems using AI, Machine learning and statistical approaches.
What will you do?
-
In accordance with the SDLC, develop, test, implement and document transformation models and ETL processes, leveraging new and existing tools, such as SQL, Python, Large Language Model (Gen AI), and Agentic AI.
-
Coordinate activities and document results related to data scripts quality assurance, end user, acceptance testing, and post implementation verification.
-
Collaborate with business partners to quantify benefits from automation. Perform cost/benefit analysis including ROI, payback period and maintenance costs.
-
Develop, test, and implement executive and operational reports and dashboards utilizing data visualization tools such as Tableau and Power BI.
-
Raise the bar of data management and automation at FSS, including but not limited to driving data best practices, improving analytical processes, documentation and mentoring other team members.
What do you need to succeed?
Must Have
-
5+ years of experience and expert-level skills in extracting and manipulating large datasets, Microsoft excels, SharePoint using scripting languages (e.g. Python) and data querying languages (e.g. SQL).
-
Experience in building & scheduling complex data pipelines
-
Experience in implementing database design and best practices (e.g. configuring schemas, DB sharding, setting indexes, integrity checks, creating views, etc.).
-
Experience in driving outcomes as project lead
-
Ability to work independently with minimal supervision
-
Resourcefulness and a genuine interest in problem solving
-
Bachelor’s degree or equivalent experience in computer science, computer engineering, or related field
Nice to Have
-
Experience or exposure to financial reporting or working in a financial operations environment.
-
Knowledge of agent design patterns and multi-agent systems. Evaluating agent performance, refine behaviors, and optimize for efficiency and accuracy
-
Experience with VBA is a plus, to modernize legacy tools
-
Work as champion for implementing best practices for Jira, confluence and GitHub
Job Skills
Big Data Management, Budgeting, Business Performance Management, Critical Thinking, Knowledge Organization, Long Term Planning, Performance Management (PM)
Additional Job Details
180 WELLINGTON ST W:TORONTO
Toronto
Canada
37.5
Full time
TECHNOLOGY AND OPERATIONS
Regular
Salaried
2026-06-15
2026-06-29
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.