Job DescriptionWhat will you do?- Understand in detail consumer requirements, research industry data standards for financial products and propose appropriate design/standards extensions to support such requirements.
- Design and implement standardized, scalable data models that serve as the foundation for a unified presentation layer organized by asset class and product
- Understand the various financial products in RBC and work with our partners to ensure they are represented/modelled correctly to support stakeholders' requirements
- Produce and maintain high quality documentation and metadata required to support each model and standard published
- Strong teamwork mentality. Organize and conduct internal reviews of work/analysis done; the goal is to avoid overlap of work with other team members, knowledge share and guarantee adherence to existing models/standards/designs
- Demonstrate clear understanding of each model/standard and articulate the intent and vision via walkthroughs for consumer and data suppliers; the goal is to communicate updates and educate our partners on models and standards supported by the team
- Interface with business areas, including high profile stakeholders, to ensure all initiatives support business strategies and goals and provide recommendations for future state
- Help determine what data sets are required by back office control functions, determine what data sets are available from upstream data supplier, and work with SMEs in both groups to reach agreement on model or standard extensions.
- Provide leadership and direction to ensure adherence to published standards
- Apply extensive, in-depth knowledge, skills, and practices to perform complex assignments.
What do you need to succeed?Must have:- Bachelor's degree in computer science, Software Engineering, Information Systems, Mathematics, or related field
- 7+ years hands-on data modelling experience (including data analysis and profiling) in high pressure environment in financial sector, preferably in Capital Markets
- Expertise in data management and governance in data integration projects involving Capital Markets trading platforms
- Advanced SQL and Python skills for data analysis, profiling, and transformation
- Excellent communication skills, including presentation and facilitation skills, are critical for this role
- Able to quickly and effectively gather, synthesize and drive resolution of modelling tasks in a cross-functional team environment
- Self-starter and ability to work with minimal supervision
- Detail oriented with strong problem solving skills with analytical mind and creative thinking
- Expert in time management and organizational skills with the ability to manage multiple projects with competing deadlines
- Experience in PowerDesigner or Erwin
Nice-to-have:
- Knowledge in FSLDM (Financial Services Logical Data Model), FpML (Financial Product Markup Language) and Financial Regulatory Reports (Canada, US, UK)
- Knowledge of regulatory data requirements
- Understanding and experience in software development life-cycle
- Experience designing and building systems for extremely high traffic and transaction volumes, such as Data Lake / Hadoop / Databricks environment
- Demonstrate integrity and a constructive approach to challenges
- Lead, coach and mentor others while providing constructive feedback
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
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work
Job SkillsAgile Methodology, Analytical Thinking, Artificial Intelligence Technologies, Business Analytics, Business Data Analysis, Business Needs, Business Process Modeling, Communication, Critical Thinking, Data Analysis, Data Modeling, Data Warehousing (DW), Decision Making, Design Thinking, Finance, Group Problem Solving, Interpersonal Relationship Management, Logical Data Modeling, Requirements Analysis, Teamwork
Additional Job DetailsAddress:RBC CENTRE, 155 WELLINGTON ST W:TORONTO
City:Toronto
Country:Canada
Work hours/week:37.5
Employment Type:Full time
Platform:TECHNOLOGY AND OPERATIONS
Job Type:Regular
Pay Type:Salaried
Posted Date:2026-08-20
Application Deadline:2026-10-31
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.
